Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

Order workflow statuses

These are the predefined order workflow statuses and their meanings.

Order Management List of Shipping Statuses

These are the available shipping statuses in oracle apps order management

What is SUPPLY-TO-ORDER?

‘supply-to-order’ includes both the familiar ‘assemble-to-order’ process in which a specific work order is created to build the item and ‘procure-to-order’ (or back-to-back orders) whereby a specific purchase order is created to fulfill the sales order demand.  ‘Supply-to-order’ items are either standard items or (with OM Family Pack H) models that have the ‘assemble-to-order’ item attribute turned on. It is this attribute that launches the ATO workflows that deliver this feature. PTO models by definition cannot be ‘supply-to-order’, since turning on the ‘assemble-to-order’ attribute would make them an ATO model. But you can have the shippable options of a PTO model be fulfilled via back-to-back orders by checking the ‘assemble-to-order’ item attribute of those components.

Create a Customer

Use Order Management Super User, Vision Operations (USA)

(N) Order Management > Customers > Standard

1. (B) Create.

2. Organization Name: XX-Big City. Leave Alias, D-U-N-S Number, URL, and Context Value.

3. Account Description: Enter a description for your customer.

4. Profile Class: Default.

5. Account Type: External. Leave all other fields, in the Account Information region, blank.

6. Country: United States.

7. Address Line 1: 102 N. LaSalle.

8. City: Chicago.

9. County: Cook

10. State: Illinois.

11. Postal Code: 60610. Leave all other fields, in the Account Site Address region, blank.

12. In the Business Purpose region, set Purpose to Bill To and check the Primary check box.

13. (B) Apply.

14. (B) Create Site.

15. Country: United States.

16. Purpose: Deliver To.

17. (B) Create Address.

18. Address Line 1: 487 Beverly.

19. City: Palo Alto.

20. County: San Mateo.

21. State: California.

22. Postal Code: 94301.

Leave all other fields, in the Account Site Address region, blank.

23. In the Business Purpose region, set Purpose to Deliver To and leave the Primary check box unchecked.

24. (B) Apply.

Defining Release Rules

Select Order Management Super User, Vision Operations (USA) Responsibility

Create Release Rule

1. (N) Shipping > Setup > Picking > Define Release Rules Form > (T) Order

- XX-Seattle’s Rule

- All

2. (T) Inventory

- M1

- XX-Subinventory

- Yes

3. (T) Shipping

- M1-Seattle

- XX-Oldest First

- All Pick Release Document

- Yes

- Yes

4. (M) File > Save.

API to partially Backorder a Pick Released Order Line

Use Shipping API to backorder items on an order which has been pick released

This is achieved using the WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes API. This API should be called with the following input variables.

• source_code := 'OE'; -- The only source code that should be used by the API
• changed_attributes(1).delivery_detail_id := &delivery_detail_id  -- Delivery Detail ID
• changed_attributes(1).shipped_quantity := &shipped_quantity       -- Quantity to be shipped, remainder will be backordered.

The following test case has been executed:

1. Created an Order with three Lines
Line 1 -- PC Mousepad    -- Ordered Qty = 15
Line 2 -- PC Mousepad    -- Ordered Qty = 10
Line 3 -- PC01200097    -- Ordered Qty = 20

2. Navigate to Shipping Transaction Form
3. Search for the order created.
4. Select all three lines and then Launch Pick Release.
5. The status of the lines should change to show that the lines can now be pick confirmed - status should be "Staged/Pick Confirmed". A single delivery should have been created.
6. Obtain the value stored in DELIVERY_DETAIL_ID - this is shown on the Shipping transaction form in the Detail column.
7.  Call the WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes API to change the shipped quantity to 7 (3 items will be backordered)
8. After calling the code, examine the Shipping Transactions Form, lines/lpns tab for the order to see that the Delivery Line will be changed so that the shipped quantity is 7 and the backordered quantity is 3.
9. Ship Confirm the Delivery, The outcome of doing this will be that:
9.1. Ship confirmed 15 of line 1 on the order
9.2. Ship confirmed 7 of line 3 on the order
9.3. BACKORDERED 3 of line 2 on the order
9.4. Ship Confirmed 10 of line 3 on the order

OE Header or OE Lines Table Column Links Back To A Purchase REQ for Back To Back Orders

Unable to link a purchase order and sale order?. There isn't a table column that links from the OE lines to the req lines.

The following sql query can be used to retrieve the data.

SELECT oh.Order_Number,
oh.Header_Id,
ol.Line_Id,
prh.Requisition_Header_Id,
prh.Segment1 req_Number,
prl.Requisition_Line_Id,
Pl.po_Line_Id,
poh.po_Header_Id,
poh.Segment1 po_Number
FROM oe_Order_Headers_All oh,
oe_Order_Lines_All ol,
po_Requisition_Headers_All prh,
po_Requisition_Lines_All prl,
po_Line_Locations_All pol,
po_Headers_All poh,
po_Lines_All Pl
WHERE ol.Header_Id = oh.Header_Id
AND prh.InterFace_Source_Line_Id = ol.Line_Id
AND prh.InterFace_Source_Code = 'CTO'
AND prh.Requisition_Header_Id = prl.Requisition_Header_Id
AND prl.Line_Location_Id = pol.Line_Location_Id
AND pol.po_Header_Id = poh.po_Header_Id
AND pol.po_Line_Id = Pl.po_Line_Id
AND ol.Line_Id = &sales_order_line_id;

Set Defaulting Shipping Document at the time of ship confirm based on the customers

To  default a specific ship confirm document set for a specific customer,

The default ship confirm document set can be set only for a specific organization,  it cannot be set for specific customers.  Therefore, there is no functionality available to create a default document set for a specific customer.   You can, however, define a different document set for each customer and instruct your users to use the correct document set for each delivery that is ship confirmed.

1.  Define a different document set for each customer that requires a unique document set
1.1  As the Order Management super user, navigate to shipping->setup->documents->document sets.
1.2  Define a custom document set and give it a name which will identify the customer or customers for which it should be used.
1.3  Add to the document set all of the documents required by the specific customer(s) for which it is created.

2.  Define ship confirm rules to use the document sets defined in step 1.
2.1  Navigate to shipping->setup->ship confirm rules
2.2  Create a new ship confirm rule,  giving it a name indicating when it is to be used (similar to the document set created in step 1.2)
2.3  Set whatever other parameters are appropriate to this ship confirm rule (for example, ship all or ship entered quantities, specify a default shipping method, etc.)
2.4  At the bottom of the form,  in the Document Set field,  specify the Document Set you created in step 1.2
2.5  Instruct your users to always used the document set which corresponds to the customer to which it applies

If you pick release and ship confirm in one step,  then you can also create a pick release rule unique to each customer.

3.  Define pick release rules to use the ship confirm rules created in step 2:
3.1  Navigate to shipping->setup->picking->Define Release Rules Form
3.2  Give the new rule a name similar to the names of the document set and ship confirm rule from steps 1.2 and 2.2
3.3  Complete all fields in the Order tab as appropriate for your business
3.4  In the Shipping tab,  Autocreate Deliveries and auto Pick Confirm should be set to Yes
3.5   In the Ship Confirm Rule field,  select the ship confirm rule you defined in step 2  (Whenever a ship confirm rule is specified here,  the system will automatically ship confirm the delivery created by pick release.)
3.6   In the Inventory tab,  set Auto Allocate to Yes.
3.7   Instruct your users to always use the correct pick release rule when picking orders for these unique customers.

Now when you pick release an order specifying the pick release rule created in step 3,  the system will automatically ship confirm the order after it is picked using the ship confirm rule created in step 2,  which uses the Document Set defined in Step 1.

How To Progress ATO Lines Passed Supply Eligible?

Various ATO lines are stuck in status of Supply Eligible. You can progress them manually, but how to do this automatically?.

When enter a sales order with an ATO Model on TOP and ATO Items on the lines below, you need to progress each order line manually via "Actions" and "Progress Order" to Create External Requisitions.

In case you do not wish to progress the order manually, there is a concurrent program 'AutoCreate Purchase Requisitions' that picks up all the eligible lines on the basis of what parameters are specified and will dump these lines in requisition interface table. The next run of Requisition Import program will pick up the lines and create requisitions out of them.

Can I update an imported Internal Order through order import?

The functionality of the Update of the Internal Order through the Order

Import is not supported. The code has a valid purpose for 'INSERT'

operation, other operations are not supported and can return the right

or wrong result depending on the data passed for that operation

which is not supported.