1. User Guide
  2. Account Summary Population
  3. Executing the Account Summary Population T2T Process

6.3 Executing the Account Summary Population T2T Process

Note:

You can use a seeded batch Infodom_FFAS_Consolidated_Batch to execute all the FCT_FTP_ACCOUNT_SUMMARY T2Ts. This batch also includes the DTs to delete the data from the FCT_FTP_ACCOUNT_SUMMARY table. If you are creating a new batch to execute the FCT_FTP_ACCOUNY_SUMMARY T2Ts, then delete the data from the FCT_FTP_ACCOUNY_SUMMARY table before executing to T2Ts for same AS of DATE or MIS DATE.
The following steps describe how to execute the ALM BI Account Summary T2T processes from the OFSAAI Batch Processing Framework.
You can execute the function from the Operations module of OFSAAI, as mentioned below:
Define a new Batch and an underlying Task definition from the Batch Maintenance window of OFSAAI. For more information on defining a new Batch, the How to Define a Batch section.
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 Add (+) from the Task Details grid. The Task Definition window is displayed.
  3. Enter the Task ID and Description.
  4. Select Load Data from the Load Data drop-down list.
  5. Select the following from the Dynamic Parameters list:
    • Datastore Type: Select the appropriate datastore from the list.
    • Datastore Name: Select the appropriate name from the list.
    • IP Address: Select the IP Address from the list.
    • Load Mode: Select table to table from the list.
    • Source Name: Select PROCESSING from the list. (This is seeded with the ALM BI Solution Install).
    • File Name: Select the T2T name for the instrument you want to process. (This is a seeded T2T name installed as part of the ALM BI solution installer. If you do not see this in the drop-down, contact Oracle Support).
    • Data File Name: NULL
    • Default Value: Enter the Reporting Currency value in the following format. [DRCY]='ABC' (where 'ABC' denotes Reporting Currency Code, for example, 'USD').
  6. Click Save. The Task definition is saved for the selected Batch.
  7. Execute the Batch.
    You can execute a Batch definition from the Batch Execution window of the OFSAAI Operations module.

    Note:

    You cannot execute this process from the Simplified Batch window.