Search 800 + Posts

Aug 5, 2010

Order to General Ledger Flow ( Oracle Applications)

Last couple of weeks are really crazy for me , getting involved in Financials again and again.Last few weeks we are working on a POC for a customer where they want to auotmate the Order to General ledger process for Non Service Item on Oracle E-business Suite R12.

Requirement - Customer will get hundered of Orders/hour from the Source system and they want to Created/Book/Invoice (AR) these orders in Oracle EBS and then Created Receipt against the Invoice in Oracle receivable and Finally customer want to see the Journal enteries in Oracle General Ledger.

Since this is Service Item we don't Need Shipping or Inventory and for Order Creation we suggested Bill Only Flow

For all Order payment Types will be Credit card .

To Automate the complete process we have set

1.Workflow Background Process every 5 minutes
2.AutoInvoice 5 Minutes
3.Custom Process to Create the Receipt every 10 minutes
4.Posting to GL

Screen Shot of comple Process are available in below album. In the screen shot you might notice that Step#3/Step#4 are manual and Payment method is Not Credit card. Contact us in case you want to know how we have automate those 2 steps and now to Process the data with Payement Method as Credit Card.

Link to Picasa Album

Order to General Ledger Flow


  1. Hi,

    This is very nice document. In my present project automatic receipt is required. Can you please send me the step by step set up on automatic receipt. my personal mail address is I have also requested you before regarding Intercompany Sales document. At that time it was not avaiable to you. Is the avilable now?

    Your blog is very nice. I am wishing a very long and strong future of this blog.

    Krishanu Ghosh

  2. Hi! Krishna

    if you look into the user Guide they have explained it very well.They have explained it Step by Step.
    Go a head and Start and in case you stuk some here , let me know where you stuck and I will more than happy to help you .

    write me at