O2C Cycle Oracle Apps R12

O2C CYCLE steps

Steps

1. Enter sales order
2. Book the sales order
3. Pick release ( Release sales order)
4. Move order
5. Ship confirm
6. Create Invoice
7. Create Receipt
8. Transfer to General ledger
9. Journal import
10. journal posting

---

1. CREATE SALES ORDER 
   1. Header
      1. With customer info
   2. Line with item info
   3. Check availability qty of item
   4. Check the bank end tables
      1. OE_ORDER_HEADERS_ALL
         1. Flow_status_code = Entered
      2. OE_ORDER_LINES_ALL
         1. Flow_status_code = Entered 
2. BOOK SALES ORDER 
   1. Sales order status : booked
   2. Check the back end tables
      1. OE_ORDER_HEADERS_ALL
         1. Flow_status_code = Booked
      2. OE_ORDER_LINES_ALL
         1. (Flow_status_code = Awaiting shipping)
      3. WSH_DELIVERY_DETAILS
         1. RELEASED_STATUS= 'R' (ready to release)
      4. WSH_DELIVERY_ASSIGNMENTS
         1. new row inserted
   3. Backgroud programs
      1. DEMAND INTERFACE PROGRAM
3. PICK RELEASE ( Release sales order) [ Items in SO must be released from inventory ]
   1. Nav :( Shipping > Release sales order > Release sales order)
   2. search sales order
      1. auto create delivery ,Auto pick confirm, Auto pack delivery, Auto allocate = 'Y'
      2. Click 'Execute now' button
      3. Pick release process completes successfully and calls programs
         1. Auto pack report
         2. shipping exception report
         3. Pick slip report
   3. Back end tables 
      1. WSH_NEW_DELIVERIES ( NEW ROW CREATED)
      2. WSH_DELIVERY_DETAILS
         1. ( if Auto pick confirm = y )
            1. RELEASED_STATUS= 'S' (Release to warehouse)
         2. else do following from step 4 
4. PICK CONFIRM (Move order )[ Confirning that the released item is picked for shipping ]
   1. (Nav: Inventory super user > Move order > Transact move order)
   2. search with 4th number in 'pick slip report' (batch request number)
      1. click 'view update allocation ' > click Transact button > Transact button will be deactivated
      2. close Transact move order form
   3. Go to order organizer form> search SO number > additional info > deliveries tab > pick status > Staged / Pick confirm
   4. > view delivery details button > Delivery line details button >
      1. Line status : Staged / Pick confirm
      2. Next step  field value : ship confirm
5. SHIP CONFIRM [ Confirming that the item is Shipped at customers location ]
   1. Nav : OM > Shipping > tansactions
   2. query order number
   3. Click on Delivery tab shows > click Ship confirm button 
      1. Enable following  : Yes 
         1. Ship entered qty :  
         2. Create delivery for staged quantities : yes
         3. Set delivery in transit : yes
         4. Create bill of lading : yes
         5. Close trip: yes
      2. Get a message saying : Delivery was successfully confirmed 
   4. Ship confirm will call other programs like, in Run> View request
      1. Interface trip stop
      2. Vehicle load sheet details
      3. Commercial invoice
      4. Packing slip report
      5. Bill of lading
   5. Backend tables
      1. WSH_DELIVERY_DETAILS (RELEASE STATUS = C (means Ship confirm))
      2. OE_ORDER_LINES_ALL (Flow status code = shipped)
      3. MTL_RESERVATIONS( INVENTORY_ITEM_ID = 'o2citem' => table empty > data freezed)\
      4. MTL_ONHAND_QUANTITIES_DETAIL(for item 'o2c' reduces by qty of SO)
      5. MTL_MATERIAL_TRANSACTIONS( for inventory item id > will show 4 rows 
         1. look at transaction qty column  
            1. 1 row for adding items
            2. 1 row > release from Inventory 
            3. 1 for moving to staging area
            4. 1 row > staging to transportation
6. SO INTERFACE 
   1. Order organizer > SO > additional info >> deliveries > view delivery details >
      1. Line status > interfaced 
      2. next step  field : Not applicable
   2. RA_INTERFACE_LINES_ALL :  (INTERFACE_LINE_ATTRIBUTE1 = SO NUMBER)
      1. Now shipping status will be interfaced 
      2. 
         
7. CREATE INVOICE 
   1. Run Workflow background process
      1. item type : OM standard
      2. process deferred : yes
      3. Process time out : Yes
   2. This calls 2 more programs
      1. ADS ( Auto invoice master)
      2. Auto invoice import
   3. Go to AR > Transactions form
   1. Query the invoice using SO in 'Reference' field 
   2. Note the invoice number
   3. create accounting
   4. Back end tables
      1. Transaction tables
         1. RA_CUSTOMER_TRX_ALL ( TRX NUMBER = INV NUM) - Note CUSTOMER_TRX_ID 
         2. RA_CUSTOMER_TRX_LINES_ALL ( CUSTOMER_TRX_ID = xx)
         3. RA_CUSTOMER_TRX_LINE_GL_DIST_ALL ( CUSTOMER_TRX_ID = xx) -
            1. Look for TAX amount
            2. Find EVENT_ID
      2. Create accounting - SLA
         1. SLA
            1. XLA_EVENTS (where EVENT_ID =xx)
            2. XLA_AE_HEADERS (where EVENT_ID = XX)
            3. XLA_AE_LINES (where AE_HEADER_ID = XX)
         2. 
            
      3. Interface
         1. GL_INTERFACE ( Reference26 = EVENT_ID)
      4. GL_TABLES
         1. Create accounting
            1. View request > journal import > view output > note : batch name 
         2. GL resp
         3.  Tables
            1. GL_JE_BATCHES( NAME = BATCH NAME)
            2. GL_JE_HEADERS (JE_BATCH_ID)
            3. GL_JE_LINES (JE_HEADER_ID)
8. CREATE RECEIPT
   1. Create Reciepts for all the invoices created in previous step
   2. AR > Receipts form ( TRX NUMBER)
9. TRANSFER TO GL
   1. To transfer the Receivables accounting information to general ledger,
   2. run General Ledger Transfer Program.
      Navigation: Receivables> View Requests
   3. ( We use this for invoices from AUTO INVOICE PROGRAM )
10. JOURNAL IMPORT
    1. To transfer the data from General Ledger Interface table to General Ledger,
    2. run the Journal Import program from Oracle General Ledger.
    3. Navigation: General Ledger > Journal> Import> Run
11. JOURNAL POSTING
    1. We have to Post journal batches that we have imported previously to update the account balances in General Ledger.
    2. Navigation: General Ledger> Journals > EnterQuery for the unposted journals for a specific period as shown below.