18.11.2 Use and Execute ERP GL Adjustment Journals Ingestion Pipeline

Prerequisite

Before executing the 'ERP GL Adjustment Journals Ingestion', perform the following to ensure that the files are available on the ERP Financial Cloud Service:

Schedule the "GL_MANUAL_ADJ_JOURNALS" Extract Job created in the BI Cloud Console while saving the AHCS Instance Details and ensure that the Job is completed.

To avoid data inconsistencies and system errors, customers must execute the BICC extract strictly as an End-of-Day (EOD) process.
  • Sequence: Run the BICC extract only after all journal postings for the day are fully complete. Possibly with a time lag of 20-30 minutes
  • Runbook Alignment: Customer runbooks must ensure that the journal posting process and the BICC extract execution do not overlap. Overlapping these processes may trigger technical errors, such as a "snapshot too old" exception.
To search and execute the ERP GL Adjustment Journals Ingestion process in the Process Orchestration, do the following:
  1. To access the ERP GL Adjustment Journals Ingestion Pipeline, on the Home Page, select the Process Orchestration.
    The Process Modeller Page is displayed.
  2. On the Process Modeller Page, search and select the ERP GL Adjustment Journals Ingestion Pipeline.
    The Process Flow Page is displayed.
  3. To execute the Run, you can select the Run Parameter values using the Execution icon on the Process page or on the Process Modeller page.
  4. Navigate to the Process Modeller page to execute the Run and Click Execution icon.
    The Execution Page is displayed.
  5. On the Execution page, to execute the Run with parameters, select With Parameters in the Execution Type List. Select or enter the required values for each field as follows:

    Table 18-15 ERP GL Adjustment Journals Ingestion process - Execution page Field Names and Description

    Field Name Description or Instruction
    As of Date Use the Calendar button to select the As of Date for the pipeline.
  6. To save the details and execute the Run, click Execute. The Run Execution begins.

    Note:

    The execution of the Run Pipeline is triggered using the selected As of Date.
  7. To verify the Run Execution of the ERP GL Adjustment Journals Ingestion process, do the following:
    1. To open the Process Monitor Page, on the Process Modeller Page, click the Process Monitor Button or select Process Flow Monitor on the Process Menu on the Process Modeller Page.
    2. The Process Monitor Page is displayed listing all the Run Instances corresponding to the ERP GL Adjustment Journals Ingestion process. On the Process Monitor Page, search by the Process ID, or by the Process Name ERP GL Adjustment Journals Ingestion Pipeline, and select the Process Instance for the required Run Pipeline (Process) that was executed.
  8. The Process Flow Page is displayed with the Run Execution Status on each Node of the ERP GL Adjustment Journals Ingestion process.
  9. To verify the Run Execution Logs, do the following:
    1. On the Process Monitor Page, click the required Process Instance for which you need to verify the Execution Logs.
    2. To see the Execution Status details of a Node, double-click on that Node. The Execution Status details Page is displayed. Click Execution Logs.
    The Log Viewer Page is displayed, which lists all the Logs related to the Process Instance. To see an elaborated information of a log entry, click the Show More button. Click outside the Log Viewer page to close it.