Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

General Ledger Transfer (ARGLTP) used in 11i is obsolete in Release 12.

Posted on January 12th, 2013 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Prior to posting to the General Ledger, the Receipts Journal Report and Sales Journal display the transactions that would be posted to the General Ledger .

In Release 12 this program has been replaced by the following:

  • Create Accounting or Submit Accounting – This generate accounting entries in Sub-ledger Accounting (XLA). You can run this from any AR Manager responsblity , and can be done via Control > Request > Run (Create Accounting).
    • The Parameter Transfer to General Ledger denotes whether or not the records created by Create Accounting in the XLA tables will be posted to the the General Ledger Tables.
      • If YES – the process will automatically call Transfer Journal Entries to General Ledger for you and your records are transferred from XLA to GL and your entries are posted.
      • If NO – then you need to explicitly run program Transfer Journal Entries to General Ledger to pickup the final accounted transactions from the subledger (XLA Tables) and move them on to GL.
      • Take a note : If you have transactions with Accounting Rules, you need to run Revenue Recognition PRIOR to running Create Accounting otherwise the invoice will not be picked up for accounting, OR you can use Submit Accounting instead.
  • Submit Accounting – This process is an Oracle Receivables-specific counterpart of the create accounting process .
    • The Parameter Create Accounting determines whether you want to spawn the Create Accounting process as well – this is equivalent to running it standalone as in step 1 above
    • The Parameter Transfer to General Ledger denotes whether or not the records created by Create Accounting in the XLA tables will be posted to the the General Ledger Tables.
    • If you enter YES – the process will automatically call Transfer Journal Entries to General Ledger for you and your records are transferred from XLA to GL and your entries are posted.
    • If you enter NO – then you need to explicitly run program Transfer Journal Entries to General Ledger to pickup the final accounted transactions from the subledger (XLA Tables) and move them on to GL. See step 3 on how to do this.
  • Transfer Journal Entries to General Ledger : If in either of the previous steps: Create Accounting OR Submit Accounting, you entered NO for the parameter Transfer to General Ledger, then you need to run this step explicitly.

a Data Flow: When this Transfer done , these tables tables involved in the Transfer to GL and GL posting.

Subledger Tables

  • XLA_AE_HEADERS
  • XLA_AE_LINES
  • XLA_DISTRIBUTION_LINKS

Transfer Journal Entries to GL (XLAGLTRN) process takes the subledger journals and inserts records into the Interface Tables

Interface Tables

  • GL_INTERFACE / XLA_GLT_<groupid>
    • If you are using primary and secondary ledger , Two group IDs are created
    • One for the primary ledger and one for the secondary ledger.
    • Two journal import processes are spawned in this case, one for each group_id.

There is profile option “Disable Journal Import” (when set to Yes) prevents the GL Transfer from invoking the Journal Import.

The interface table used in this case is GL_INTERFACE. Setting this profile option is not recommended if you are using Oracle General Ledger.

Journal Import (GLLEZL) then reads from the interface table and creates records in the GL Tables

GL Tables

  • GL_JE_BATCHES
  • GL_JE_HEADERS
  • GL_JE_LINES
  • GL_IMPORT_REFERENCES

Hope this helps.

Related Posts

Posted in Oracle Receivable | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.