1. User Guide
  2. Update Hierarchy System ID through Batch Execution
  3. Executing the Update Hierarchy System ID

11.3 Executing the Update Hierarchy System ID

You can execute the function from the Operations module of OFSAAI, as mentioned below:
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 section.
To define a new task for a Batch definition, follow these steps:
  1. Select the check box adjacent to the newly created Batch Name in the Batch Maintenance window.
  2. Click Add (+) from the Task Details grid. The Task Definition window is displayed.
    Enter the Task ID and Description.
  3. Enter the Task ID and Description.
  4. Select Transform Data from the Transform Data drop-down list.
  5. Select the following from the Dynamic Parameters drop-down list:
    • Datastore Type: Select the appropriate datastore type from the list.
    • Datastore Name: Select the appropriate datastore name from the list.
    • IP Address: Select the IP address from the list.
    • Rule Name: Select FN_ALMBI_UPDATE_FLAT_HIER from the drop-down list. (This is a seeded Data Transformation procedure installed.
    • ALM BI Application: If you do not see this procedure in the list, contact Oracle Support).
    • Parameter List: These are comma-separated values of component Code and component Value. For example: (‘3’,’ 201739’) (3 – COA, 201739 – hierarchy ID that needs to be transformed).
  6. Click Save. The Task definition is saved for the selected Batch.
  7. Execute the Batch.
    You can execute a Batch definition from the Batch Execution window of the OFSAAI Operations module.

    Note:

    This process can also be run using the Simplified Batch User Interface. In the Optional Parameters field within the Simplified Batch window, specify the parameters mentioned above. For more details, see the Simplified Batch Execution section.
    Update Hierarchy System ID can also be directly executed on the database through SQLPLUS.
    Use the following details:
    • Function Name: FN_ALMBI_UPDATE_FLAT_HIER
    • Parameters: BATCH_RUN_ID, MIS_DATE, COMPONENTCODE, and COMPONENTVALUE