4.1.2 Prerequisites to Execute the OFSBCE Processes

Before executing the OFSBCE processes, complete the following tasks:

  • Load the required Dimensions.

    The following dimension entities are used by BCE and should be populated:

    • DIM_ORG_UNIT
    • DIM_GL_ACCOUNT
    • DIM_ORG_STRUCTURE
    • DIM_CUSTOMER
    • DIM_DATES
    • DIM_FISCAL_PERIODS
    • DIM_DATA_ORIGIN
    • DIM_ACCOUNT
  • Load the following Seeded Data
    • DIM_GAAP
    • DIM_GL_TYPE
    • DIM_CURRENCY

    For the latest list of Dimensions to be loaded, see the OFSBCE Runchart for the current release. For information about loading the Dimension tables, see the Executing SCDs sub-section in the Slowly Changing Dimensions (SCD) section, and Batch Execution sub-section in the Operations section of the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.1.0.0.

    Note:

    For populating the DIM_ACCOUNT table, the standard process in OFSDF is to use the data from the Product Processor entities in Staging. Populating the Product Processor entities in Staging is not mandatory for OFSBCE purposes. OFSBCE supports populating the DIM_ACCOUNT entity from unique values for ACCOUNT_ID as supplied in the STG_ACCOUNTING_ENTRIES entity, which needs to be sourced from appropriate sources, typically from Oracle ERP, other accounting systems or other suitable systems of record. The process for populating STG_ACCOUNTING_ENTRIES is defined, and the required steps are available out of the box with the OFSBCE installation.

    If OFSDF is deployed, institutions may choose to ignore this functionality and as an alternative, populate the DIM_ACCOUNT entity from Product Processor entities.

    To populate the DIM_ACCOUNT table entries when OFSDF (or any other OFSAA application, which lists DIM_ACCOUNT in its Runchart) is present, see the Account Dimension Table section in the Oracle Financial Services Data Foundation Application Pack User Guide Release 8.1.1.0.0 and related documents in the OFSDF OHC Documentation Library.

    Note:

    To populate DIM_DATES using DTs, see the Time Dimension Table section in the Oracle Financial Services Data Foundation Application Pack User Guide Release 8.1.1.0.0.

  • Load the Exchange Rates table FSI_EXCG_RATES using the insert scripts.

    Note:

    • Ensure that FSI_EXCG_RATES table does not contain duplicate records for the same currency combination for a given MISDATE-EFFECTIVE DATE. If exists, this will lead to runtime exceptions during execution of Revaluation Balances pipeline.
    • The FSI_EXCG_RATE (FIC_MIS_DATE,D_EFFECTIVE_DATE,V_FROM_CCY_CD,V_TO_CCY_CD) table must contain unique records combination to retrieve only one exchange rate.

    The Exchange Rates table stores the list of all exchange rates for all types of currency. This is a standalone table. The purpose of the Exchange Rates table is to offer the value of one currency in relation to another currency.

    Each Legal Entity, for which processing is expected, must have an associated Local Currency to it. So that the system can perform the computations.

  • Load the Legal Entity tables.

    The reporting entity may be a part of a financial institution that consists of multiple legal entities such as parent or child entities (subsidiaries) under its name. User can select the entity for which processing must be done. In addition, a ‘Solo’ Run execution is supported.

  • Load the SETUP_MASTER table

    The Revaluation or Translation processes need the Rate Data Origin and Quote Type as input information for processing. This information is present in the SETUP_MASTER table and can be identified by rows where the column V_COMPONENT_CODE consists of the values EXCG_RATE_DATA_ORIG and EXCG_RATE_QUOTE_TYPE, and the Seeded values in the column V_COMPONENT_VALUE are DEFAULT and QUOTE. This information is used when fetching Rates from the table FSI_EXCG_RATES during computation.

To execute batches in the preceding tasks, see the Batch Execution sub-section in the Operations section of the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.1.0.0.

To configure, manage, and execute all the OFSBCE processes, use the OFSAA Process Modelling Framework (PMF). For more information, see the Executing the OFSBCE Processes through Process Modelling Framework section.

For information about the Flattening Process of Dimensions, see the Hierarchy Transformation section in the Oracle Financial Services Data Model Utilities User Guide Release 8.1.1.0.0.