Base Tables For Order To Cash 1 2048

Base Tables for Order to Cash (O2C) Cycle in Oracle Apps
1. Order Entry
This is the first stage where Order is entered into the system. It creates a record in Headers
table and Lines table
OE_ORDER_HEADERS_ALL:
This table stores the Header Information of the Sales Order
Important columns in this table:
HEADER_ID: Unique system generated ID
ORG_ID, ORDER NUMBER, SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID and FLOW_STATUS_CODE
At the time of Order Entry, the FLOW_STATUS_CODE is 'Entered'
Sample code:
SELECT HEADER_ID, ORG_ID, ORDER_TYPE_ID, FLOW_STATUS_CODE,
TRANSACTIONAL_CURR_CODE, SHIPPING_METHOD_CODE,
SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID FROM OE_ORDER_HEADERS_ALL
WHERE ORDER_NUMBER=66405;
OE_ORDER_LINES_ALL:
This table stores the Line Information of the Sales Order
Important columns of this table
LINE_ID: Unique system generated ID
HEADER_ID: It is the link between OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL
ORDERED_ITEM, INVENTORY_ITEM_ID, PRICING_QUANTITY,
ORDERED QUANTITY, FLOW_STATUS_CODE and UNIT SELLING_PRICE_PER_PQTY
Sample code:
SELECT LINE_ID FROM OE_ORDER_LINES_ALL WHERE HEADER_ID= 190452;
SELECT ORDERED_ITEM, INVENTORY_ITEM_ID, PRICING_QUANTITY, ORDERED_QUANTITY,
FLOW_STATUS_CODE,
UNIT_SELLING_PRICE_PER_PQTY FROM OE_ORDER_LINES_ALL WHERE LINE_ID= 388401;
2. Order Booking
Order Booking is the final stage in the Sales Order entry. Now that the Order Entry process is complete and that
the order is eligible for the next stage in the line flow for this order, as defined by its Transaction Type. By clicking
Book Order button, the Order is booked.
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
WSH DELIVERY DETAILS
When the Order is Booked, the FLOW_STATUS_CODE in OE_ORDER_HEADERS_ALL
would be 'BOOKED' and the FLOW STATUS_CODE in OE ORDER LINES ALL would be 'AWAITING_SHIPPING'
RELEASED_STATUS in WSH_DELIVERY DETAILS would be 'R' (means- ready to release)
Important columns of WSH_DELIVERY_DETAILS table:
DELIVERY_DETAIL_ID: Unique system generated id with reference to
SOURCE_HEADER_ID (it is the HEADER_ID from OE_ORDER_HEADERS_ALL)
SOURCE_HEADER_ID: It is the HEADER_ID generated from OE_ORDER_HEADERS_ALL
SOURCE_LINE_ID: It is the LINE_ID generated from OE_ORDER_LINES_ALL
RELEASED_STATUS, SOURCE_CODE, CUSTOMER_ID, INVENTORY_ITEM_ID, SHIP_FROM_LOCATION_ID,
SHIP_TO_LOCATION_ID, MOVE_ORDER_LINE_ID, REQUESTED_QUANTITY, SHIPPED_QUANTITY, SUBINVENTORY,
SHIP_METHOD_CODE etc.
Sample Code:
SELECT DELIVERY_DETAIL_ID, SOURCE_HEADER_ID, SOURCE_LINE_ID, SOURCE_CODE, CUSTOMER_ID,
INVENTORY_ITEM_ID, ITEM_DESCRIPTION, SHIP_FROM_LOCATION_ID, SHIP_TO_LOCATION_ID,
MOVE_ORDER_LINE_ID, REQUESTED_QUANTITY, SHIPPED_QUANTITY, SUBINVENTORY, RELEASED_STATUS,
SHIP_METHOD_CODE, CARRIER_ID FROM
WSH_DELIVERY_DETAILS WHERE SOURCE_HEADER_ID= 190452;
---------------------------
3. Launch Pick Release:

Pick release is the process by which the items on the sales order are taken out from inventory. This process
allocates on-hand inventory to your order and inform the warehouse personnel to move the item from inventory
to the shipping staging area. Once your item is in the shipping staging area, it is ready to be shipped.
OE_ORDER_LINES_ALL: Here the FLOW_STATUS_CODE should be 'PICKED' or 'AWAITING_SHIPPING' depending on
Auto Pick Confirm (set to No or Yes)
WSH_DELIVERY DETAILS: Here RELEASED STATUS should be 'S' (Submitted for Release) or 'Y' (Pick Confirmed).
These values again depend on the parameters given at Auto Pick Confirm (set to No or Yes)
WSH_DELIVERY_ASSIGNMENTS: DELIVERY_ID is populated here (from DELIVERY_DETAIL_ID with reference to
WSH_DELIVERY_DETAILS table)
Sample Code:
SELECT DELIVERY_DETAIL_ID FROM WSH_DELIVERY_DETAILS WHERE
SOURCE_HEADER_ID= 190452;
SELECT DELIVERY_ASSIGNMENT_ID, DELIVERY_ID, PARENT_DELIVERY_ID, DELIVERY_DETAIL_ID,
PARENT_DELIVERY_DETAIL_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED BY,
ACTIVE_FLAG, TYPE FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID= 3966467;
4. Ship Confirm the Order:
It is a process of sending the Items from shipping staging area to the Customer site. By ship confirming you will
notify EBS that the shipment is complete and thereby updating the on-hand Inventory. Ships confirm process will
kick off the following Concurrent Programs:
Interface Trip stop, Packing slip Report, Bill of Lading, Commercial Invoice
OE_ORDER_LINES_ALL: Here the FLOW_STATUS_CODE should be ‘SHIPPED’
WSH_DELIVERY DETAILS: Here RELEASED STATUS should be 'C' (Shipped)
5. Creating Invoices in Receivables:
Here the Invoices are created based on the goods sold. We need to run the 'Workflow Background Process' where
it picks the shipping records and transfers to Receivables interface
Workflow Background Process inserts new records in RA_INTERFACE_LINES_ALL
----------------------
Important columns of this table:

INTERFACE_LINE_ID: It is the LINE_ID with reference to OE_ORDER_LINES_ALL
INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE3
Sample Code:
SELECT INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE3 FROM
RA_INTERFACE LINES ALL WHERE
INTERFACE_LINE_ID= 388401;
INTERFACE_LINE_CONTEXT:
Order Entry
INTERFACE LINE ATTRIBUTE1:
Order Number
INTERFACE_LINE_ATTRIBUTE3:
Delivery ID
RA_CUSTOMER_TRX_ALL: Stores Invoice header information.
INTERFACE_HEADER_ATTRIBUTE1 column will have the Order Number.
INTERFACE_HEADER_ATTRIBUTE2 column will have Order Type
TRX NUMBER column is the Invoice Number
Sample Code:
SELECT INTERFACE_HEADER_ATTRIBUTE2, CUSTOMER_TRX_ID, TRX_NUMBER, CUST_TRX_TYPE_ID,
COMPLETE_FLAG, SHIP_DATE_ACTUAL FROM RA_CUSTOMER_TRX_ALL WHERE
INTERFACE_HEADER_ATTRIBUTE1= '66405';
RA CUSTOMER TRX LINES ALL: Stores Invoice lines information.
INTERFACE_LINE_ATTRIBUTE1 column will have the Order Number.
INTERFACE_LINE_ATTRIBUTE2 column will have Order Type
INTERFACE_LINE_ATTRIBUTE3 column will have Delivery
INTERFACE_LINE_ATTRIBUTE4 column will have Waybill
INTERFACE_LINE_ATTRIBUTE5 column will have count
-----------------------
INTERFACE_LINE_ATTRIBUTE6 column will have Line ID

INTERFACE_LINE_ATTRIBUTE7 column will have Picking Line ID
INTERFACE_LINE_ATTRIBUTES column will have Bill of Lading
INTERFACE_LINE_ATTRIBUTE9 column will have Customer Item Part
INTERFACE_LINE_ATTRIBUTE10 column will have warehouse
INTERFACE_LINE_ATTRIBUTE11 column will have Price Adjustment
INTERFACE_LINE_ATTRIBUTE12 column will have Shipment Number
INTERFACE_LINE_ATTRIBUTE13 column will have Option Number
INTERFACE_LINE_ATTRIBUTE14 column will have Service Number
6. Create Receipt
Underlying tables:
AR_CASH_RECEIPTS_ALL
CASH_RECEIPT_ID is the unique system generated ID
FLOW_STATUS_CODE in OE_ORDER_LINES_ALL should be 'CLOSED'

Base Tables For Order To Cash 1 2048

Uploaded by

Copyright:

Available Formats

Base Tables For Order To Cash 1 2048

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Base Tables For Order To Cash 1 2048

Uploaded by

Copyright:

Available Formats

Base Tables for Order to Cash (O2C) Cycle in Oracle Apps

3. Launch Pick Release:

Important columns of this table:

INTERFACE_LINE_ATTRIBUTE6 column will have Line ID

You might also like