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