GL Balance - How to load, how often

Problem

Product Version: Analytic Applications - JDE GL Build: All Platform: Win 2000 Description: Clarification needed on the concept of summarization of the fact table GL_BALANCE. The Administrator's Guide states - The General Ledger Balance fact table summarizes the transactions processed through the general ledger. The summarization can occur at any time interval but is typically done at a monthly level. Solution: Load General Ledger Balances The GL_Balance table is different from all other tables in the General Ledger data mart. Loading general ledger balances involves * the initial stage where opening balances are extracted for a specific year * the update stage where the GL_Balance table is updated incrementally for all general ledger activity up to the current date Steps for the Initial Stage 1. Execute the GL_Activity_Document job to extract general ledger activity transactions, starting with the specific year specified in the job's Extract From Date/Time parameter. 2. Set the INITIAL_LOAD_END_DATE configuration parameter. If the Extract To Date/Time parameter for the GL_Balance job is greater than INITIAL_LOAD_END_DATE, it will be set to the same value. 3. Execute the GL_Balance job to extract year opening balances. The GL_OPNNG_BAL_BEG_YR configuration parameter determines the year from which you want to extract opening balances, and must be set to a year that is greater than or equalto the Extract From Date/Time parameter set for the GL_Activity_Document job. Note: Once the general ledger opening balances are loaded, we recommend that you verify them against the source system before proceeding to the update stage. Step for the Update Stage * Execute the GL_Balance job regularly for all general ledger activity up to and including the current date (SYSDATE). The F_PERIODS_TO_PUBLISH_AHEAD configuration parameter determines the fiscal period to which general ledger balances will be carried forward during subsequent data loads. The frequency in which data is loaded into the target data mart depends on the table. Manual tables are loaded when requested by the user. Normal tables are loaded regularly. The GL_BALANCE table is initially loaded with opening balances from the F0902. These opening balances depend on the configuration parameter, GL_OPNNG_BAL_BEG_YR. This parameter determines the beginning year for the GL_BALANCE table. Subsequently, there are stored procedures that use the detail transactions in the GL_ACTIVITY_DETAIL table to calculate the following period balances. Thus, the F0902 is used to retrieve opening balances. The F0911 is used to retrieve detail transactions into the GL_ACTIVITY_DETAIL, that are then used by the stored procedures to calculate current period balances in the GL_BALANCE table. The call to execute the stored procedures is in the GL_BALANCE_J.