18  Executing Run through Process Modelling Framework in OFS REG REP APME

Process Modeling Framework (PMF) is a design and execution framework that enables the Process Pipeline Developers to implement various Pipelines modeled by the Business Analysts. The Process Pipeline developers use the framework to orchestrate the Business Pipelines and the Run Pipelines within OFSAA and to design the artifacts that participate in the Pipelines to complete their implementation.

This chapter provides information about the usage of the Process Modeling Framework (PMF) feature in the Oracle Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions (OFS REG REP APME) Application.

 

NOTE:   

For detailed information about the Process Modeling Framework (PMF) feature in OFSAA, see the Process Modelling Framework Orchestration Guide.

 

This chapter includes the following topics:

·        Overview

·        Designing a Pipeline in OFS REG REP APME

·        Verifying the Execution Logs

Overview

In OFS REG REP APME, Process Modelling Framework (PMF) is used to create a Run definition in a Run Process. The visual representation of the Run is enabled through PMF by the construction of a Run Pipeline. PMF is a feature in parallel to the Run Management Feature. Through the PMF, you can execute the following Ready-to-use Runs for data loading:

·        Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions (OFS REG REP APME) Sourced Run

·        Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions (OFS REG REP APME) Execution Run

Designing a Pipeline in OFS REG REP APME

You can design the process flow diagrams for both the processes (Business Process Pipeline and Run Pipeline). This is an example of a process flow diagram for a Run Pipeline (for OFS REG REP APME Sourced Run).

After you create, design, and define the process in the process flow diagram, you must assign values to the Run Parameters, and execute the Run. You can execute a Run Pipeline from the UI or using a command-line utility called wfExecExternal.sh.

This section includes the following topics that describe the Run Pipeline execution from the UI:

·        Selecting the Run Parameters and Executing the Run

·        Verifying the Run Execution

·        Verifying the Execution Logs

NOTE:   

For information about executing the Run Pipeline using a command-line utility, see the section Using Command Line Utility in the Process Modelling Framework Orchestration Guide.

 

Selecting the Run Parameters and Executing the Run

After designing and saving the process flow diagram, the Process is listed in the Process Modeller Page.

To select the Run Parameters and execute the Run, follow this procedure:

1.     After logging into OFSAAI applications page, navigate to Oracle Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions, select Process and then select Process Modeller.

2.     In the Process Modeler Page, click More  corresponding to the Run Pipeline that must be executed.

Figure 253: Process Modeler Page

3.     When you click Execute Run, the Select Run Params Window is displayed.

Figure 254: Select Run Parameter Screen

4.     Select the Execution Type as With Parameters from the dropdown list.

5.     Select or enter the required values for each field as follows.

Table 44: Run Parameter Fields and Descriptions

Field Name

Description or Instruction

TEMPLATE_NAME

Enter the template name of the Run.

Reporting Currency

Enter the Reporting Currency Code used to calculate the amount during the data population in the Target Table.

Legal Entity

Select the Legal Entity Code to identify the legal entity used for the Run.

Consolidation Type

Select the Consolidation Type of legal entities on a solo or consolidation basis. In a Solo Run, only the selected legal entity is used. In a Consolidated Run, along with the selected legal entity, all its Child Legal Entities are also used.

Intra Company Elimination

Select the Intra Company Elimination type to eliminate (YES) or skip the elimination (NO) of Intra Company Accounts during a Consolidated Run.

Consolidation Hierarchy

Enter the Legal Entity Hierarchy used for the consolidated Run. This parameter is not required for the Solo Run.

GAAP Code

Enter the required accounting standard.

FIC MIS Date

Select the Extraction Date.

Run Execution Description

Enter a longer description of the Run.

 

6.     When you click  OK button, the Run execution begins. The Select Run Params Window closes.

 

NOTE:   

The execution of the Run Pipeline 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.

 

Verifying the Run Execution

After selecting the Run Parameters and beginning the Run execution, verify the progress of the Run.

To verify the Run Execution Progress, follow this procedure:

1.     In the Process Modeler Page, click More  corresponding to the Run Pipeline that must be verified. Click Process Flow Monitor.

Figure 255: Process Modeler Run Execution Screen

2.     Select the Process Flow Monitor option from the drop-down list. The Process Monitor Window is displayed. You can see the generated process flow ID, the Run execution timestamp, and the status of the Run Execution. To verify the Run Execution Status at the Pipeline Level, click the corresponding Process Flow ID.

Figure 256: Process Monitor Screen

3.     The Process Flow Diagram Window is displayed. The  icon at each Sub Pipeline indicates that the Run Execution is successful.

Figure 257: Run Pipeline Process Flow Diagram

 

NOTE:   

The  icon shows the entire label of the nodes in the Process Flow Diagram and the  icon shows the nodes navigation in the diagram.

 

Verifying the Execution Logs

You can access the execution logs to verify the details of the Run.

To verify the execution log, follow these steps:

1.     After logging into OFSAAI Applications Page, navigate to Oracle Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions, select Process and then select Process Monitor.

2.     In the Process Monitor Window, click the required process flow ID.
The Process Flow Diagram is displayed in a new window.

Figure 258: Sub Pipeline

3.     Click the required metadata to verify the execution log.

Figure 259: Execution Logs

4.     Click the required node and the Activity Window is displayed.

Figure 260: Activity Logs

5.     Click Execution Logs. The Log File Details Page is displayed.

6.     Select the Log File that you wish to view from the drop-down list and click View Log. The Run Execution Log details are displayed.

Figure 261: View Run Execution Log Window

Alternatively, to verify the execution logs, click the  icon in the Process Flow Diagram Window.
The log details of the Run execution are displayed in a new window.

Figure 262: Run Execution Logs

For detailed information about the complete functioning of the PMF, see the Process Modelling Framework Orchestration Guide.