17.3.3 Using the Command Line
This topic describes the execution of the Enhanced Cash Flow Edits process for Funds Transfer Pricing (FTP) from the command line in Oracle Financial Services Analytical Applications (OFSAA) Release 8.1. Oracle recommends executing the Enhanced Cash Flow Edits process through the user interface; command-line execution is intended for advanced or administrative use cases.
- Navigate to
ficdb/binfolder. - Update the below parameters as required and run the command:
./CashFlowEditsProcessExecution.sh <Run_Id>,<PMF_Id>,<Execution_Id>,<Run_Skey>,<Execution_Date>,<INF ODOM>,<Cash_Flow_Edits_Process_Id>,<User_Id>,<Date_Format>,<As_of _Date or MIS_Date>,<Legal_Entity_Id>,<Legal_Entity_Hierarchy_Numeric_Id>Example:
./CashFlowEditsProcessExecution.sh "$RUNID=1608286329518","$PHID=NA","$EXEID=1761732911543","$RUNSK= OFS ALM User Guide | 166 22","12/31/2022","OFSALMINFO","202489","105545","MM/dd/yyyy","12/ 31/2022","-1","-1"
Use the following command to execute the Enhanced Cash Flow Edits process:
./CashFlowEditsProcessExecution.sh \
"$RUNID=1608286329518","$PHID=NA","$EXEID=1761732911543","$RUNSK=22",\
"12/31/2022","OFSALMINFO","202489","CFEUSER","MM/dd/yyyy","12/31/2022","-1","-1"
The following table describes the parameters used in the command-line execution:
Table 17-1 Parameters used in the command-line execution
| Parameter Order | Parameter Name | Example Value | Required | Description |
|---|---|---|---|---|
| 1 | Run Id | $RUNID=1608286329518 |
Yes | Any random value can be provided. This value is auto-generated when executed from Batch. |
| 2 | PMF Id | $PHID=NA |
Yes | Any random value can be provided. This value is auto-generated when executed from Batch. |
| 3 | Execution Id | $EXEID=1761732911543 |
Yes | Any random value can be provided. This value is auto-generated when executed from Batch. |
| 4 | Run Skey | $RUNSK=22 |
Yes | Any random value can be provided. This value is auto-generated when executed from Batch. |
| 5 | Execution Date | 12/31/2022 |
Yes | Calendar date or system date of execution. |
| 6 | INFODOM | OFSALMINFO |
Yes | Infodom in which OFSAA is installed and executed. |
| 7 | Cash Flow Edits Process Id | 202489 |
Yes | Numerix identifier of the Cash Flow Edits process. |
| 8 | User Id | CFEUSER |
Yes | User name of the person executing the process. |
| 9 | Date Format | MM/dd/yyyy |
Yes | Format in which the MIS date is provided. |
| 10 | As of Date / MIS Date | 12/31/2022 |
Yes | As-of date (MIS date) used as a filter to select data from instrument tables. |
| 11 | Legal Entity Id | -1 |
Yes | Numeric ID of the Legal Entity for which instrument data must be processed. |
| 12 | Legal Entity Hierarchy Numeric Id | -1 |
No | Numeric ID of the Legal Entity hierarchy. This is required when processing a parent Legal Entity and including its child and descendant entities. |