O2C

#  O2C Technical Flow.............

1.Order Entry
        --Order number is Generated.
• OE_ORDER_HEADERS_ALL (FLOW_STATUS_CODE = ENTERED)
• OE_ORDER_LINES_ALL   (FLOW_STATUS_CODE =ENTERED)

2.Order Booking
        --when Order is booked then the Flow status changed from Entered to Booked.
        --  At the same time DEMAND INTERFACE PROGRAM runs in the background and inserts into MTL_DEMAND.

• OE_ORDER_HEADERS_ALL    (FLOW_STATUS_CODE= BOOKED)
• OE_ORDER_LINES_ALL      (FLOW_STATUS_CODE= AWAITING_SHIPPING)
• WSH_NEW_DELIVERIES      (STATUS_CODE = OPEN)
• WSH_DELIVERY_DETAILS    (RELEASED_STATUS = ‘R’( ready to release).

3. Pick Release
        -- Pick release can be done from 'Release Sales Order' form or 'Pick release SRS' program can be scheduled in background.
        --Pick release program kick off  reports like
              1. Pick slip report
              2. Shipping exception Report
              3. Auto pack Report.

• OE_ORDER_LINES_ALL      (FLOW_STATUS_CODE = PICKED)
• WSH_DELIVERY_DETAILS    (RELEASED_STATUS = S (SUBMITTED)
• MTL_TXN_REQUEST_HEADERS
• MTL_TXN_REQUEST_LINES

4. Pick Confirm
        --Items are transferred from salable sub-inventory to staging Sub-inventory. Here material transaction occurs.
• OE_ORDER_LINES_ALL   (FLOW_STATUS_CODE = ‘PICKED’ )
• WSH_DELIVERY_DETAILS (RELEASED_STATUS = ‘Y (‘Released’ )
• WSH_DELIVERY_ASSIGNMENTS
• MTL_MATERIAL_TRANSACTIONS
• MTL_TRANSACTION_ACCOUNTS.

5. Ship Confirm
--Here ship confirm interface program runs in background. Data removed from wsh_new_deliveries.
--Concurrent Programme Kick off  reports like
          1. Interface Trip stop, 2. Commercial Invoice
          3. Packing slip report 4. Bill of Lading.

• OE_ORDER_LINES_ALL   (FLOW_STATUS_CODE = ‘SHIPPED’)
• WSH_DELIVERY_DETAILS (RELEASED_STATUS = ‘C’ (Shipped’)
• MTL_MATERIAL_TRANSACTIONS
• MTL_TRANSACTION_INTERFACE

6. Enter Invoice
       --Runs workflow background process then invoicing workflow activity transfers shipped item information to Oracle receivables.
       --Then Auto invoice program imports data from interface table into receivables base tables.
• RA_CUSTOMER_TRX_ALL
• RA_CUSTOMER_TRX_LINES_ALL
7. Receipts
--After taking amount from the customer we have to make receipts. At this stage these  table will be effected
• AR_CASH_RECIPTS_ALL
• AR_RECEIVABLE_APPLICATION

8. Transfer to GL
 --Run the general Ledger transfer program to submit to GL_INTERFACE table.
--Run the Journal Import programe to transfer accounting information from Interface table to General Ledger.
--Post the Journal batches to update the account balaces General Ledger.
• GL_INTERFACE.
• GL_JE_BATCHES,
• GL_JE_HEADERS,
• GL_JE_LINES,
• GL_BALANCES.

9.  Close Order
OE_ORDER_LINES_ALL (FLOW_STATUS_CODE ‘closed’)