Monday, October 23, 2017

What are the different methods to transfer Subledger journals to GL in Oracle Apps R12?



1) ONLINE MODE
GL Transfer can be spawned during Online Accounting using the "Final Post" option for a specific document (Example: AP Invoice and AR Transaction).

Example: 
Navigation in Payables:-
 Invoices/Entry/Invoices: Action: Create Accounting/Final Post. This  spawns the GL Transfer, the Journal Import, Data Manager and the GL Posting processes. This request transfers ALL the final accounted data for that document. This method of transfer uses the interface table GL_INTERFACE to move the journals to the general ledger.  

2) BATCH MODE
GL Transfer can also be spawned by the Create Accounting concurrent request when submitted with the "Transfer to GL" parameter set to Y.

Example:  
Navigation in Payables: Other/Request/Run: Create Accounting
This spawns the journal import and the data manager processes. The GL Posting Process is spawned if the "Post to GL" parameter is set to Yes when submitting the Create Accounting. This request transfers all the final accounting created by the Create Accounting request that spawned it. This method uses the interface table XLA_GLT_<groupid>.

3) CONCURRENT REQUEST
GL Transfer can be submitted in standalone mode using the concurrent request "Transfer Journal Entries to GL".

Example: 
Navigation in Payables: Other/Request/Run: Transfer Journal Entries to GL
This spawns the Journal Import and the Data Manager programs. This request transfers all the final accounting that exists for the given ledger and end date. This method uses the interface table XLA_GLT_<groupid>.

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)