Transferring Ledgers for Consolidation

General Ledger both publishes and subscribes using this IP on the service LEDGER_LOAD. You can publish ledger data from a regional database to the corporate database for the purpose of consolidation. On the subscription side, summary ledger data is stored in the summary ledger tables directly, while detail ledger data is subscribed in a staging table for processing by the Ledger Load process (GL_LED_LOAD).

You initiate the ledger publish process (GL_LED_PUB) from General Ledger, Consolidate Financial Data, Publish Ledgers, within the regional database. Ledgers are protected by the Allow Ledger Load Update option on the Ledgers For A Unit - Definition PageLedgers For A Unit page.

In addition to using publish and subscribe to import ledgers, you can also import data using the Flat File Ledger Import process (GL_LED_IMP) to import standard detail ledgers and standard budgets ledgers.