Realms Setup In iProcurement

Realms restrict the user access to iProcurement categories in any of two level

1. Responsibility level

2. User level

Define Realms:

Responsibility: Purchasing SuperUser

Navigation: Setup > E-catalog Admin > Realms

Enter Realms on the form as shown below

The iProcurement categories are attached to the Realm as components. We have a choice of attaching Item Sources or Categories asComponent Type. The Component Type LOV is given below

1.Responsibility level:

Now the realms are all setup. We shall now assign the realm to the responsibility and/or user. First let us assign the realm to a responsibility. Open the responsibility form.

Responsibility: System Administrator

Navigation: Security > Responsibility > Define

Fulfillment Set In Sales Order

Oracle has offered fulfillment set to group all the lines that we want to fulfill together
lets's say we have sales order with 3 lines and as per business requirement we want to fulfill these lines together.
But there is a possibility

1. one of the line in the order is already shipped and ready for fulfill.
2. second line still not shippped and is in status Awaiting Shipping and 
3. 3^rd line got Back-ordered. status. With the above scenario it is very clear that these lines once fulfilled  goes to different Invoices

Solution - But if we want to fulfilled and invoiced these lines together , this can be done with the help of FULFILMENT SET.If a line is part of fulfillment set , it will not progress beyond the fulfill  activity (Workflow activity - FULFILL_LINE) till all other lines in the same fulfillment set reach to FULFILL_LINE workflow activity. Once  last eligible line in the Set reached FULFILL_LINE activity it will progress all lines of the SET

How to assign lines to Fulfillment Set (Same Set as Order header Fulfillment Set). 

• Create an Order and check the Fulfillment Set check box.
• Create Order lines and all the lines in the order automatically added to same fulfillment set.

PL/SQL Script To Create Asset Numbers In Oracle EAM R12

Sample Script :-

set serveroutput on
declare
g_Return_Status VARCHAR2(1000);
g_Msg_Count NUMBER;
g_Msg_Data VARCHAR2(1000);
g_Object_Id NUMBER;

begin

fnd_global.apps_initialize (user_id => 1318,resp_id => 23118,resp_appl_id => 426);

EAM_ASSETNUMBER_PUB.Insert_Asset_Number
(  p_api_version => 1.0,
   p_init_msg_list => FND_API.G_FALSE,
 p_commit => FND_API.G_FALSE,
 p_validation_level => FND_API.G_VALID_LEVEL_FULL,
 x_return_status => g_Return_Status,
 x_msg_count => g_Msg_Count,
 x_msg_data => g_Msg_Data,
 x_object_id => g_Object_Id,
 p_INVENTORY_ITEM_ID => 7891,
 p_SERIAL_NUMBER => 'VEH99',
 p_INSTANCE_NUMBER => NULL,
 p_CURRENT_STATUS => 4,
 p_DESCRIPTIVE_TEXT => NULL,
 p_CURRENT_ORGANIZATION_ID => 4812,
 p_ATTRIBUTE_CATEGORY => NULL,
    p_WIP_ACCOUNTING_CLASS_CODE => NULL,
    p_MAINTAINABLE_FLAG

Work Order Relationship Types in Oracle eAM

In Oracle Enterprise Management we can define 4 different type of relationships between work orders.

1. Parent Child.
2. End to Start Dependency,
3. Cost
4. Follow-up Work

Relationship between work orders helps to manage complex maintenance jobs.

1. Parent Child: This relationship enables a network of Work Orders, which includes one top level Work Order that defines the time line of all its children Work Orders. The start and end dates of the children Work Orders are within  the start and end dates of the parent Work Order. A child Work Order can be parent to another Work Order. One parent can have multiple children, but one child can have a single parent. There can be an infinite number of parent-child Work Order levels, within the Parent-Child relationship.
2. End to Start Dependency: You can create Work Orders with scheduling dependency relationships (including child sibling Work Orders). For example, one Work Order's scheduled start date is dependent on another Work

Two Step Material Issue Vs One Step material issue

User has two different option to issue the materials for a work order in Oracle eAM, Those are 1.Two step material issue, 2.One step material issue

1.Two Step Material Issue: - System will Perform 

1. Material Allocation and then 
2. Material Issue 

Material Allocation will be performed as soon as eAM Work Order got Released and after that user need to perform the material issue for Self Service Page .. Store > Two Step material issue > Issue

Note: For Allocation to be triggered at the Time of Work Order Release , please make sure that Auto Allocate Flag is ON at the Material Order Line as well as Work Order Header ( In WO header it got defaulted from Parameter - Enable Material issue request ) 

2.One Step Material Issue:- we don't perform Allocation, user can directly issue the Material.

Another Advantage of One Step Material issue is , it let you do Over Issue