Monday 10 February 2014

line status during the sales order process?

Entering the sales order                         Entered
Booking the sales order                         Awaiting shipping (when sufficient quantity is available)
Supply eligible (when sufficient quantity is not available)
Pick release the order                          Picked
Ship confirm the order                          Shipped
Running interface trip stop                    Closed

Header status during the sales order process?

Entering the sales order                         Entered
Booking the sales order                         Booked
Pick release the order                            Booked
Ship confirm the order                           Booked
Running interface trip stop                     Booked

How to set ORG_ID in11i?

Begin
FND_CLIENT_INFO.SET_ORG_CONTEXT(204);
end;

begin
dbms_application_info.set_client_info(103);
end;

How to set ORG_ID in R12?

By using mo_global.set_policy_context
mo_global.set_policy_context has two parameters p_access_mode & p_org_id

p_access_mode:
S In case you want your current session to work against Single ORG_ID
M In case you want your current session to work against multiple ORG_IDs

p_org_id: Only applicable if p_access_mode is passed value of "S"

Syntax:
Begin
mo_global.set_policy_context(‘S’, &org_id);
End;

e.g.
Begin
mo_global.set_policy_context(‘S’, 103);
End;