Data Flow for Order to Cash Cycle in Order Management

I came across this document in the blog http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html.

1. Order Entry

This is first stage, when the order is entered in the system; it creates a record in order headers and Order Lines table.

Enter header details: Once you enter details on the order header and save it or move it to lines, record goes to one table OE_ORDER_HEADERS_ALL FLOW_STATUS_CODE = ENTERED, BOOKED_FLAG = N), Primary key=HEADER_ID

No record exists in any other table for this order till now.

Enter Line details for this order: Enter different item numbers, quantity and other details in line tab. When the record gets saved, it goes to one table. Order header details will be linked with line details by order HEADER_ID. OE_ORDER_LINES_ALL (FLOW_STATUS_CODE = ENTERED, BOOKED_FLAG = N, OPEN_FLAG = Y) Primary key= LINE_ID

2. Order Booking

This is next stage, when Order is booked then the Flow status changed from Entered to Booked. At this stage, these below table get affected.

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

WSH_DELIVERY_DETAILS

WSH_DELIVERY_ASSIGNMENTS

In shipping transaction form order status remains "Ready to Release".

At the same time, Demand interface program runs in background and insert into inventory tables MTL_DEMAND, here LINE_ID come as a reference in DEMAND_SOURCE_LINE

3. Reservation

This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background and quantities are reserved. Once this program get successfully get completed, the MTL_DEMAND and MTL_RESERVATIONS table get updated. LINE_ID gets updated in DEMAND_SOURCE_LINE_ID in both the tables.

4. Pick Release

Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order.

Pick release can be done from 'Release Sales Order' form or 'Pick release SRS' program can be scheduled in background. In both of these cases all lines of the order gets pick released depending on the Picking rule used. If specific line/s needs to be pick release it can be done from 'Shipping Transaction form. For this case Pick Release is done from 'Release Sales Order' form with Pick Confirm=NO.

Once pick release is done these are the tables getting affected:

If step 3 is not done then MTL_RESERVATIONS gets updated now.

WSH_NEW_DELIVERIES

WSH_DELIVERY_ASSIGNMENTS

WSH_DELIVERY_DETAILS

MTL_TXN_REQUEST_HEADERS

MTL_TXN_REQUEST_LINES (LINE_ID goes as TXN_SOURCE_LINE_ID)

(Move order tables: Here request is generated to move item from Source (RM or FG) sub-inventory to staging sub-inventory)

MTL_MATERIAL_TRANSACTIONS_TEMP

MTL_SERIAL_NUMBERS_TEMP

MTL_SERIAL_NUMBERS

In shipping transaction form order status remains "Released to Warehouse" and all the material still remains in source sub-inventory. We need to do Move Order Transaction for this order. Till this no material transaction has been posted to MTL_MATERIAL_TRANSACTIONS

5. Pick Confirm/ Move Order Transaction

Items are transferred from source sub-inventory to staging Sub-inventory. Here material transaction occurs.

Order line status becomes 'Picked' on Sales Order and 'Staged/Pick Confirmed' on Shipping Transaction Form.

MTL_MATERIAL_TRANSACTIONS_TEMP

OE_ORDER_LINES_ALL

MTL_MATERIAL_TRANSACTIONS

MTL_TRANSACTION_ACCOUNTS

WSH_DELIVERY_DETAILS

WSH_DELIVERY_ASSIGNMENTS

MTL_ONHAND_QUANTITIES

MTL_SERIAL_NUMBERS_TEMP

MTL_SERIAL_NUMBERS

This step can be eliminated if we set Pick Confirm=YES at the time of Pick Release

6. Ship Confirm

Here ship confirms interface program runs in background. Data removed from WSH_NEW_DELIVERIES.

The item on the delivery gets shipped to customer at this stage.

OE_ORDER_LINES_ALL

WSH_DELIVERY_DETAILS

WSH_SERIAL_NUMBERS

MTL_TRANSACTION_INTERFACE

MTL_MATERIAL_TRANSACTIONS

MTL_TRANSACTION_ACCOUNTS

Data deleted from MTL_DEMAND, MTL_RESERVATIONS

Item deducted from MTL_ONHAND_QUANTITIES

MTL_SERIAL_NUMBERS_TEMP

MTL_SERIAL_NUMBERS

7. Enter Invoice

After shipping the order the order lines gets eligible to get transfered to RA_INTERFACE_LINES_ALL. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. This is also called Receivables interface that mean information moved to accounting area for invoicing details. Invoicing workflow activity transfers shipped item information to Oracle Receivables. At the same time records also goes in the table RA_INTERFACE_SALESCREDITS_ALL which hold details of sales credit for the particular order.

RA_INTERFACE_LINES_ALL (interface table into which the data is transferred from order management) Then Autoinvoice program imports data from this table which get affected into this stage are receivables base table. At the same time records goes in

RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_LINES_ALL

8. Complete Line

In this stage order line level table get updated with Flow status and open flag.

OE_ORDER_LINES_ALL (FLOW_STATUS_CODE ‘SHIPPED’, OPEN_FLAG “N”)

9. Close Order

This is last step of Order Processing. In this stage only OE_ORDER_LINES_ALL table gets updated. These are the table get affected in this step.

OE_ORDER_LINES_ALL

OE_ORDER_HEADERS_ALL

Source: http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html

Oracle Shipping Interview Questions

What is a trip?

A trip is an instance of a specific freight carrier departing from a particular location containing deliveries.

A trip is a carrier specific and contains at least two stops, such as a stop to pick up goods and another stop to drop off goods and may include intermediate stops.

Can we create trip manually?

Yes, trips can be created manually and later assign delivery lines.

Eg: For a regular trip scheduled to depart every Friday, you can manually setup a trip ahead of time and then assign delivery lines.

Can we create trip automatically?

Yes, trips can be auto created from deliveries or delivery lines without delivery.

·         Navigate to Query Manager Window

·         Query the Delivery / Delivery Line

·         Select the multiple lines you want to group and create a trip

·         Select the 'Auto-Create Trip' from ACTIONS drop down menu

·         Click GO

How do you associate freight cost to a trip?

·         Navigate to Query Manager Window and find the trip.

·         From the Actions menu, select Assign Freight Costs.

·         Click Go to display the freight cost window

What is Bill of Lading?

The Bill of Lading prints all sales orders that have been confirmed from a selected delivery.

This document lists the ship date, carrier, bill of lading number, delivery name, shipper, ship-to address, carrier name, waybill number, quantity and description of unpacked items, quantity and total of items packed in containers, total quantity of items, and weight/volume information defined in shipping. Any shipping notes you may have created are also printed.

What is Quick Ship?

The Quick Ship window enables you to process shipments quickly, using the minimum shipping requirements. You can access deliveries, trips, and delivery lines/LPNs within the Quick Ship window.

What is Ship Confirming?

Ship Confirming the item removes the existing reservations and performs the sales order issue transaction

What is Delivery?

Delivery consists of a set of delivery lines that are scheduled to be shipped to a customer’s ship to location on a specific date and time.

Can you group multiple deliveries together to create a trip?

Yes.

Can we create Delivery manually?

Yes

Can we create Delivery automatically?

Yes

How do you auto create a Delivery?

You can auto create deliveries at pick release by selecting Auto-Create Deliveries in the Shipping tab.

(Or)

·         Navigate to Query Manager Window and find the delivery lines.

·         Select the delivery lines for which you want to create a delivery.

·         From the Actions menu, select Auto-Create Deliveries and Click Go.

How do you assign a delivery to a trip?

Trip is made of one or more deliveries. When a new delivery is ready to ship and if it can be combined into existing vehicle route then it makes lot easier to plan logistics. Using 'Assign Deliveries to trip' functionality you can assign deliveries to an existing trip.

What is License Plate Number (LPN)?

A packing container has a license plate number for unit identification and reporting capability, so containers are also called LPNs in Oracle Shipping Execution.

What is a Pick Release?

Pick Release finds and releases eligible delivery lines that meet the release criteria, and creates move orders.

You can pick release by order, trip, stop, container, delivery, warehouse, and customer, scheduled or requested dates, shipment priority, or combinations of the above criteria.

What is a Pick Slip?

The Pick Slip Report prints all picking line details in a picking batch. This report is used by warehouse personnel to collect all items included in shipments.

What is One Step Shipping?

One Step Shipping is the process of picking, optionally packing, and ship confirming delivery lines in one step.

For interview questions in Oracle Order Management referhttp://oracleapplicationsfunctional.blogspot.com/2011/06/oracle-11i-order-management-interview.html

Move Orders in Oracle Apps

Move orders are requests for the movement of material within a single organization. They allow movement of material within a warehouse or facility for purposes like replenishment, material storage relocations, and quality handling. You can generate move orders either manually or automatically.

Move orders are restricted to transactions within an organization. If you are transferring material between organizations you must use the internal requisition process.

There are three types of move orders in Oracle:

Move Order Requisition

A move order requisition is a manually generated request for a move order. It is available for sub-inventory transfers and account transfers. Once a requisition has been approved, it becomes a move order. These requests can optionally go through a workflow-based approval process before they become move orders ready to be sourced and transacted.

Replenishment Move Order

You can automatically create pre-approved move orders using the following planning and replenishment functions. These processes generate move orders if the material is sourced from another inventory location within the organization.

Min-Max Planning:  When a minimum quantity for a specific item is reached in inventory, you can use a move order to replenish the supply. 

Replenishment Counting: If a system that uses replenishment counting triggers an item for replenishment, you can use move orders to replenish the supply. 

Kanban Replenishment: When a Kanban card signals the need to release an item into a sub-inventory, you can generate a move order to handle the release.

Pick Wave Move Orders

Pick wave move orders are pre-approved requests for subinventory transfers to bring material from a source location in the warehouse to a staging subinventory. These move orders are generated automatically by the Oracle Shipping Execution pick release process.

For all move orders, the final result is one of the two supported transactions:

1.      Subinventory Transfer or

2.      Account Issue.

Move Order Process Flow:

Create a move order for required material

Approve the move order lines

Allocate the move order

Print a pick slip

Transact move order lines

Note:

·         Replenishment and Pick Wave move orders are pre-approved.

·        The Move Order Pick Slip report generates pick slips for move order requisitions and replenishment move orders. To generate a pick slip for pick wave move orders, you need to submit the Oracle Shipping Execution Pick Slip report.

Reasons for Common Error during Pick Release

Possible reasons for Error during Pick Release are as follows:

No default staging sub-inventory for the item

Navigate to Shipping àSetup àShipping parameters

Go to the Pick Release tab. Select a default Stage Subinventory in the field Staging. The default staging Subinventory must not be the same as the Subinventory from which the items will be picked.

If locator controlled items are being shipped, the Staging Subinventory must be defined as having locator control.

No Sub-inventory defined while picking the order

Specify a Subinventory in the "Pick From" region of the Release Orders for Picking form, inventory tab.

If this is done, pick release will always pick from that Subinventory.  However, if the specified Subinventory does not have sufficient quantity, pick release will not consider any other Subinventory for picking.

No open period exists for pick release

Open the inventory accounting period for the period in which the order is scheduled to ship.

1) Navigate to Inventory àAccounting Close Cycle àInventory Accounting Periods

2) Select the period to be opened. Its current status should be Future

3) Click on the change status button.

4) A small dialog box asks if you want to open this period. Click on Yes.

(Or)

Change the requested date on the order to a date within an open period

1) Navigate to Order Management Super User à Sales Orders form

2) Go to the Line Items/Shipping tab.

3) For each order line, change the requested date to a date which is in an open inventory period.

4) If the scheduled ship date does not automatically change to a date within the open period, then also change the scheduled ship date. 

(Or)

 Transact the move order in the open period.

1)  Navigate to Order Management Super User à Pick Release form.

2) Pick Release the order. Specify Auto Allocate as NO, so that move orders will not be automatically transacted.

3)  Switch to the Inventory user

4)  Navigate to Move Orders àTransact Move Orders, and find the Move order for this order.

5)  Allocate the move order

6)  Click on the View/Update allocations button

7)  In the form which follows, reset the date on the move order to a date in an open period.

If the order was initially scheduled to ship during a period which is now closed, only the last two options are available. Once a period has been closed, it cannot be re-opened.

Partial shipment did not occur because order lines are in ship set

When a single order line is on a ship set and enforce ship sets are specified, the entire quantity must be shipped. System will not split this order line, and will not create a backorder for the amount of the shortage.

If one line on the ship set has insufficient quantity, none of the other lines will be pick released. In this case, the pick release log file and/or shipping exceptions report will show error message "Item 1 is on a ship set, and item 2 on the same ship set has insufficient quantity"

Remove the line with insufficient quantity from the ship set

1) Navigate to Order Management Super User à Sales Orders form.

2) Find the order you are attempting to pick release

3) Go to the Line Items àShipping Tab.

4) Remove any value in the field ship set

(Or)

Uncheck the 'Enforce Ship Set' parameter in the Shipping Parameters screen

1) Navigate to Shipping à Setup à Shipping parameters

2) Go to the Pick Release tab

3) Uncheck the box labeled Enforce Ship Sets and Ship Models

No Locator specified during pick release for Locator Controlled Item and No default Locator exists

Set up a default locator for the item in the Inventory Item transaction defaults as follows:

1) Navigate to Inventory à Setup à Transactions àItem Transaction Defaults

2) Click New, click the Locator tab, and click New again

3) Enter your item,

4) Enter a type of Move Order Receipts

5) Enter the Subinventory and the Locator you want to use as the default

Delivery details has been already assigned to the Delivery

This issue is resolved by checking the check box "Include Assigned Lines" on the Shipping tab of the Pick Release form

Other Reasons:

·         Ensure that the Sales Order Key Flexfield segments are mapped to Order Number, Order Type and Order Source.

·         Also ensure that the profile option OM: Source Code is set to 'ORDER ENTRY'.

·         When attempting to pick release orders with future scheduled ship dates, ensure that the "TO" schedule ship date in the pick release form is either null, or contains a date future to the scheduled ship dates on the orders to be picked.

Order to Cash (O2C) Cycle in Order Management

Enter the Order

Go to Order Management Super user à Orders, Returns à Sales Order

In the Main tab, enter the Customer Name, Order Type, Price List and Sales Person.

In the Line Items tab, enter the Item, Qty and Save. Now the Sales Order Line Status will be Entered.

Book the Order

Click the Book Order button to Book the order.  Now the Sales Order Header wiil be Bokked and Line Status will be Awaiting Shipping.

Pick Release

Go to Shipping à Release Sale Order à Release Sales Order

In the Order tab, enter the Order Number

In the Shipping tab, select Auto Create Delivery and Auto Pick Confirm to YES.

In the Inventory tab, select Auto Allocate to YES

Click Execute Now button. Confirmation message will be displayed.

Go to View à Requests à Find

Make sure that the Pick Slip Report is Completed Normal.

Ship Confirm

Go to Shipping à Transactions

Enter the Order Number in the From Order Number and To Order Number field and Click Find. Shipping Transactions form opens with Delivery Number, Item details, Order Details and Customer Details.

The Line Status will be Staged/Pick Confirmed.

Go to Delivery tab and click the Ship Confirm button. Confirm Delivery window opens. Click OK.

Confirmation Message will be displayed.

Now, you can see the Line Status as Shipped.

Auto Invoice

Go to View à Requests à Submit a New Request à Workflow Background Process.

Enter Item Type as OM Order Line

Process Deferred as Yes

Process Time Out as No

Make Sure that the request is completed Normal.

Navigate to Orders, Returns à Order Organizer. Enter the Order Number and click Find.

Sales Order Line Status will be Closed now.

Right click on the line and go to Additional Line Information à Invoices.

You can see the Invoice Number for this Order. To see Invoice details, click on the Invoice Details tab.