1. User Guide
  2. Fact Ledger Population
  3. Execute the Fact Ledger Population Transformation

8.3 Execute the Fact Ledger Population Transformation

You can execute the function from the Operations (formerly Information Command Center (ICC) framework) module of OFSAAI.

This component for OFS EFPA is seeded with the following Processes PR_LEDGER_STAT and PR_MGMT_REPORTING, which can be executed from the Run Rule Framework section of OFSAAI. In the Parameter List, include pstart_month, pend_month, pyears, pidentity_code, psource_type, pre_run_flg, and prcy. For example, 1,12,1994,'','','Y','USD'.

You can also define a new Batch and an underlying Task definition from the Batch Maintenance window of OFSAAI. For more information on defining a new Batch, refer to section OFS Analytical Applications Infrastructure User Guide.

To define a new task for a Batch definition, follow these steps:

  1. Select the check box adjacent to the newly created Batch Name in the Batch Maintenance window.
  2. Click the Add icon (+) from the Task Details grid.

    The Task Definition window is displayed.

  3. Enter the Task ID and Description.
  4. Select the TRANSFORM DATA component from the drop-down list.
  5. Select the following from the Dynamic Parameters list:
    • Datastore Type: Select the appropriate datastore type from the list.
    • Datastore Name: Select the appropriate datastore name from the list.
    • IP address: Select the IP address from the list.
    • Rule Name: Select FSI_LEDGER_STAT_TRM from the drop-down list of available transformations. (This is a seeded Data Transformation which is installed as part of the OFS EFPA application installer. If you don't see this in the list, contact Oracle support).
    • Parameter List: Enter pStart_Month, pEnd_Month, pYears, pIdentity_Code, pSource_Type, pRe_Run_Flg, and pRCY.
    • pStart_Month: This parameter indicates the starting Month.
    • pEnd_Month: This parameter indicates the ending Month.
    • pYears: This is a mandatory parameter that indicates the Year value.
    • pIdentity_Code: This is an optional parameter that indicates the Identity Code.

      This is the identity code in the OFS PFT’s FSI_D_MANAGEMENT_LEDGER table. The value '0' in this field indicates, only the rows in FSI_D_MANAGEMENT_LEDGER with source code '0' should get processed. Source code '0' indicates rows in FSI_D_MANAGEMENT_LEDGER loaded by the ledger load program. This results in the movement of rows loaded by ledger load program to FCT_LEDGER_STAT in OFS EFPA application. Similarly, any particular allocation output values can be moved by filtering on the identity code.

    • pSource_Type: This is an optional parameter that indicates the Source Type.

      Source Type indicates which process populated a row in FSI_D_MANAGEMENT_LEDGER of Profitability Management application. For example, '0' indicates it was loaded by the Ledger Load program and '100' indicates the allocation rule populated it, and so on.

    • pRe_Run_Flg: This is an optional parameter that indicates the Re-run Flag. If the value is 'Y', the existing data in the fact table will be removed and reloaded.
    • pRCY: This indicates the reporting currency with Default Value 'USD'.
  6. Click Save.

    The Task definition is saved on the selected Batch.

  7. Execute the batch.

    You can execute a Batch definition from the Batch Execution section of the OFSAAI Operations module.

    Ledger Stat Transformation can also be directly executed on the database through SQLPLUS.

    Details are:

    • Function Name: FSI_LEDGER_STAT_TRM
    • Parameters : pBatch_Id, pAs_of_date, pStart_Month, pEnd_Month, pYears, pIdentity_Code, pSource_Type, pRe_Run_Flg, and prcy.

Sample parameter values are 'Batch1', '20091231', 1, 8, 2009, 0, 0, 'Y', and 'GBP' respectively.