Let’s assume you are executing your entire P-2-P flow on Oracle Cloud and the General Ledger system is on-premise.
In this case following integration approach may be followed:
– Perform your entire P-2-P flow on the cloud and it will generate various journal entries
– Run the Create Accounting process on the Cloud and it will create a data file that contains Sub Ledger Accounting entries. The file will be created on Oracle Universal Content Management (UCM). Oracle e-Business Suite can fetch the data from UCM. You need to setup “Enable Transfer to Oracle EBS GL” profile option and perform a setup in the “Manage Subledger Application: Payables” task to indicate transfer needs to be made to Oracle EBS GL and not in Oracle Fusion GL.
– Export the Journal entries from the Cloud and load it into the on-premise financial system as a batch.
Know more about Forms Personalizations in the “Oracle Forms Personalizations – Comprehensive Guide” book: Available Here
The content posted above is based on author’s own experience and opinion. The details mentioned above may differ in various versions and scenarios of Oracle e-Business suite. You need to have required licenses from Oracle to enable mentioned functionalities.
Got queries? Please write to firstname.lastname@example.org.