Friday, December 26, 2014

Oracle Apps Order TO Cash Cycle Revised


Now lets talk about O2C cycle.Order to cash cycle is something which is related to something related to selling product and receiving payments.So in day to scenario ,what we might refer to is selling your old ipod to your friend who wants to own it after you.
So as previous example in P2P cycle ; you want to sell your old gadget now.
In this scenario , you are seller and one buying your old stuff becomes buyer or customer.
In practical scenario :

1 You decide how many/or what  gadget you want to sell..
2 When some one from another places order or inquiry , you do negotiation for price, then tell buyer about your product, payment method , shipping terms ie wether you or buyer pay for shipping.
3 Once negotiation is made  you pack your gadget , place shipping information of buyer ,and approach FEDEX for delivery

4 Once buyer receives good you are notified by Fedex about delivery of good.
5 You receive payment via paypal or bank ; then you would like to sum up the money for your next gadget purchase ….

6 Invoice / or Receipt might not be generated as you are selling old gadget personally.
Hence in business scenario , if you are manufacturer or supplier of certain goods or sevices.. things get these way too…but with little extra steps . You might be noticing these steps while ordering online :

Hence O2C cycle revolves in following process:

1 Enter order :  This is something the way to collect interested customer information on our product.Since we are selling product  we will need certain details about buyer/customer.Hence attributes like sipt to, bill to ,item ordered,quantity, unit of measurement are entered in this process.

2 Book Order:This is done after  costumer orders is finalized. Hence we start processing order like preparing invoice for the product , demanding inventory of the goods etc.

3 Pick Release: Effects the process in inventory level

4  Pick Confirm: The Pick Confirm transaction executes the subinventory transfer, moving the material from it’s source location to it’s destination staging location. Only 1 staging subinventory is supported per picking batch.The high level reservations are replaced with detail reservations
5 Ship Confirm Its  likely that shipping has been confirmed.

6 Invoice Invoice generation process
7 Receipt Receipt generation process

8 Transfer To GL process
9 Journal Import process

10 Posting effect on gl balances.

O2C details

SN
Process
Tables
Remarks
Entered info
1
Enter Order
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
Flow status :
Header: Entered
line: Entered
order management>Order Returns>Sales Order
Enter Header and Line Information (ship to,Bill to UOM etc)
2
Book Order
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
WSH_DELIVERY_ASSIGNMENT
WSH_DELIVARY_DETAILS
Header :Booked
Line: Awaiting Shipping

BackGround Program:
Demand Interface program
order management>Order Returns>Sales Order
Select Sales Order and click on Book Order Button
3
Pick Release
WSH_DELIVARY_ASSIGNMENTS
WSH_NEW_DELIVIRIES
WSH_DELIVARY_DETAILS
Header :Booked
Line : Pick Confirmed

Back Ground Program:
Pick Slip Report
Shipping Execution Report
Auto Pack Report
Line: Pick Confirmed
Order Management>Shipping>Release Sales Order>auto create delivery ,pick confirm,pack delivery to yes

Also enter shipping and inventory tab information
4
Pick Confirm
WSH_DELIVARY_DETAILS
Header: Booked
Line : Pick Confirmed
Inventory>move Order>Transact Move Order

In pick release if auto pick confirm is set to no, then
follow the path enter batch number,click find,
click on transacti button
5
Ship Confirm
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
WSH_DELIVARY_DETAILS
Header Booked
Line : Shipped

Back Ground Programss:
Interface Trip Stop
Commercial Invoice
Packing Slip Report
Bill Of Lading
Order management>shipping>transaction
Qury the order number,go to delivery tab and click
on ship confirm
6
Invoice
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
Header :closed
lines: Closed
Background Programs:
Auto Invoice Master Programs
Auto Invoice Import Programs
Order management>view>Requests
Run workflow background process
7
Receipt
AR_CASH_RECEIPTS_ALL
 
Receivable>Receipts>receipts
Enter payment method,Receipt type,amount,bank name
branch,account etc;
Click On apply button
8
Transfer To GL
GL_INTERFACE
 
Receivable>view reques
Transfer Receivable Accounting Information To GL
using gl transfer program
9
Journal Import
GL_JE_BATCHES
GL_JE_LINES
GL_JE_HEADERS
 
General ledger>journal>import>run
10
Posting
GL_BALANCES
 
General ledger>journals>post

3 comments:

  1. Great post with unique information.This blog will really helpful for me to develop my skills in a right way.Thanks for sharing,keep update with your blogs.

    Website Design Company in Bangalore | Mobile App Development Companies in
    Bangalore
    | Website Development Company in Bangalore

    ReplyDelete
  2. You post is very informative and contents are outstanding. Thanks for sharing such useful info.

    Zikia | OJOPLUS | Best Immune Booster Tablets in India

    ReplyDelete