Processing Constraints in Oracle Order Management

Processing constrains are a security framework where we can define rules in oracle order management that validate back-end operations such as Create, Update, Delete and Cancel.

Eg:

We cannot change the order type in the order header once the order is booked.

We cannot delete the line in an order once the order status is closed.

N: OMàSetupàRulesàSecurityàProcessing Constraints

Query the application as Order Management

Create a new line on the constraints region

Operation = Update

Attribute = Order Type

User Action = Not Allowed

Enabled check box = Selected

Create a new line on conditions tab:

Group Number = 101

Scope = Any

Validation Entity = Order Header

Record Set = Order

Validation Template = Booked

Enabled Check box = Selected

User Message = Order is Booked

RMA SO

RMA SO:

1.       Enter SOàBook SOàCreate ReceiptàCreate Credit Memo (Line flow generic return with Receipt Credit only)

2.       Enter SOàBook SOà Create Credit Memo (Line flow generic return Credit only)

3.       Enter SOàBook SOàCreate ReceiptàCreate New LineàPick ReleaseàShip Confirm (Same or Different Item) (Return with receipt only no credit and ship only)

4.       Enter SOàBook SOàCreate ReceiptàCreate Credit Memo

Entered

Booked

Awaiting Return

Drop Ship SO

Drop Ship SO:

Flow:

Enter SO à Book SO à Submit WFBE à Submit Requisition Import à Find Auto Gen PR à Auto Create PO à Create receipt for Logical QTY

Statuses:

Entered

Booked

Awaiting Receipt (Requisition Import àPOàInv Receipt)

Shipped (Submit WFBE)

Setup or Questions:

Source Type is External

Shipments Tab – Drop Ship - Shipping details available

--------------------------------------------------------------------------

Drop Ship Sub inventory:

Status                                   : Unserviceable

Material Status                 : N

Include in ATP                   : N

Allow Reservations         : N

Nettable                              : N

Quantity Tracked             : Unchecked

Back to Back SO

Back to Back SO:

Flow:

Enter SO à Book SO à Progress Order à Submit Requisition Import à Find Auto Gen PR à Auto Create PO à Create receipt for QTY à Pick Release à Ship Confirm à

Statuses:

Entered

Booked

Supply Eligible (Progress Order LineàCreate Supply Order – EligibleàRequest Submitted)

External Requisition Requested (Requisition ImportàSource: CTOàCreate Inv Receipt)

Awaiting Shipping (Pick and Ship)

Shipped (Submit WFBE)

Setup or Questions:

Remove Assignments set from MRP: Default Sourcing Rule Assignment Set

Source: Internal

OM: Assemble to Order

When Source: Internal & ATO check box enabled its back to back line

Reasons:

To avoid customer’s knowing the actual costs of the product.

We may lose the customer.

Some time we need to add accessories to the product from our inventory.

http://oracleapplicationsfunctional.blogspot.in/2011/08/back-to-back-order-flow-in-oracle-r12.html