Key Features of Interface Trip Stop Process (ITS) in Order Management

In Oracle Order Management, Interface Trip Stop (ITS) will be trigger at the time of Shipping if check box “Defer Interface” is not check.
ITS can also be executed from concurrent request.

ITS has to main components.
Update the Order Management Data (oe_order_lines_all) .
Trigger the Inventory Interface (to Update the Inventory tables).

Inventory Interface will be trigger only if the first part, that means related to OM has successfully completed and flag OE_INTERFACED_FLAG = ‘Y’ on WSH_DELIVERY_DETAILS.If value of this flag is N/P then Inventory Interface will never be triggered. And even if you try to submit the Inventory Interface from SRS, delivery detail with oe_interfaced_flag =’N’ will never be picked up.

ITS update the following fields on oe_order_lines_all table
1.Shipped_quantity
2.shipping_quantity,
3.Actual_shipment_date.

Above is just simple input about basic process for ITS , apart from it other feature of OTS are
1.Line spliting .
2.Progress the Order line to FULFILL Deferr Status (depend on your workflow).

Please Note that if you are sharing trip/delivery across the Orders then ITS will progress all the orders that belongs to Trip/Delilvery.

For Common errors that occure during ITS , refere my blogs
http://eoracleapps.blogspot.com/2009/10/3133-activity-instance-fulfillline-is.html

And

http://eoracleapps.blogspot.com/2009/10/its-error-wf-completeactivity-error-ora.html

you can leave your comments , if you have question.

Role in Oracle WORKFLOW

Role in Oracle Workflow
In Oracle workflow we need a role for notification activity.Workflow engine calls the notification system to deliver a notification message to an appropriate role.Once user of that role completes the notification response, the workflow Engine continues to drive through the remaining activities in process

Message -The information sent by notification activity.The message may request the performer (the role receiving the message) to do some work or may simply provide information.

A Role is grouping of one or more user who share the common responsibility.A role can contain more than 1 user.Oracle workflow send notification to roles.

Oracle stores Roles related information in following table & Views.

WF_USERS - contains info. on user
WF_ROLES - contain Info. on roles of whoch user can be member.
WF_USER_ROLES - Have assocation between user with roles.
WF_USER_ROLE_ASSIGNMENTS_V - Tracks assignments of user to roles.

For Oracle Notification to work there should always a Role assign to Performer attribute of the Notification Activity.A performer is a role that can consist of one or more users.You can specify a

1. Static Role

2. Dynamic Role

Static Role - It is a constant Value.Specify a Hardcoded Role name.
Dynamic Role - Define an Item Attribute and assign that item attribute to Notification Performaer.At Run time populate the Item attribuet value with ROLE(based on your requirements).

Oracle Workflow has provided standard PL/SQL APIs to create ad Hoc users and Roles ar runtime.

For More Infor on Workflow - refer
http://eoracleapps.blogspot.com/2008/07/oracle-workflow-concept.html

http://eoracleapps.blogspot.com/2008/07/how-to-customized-oracle-om-worflow.html

Serial Control Item & Drop Ship in Oracle Apps

Do Oracle Apps Order Management Drop Ship process Support Serial control item.

Answer - Yes, drop ship flow in Oracle OM do support serial control item.

Create Drop Ship Order for Serial Control Item.
1.Create Req, PO , Approve PO and then receipt against PO in LOGICAL Inventory .
2.Run Process Transaction Interface

3.Check Material Transaction for your item

4.You can see one INBOUND and one OUTBOUND Transaction for Item along with Serial details.

Why Internal and External requisistion for Drop Ship Sales Order in OM

For a Drop shiporder why some time Sales order create "Internal requisition" rather than "External requisition".Internal or External requisition are created are based on the Requisition "Source Type".If Source type is "Vendor " then system will create "External Requisition", but if it is "Inventory" then it will create "Internal requisition".

Tips for OM

What is OE_INTERFACED_FLAG in WSH_DELIVERY_DETAILS table.

When we execute the Interface trip stop in Order management , it updates data in oe_order_lines_all table (shipping_quantity , shipped_quantity and actual_shipment_date) and the update the oe_interfaced_flag to 'Y' to indicate that OM part has been complete sucessfully and then proceed with Inventory Interface.

Can we Create Sales Order in 1 UOM and shipped goods in Another UOM
Yes

How Bill Only Flow is different from Ship Only flow in Oracle Order Management Workflow.
In Bill Only work flow we have Invoicing activity , but no shipping activity , where as in Ship only workflow is other way around.

Is it ok to Cancel the Backorder deliveries in Oracle OM.
As long as your business process support , it is ok to cancel the baclorder deliveries .But there is no Standard UI to do so .

For a Drop shiporder why some time Sales order create "Internal requisition" rather than "External requisition".

Internal or External requisition are created are based on the Requisition "Source Type".If Source type is "Vendor " then system will create "External Requisition", but if it is "Inventory" then it will create "Internal requisition".

How to create Concurrent Program in Oracle Applications

In this blog I will explain with diagrams how to create concurrent Program in Oracle Apps .

Below are simple steps to create

1. Executable
2. Concurrent program and then
3. Attach Concurrent Program with Request Group.

Login as Sysadmin or Application Developer

Create Executable

Navigate to Concurrent > Executable.Define your executable as shown below.

Create Concurrent Program

• Navigate to concurrent program (CP) screen.
• Eneter Name for CP.Short Name should be same as short name of executable.(It's Best Practice).
• Check the enable check box.Select executable name from LOV.
• Select the output format for CP.

• Define Parameter. For each Parameter
  1.Select the Value Set .
  2.Default Type.
  3.Default value for Set
  4.Default Value.

• After Saving the Concurrent Program, Attach it with requied Request Set.
• Choose the group where you want to attach CP
• Add Concurent program