You can execute the function from the Operations Framework module of OFSAAI.
This component for ALMBI has been seeded with the Batch ID
<INFODOM>_Fact_Table_Transformation - Task1, which can be executed from the Batch
Execution window. A single Batch triggers the transformation for FCT_LEDGER_STAT. The
Parameter List includes 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, see the How
to Define a Batch. To define a new task for a Batch definition, follow these
steps:
- Select the check box adjacent to the newly created Batch Name in the
Batch Maintenance window.
- Click Add (+) from the Task Details grid. The
Task Definition window is displayed.
- Enter the Task ID and
Description.
- Select Run Executable from the Run Executable drop-down
list.
- Select the following from the Dynamic Parameters
list:
- Datastore Type: Select the appropriate datastore
type from the drop-down 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 ALMBI Solution Installer. If you do not 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 is an optional parameter
that indicates the Starting Month.
pEnd_Month: This is an optional parameter
that 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 LEDGER_STAT table. The
value '0' in this field indicates, only the rows in
LEDGER_STAT with identity code '0' should get processed.
Identity code '0' indicates rows in LEDGER_STAT loaded by
the ledger load program. This results in the movement of
rows loaded by ledger load program to FCT_LEDGER_STAT.
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 LEDGER_STAT. 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 Rerun 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'.
- Click Save. The Task definition is saved for the
selected Batch.
- Execute the Batch.
You can execute a Batch definition from the Batch
Execution window of the OFSAAI Operations module.
Ledger Stat Transformation can also be directly executed on the database
through SQLPLUS.
Use the following details:
- 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.