9.5.1.3 Select the Run Parameters and Execute the Run

After a Run pipeline (process) is designed and defined in the process flow diagram, you must assign values to the Run parameters, and execute the Run.

Note:

You can use PMF to invoke the PMF process through a PMF specific ESIC (External Scheduler Interface Component) option. You can execute a Run Pipeline on the UI or using a command-line utility called wfExecExternal.sh.

This shell script file wfExec.sh is available in the ficdb/bin directory. To execute the utility, navigate to the $FIC_DB_HOME/bin directory and execute wfExec.sh with parameters such as objectId, objectType, Infodom, segments, userID, locale, appParams, and secMap.

Figure 9-56 Select Run Parameters and Execute the Run

To select the Run parameters and execute the Run, follow these steps:

1. In the Process Modeller page, click More icon corresponding to the Balance Computation Management Ledger Run process that must be executed. Click Execute Run.

   Figure 9-57 Balance Computation Management Ledger process - Select Execute Run

   
   

   

   
   
2. The Execution page is displayed. This page consists of the Run parameters specific to the Balance Computation Management Ledger process.
   1. Enter and select the required details to execute the Run without parameters.

      Figure 9-58 Balance Computation Management Ledger process without Execution Parameters

      
      

      

      
      
   2. To execute with parameters, select With Parameters in the Execution Type list. To save the details, click Save.

      Figure 9-59 Balance Computation Management Ledger Process with Execution Parameters

      
      

      

      
      
   3. To save the details, click Save. In the Process Flow canvas, click Save to save the process flow. Select or enter the required values for each field as follows.

      Note:

      • BCE should NOT be executed more than once for any combination of run-time parameters.
      • Even when there are no journals present for a particular day, BCE pipeline must be executed.
      • Only one Legal Entity and Source Code must be selected for execution of the Balance Computation process pipeline.
      • All accounting balance figures processed by BCE are as of a given MIS Date and Effective Date. BCE should be executed chronologically for contiguous dates through the fiscal year.
      • Even when attempted over a closed fiscal period, BCE batch does not fail - it does not process anything.

      Table 9-7 Balance Computation Management Ledger process - Execution page field names and description

      Field Name	Description or Instruction
      Legal Entity	Use the Selection icon to select the required Legal Entity Code to identify the legal entity used for the Run.
      FIC MIS Date	Use the calendar icon to select the extraction date.
      Run Execution Description	Enter a longer description of the Run.
      Data Origin	Use the Selection icon to select the required Data Origin from the Available Values list and click OK.

3. To save the details and execute the Run, click Save.

   Note:

   The execution of the Balance Computation Management Ledger Run process is triggered using the selected FIC MIS DATE. The Run SKey is generated and inserted into the DIM_RUN table. For the Run SKey generated, the corresponding user-selected Run parameters are inserted into the RUN_EXE_PARAMETERS table.

   Note:

   Processes that compute day, period and period-average accounting balance should be executed for every calendar date, chronologically. If process execution skips dates, the balance figures computed could be inconsistent or erroneous.

   Note:

   See the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide Release 8.1.1.0.0 for information about the following topics:

   • To abort, resume, or rerun the Run Pipeline Process, see the Abort Run Pipeline, Resume Run Pipeline, and Re-run Run Pipeline sections respectively.

   To verify the execution logs, see the Viewing Activity Execution Logs and Viewing Execution Log for Widgets sections.