4.3.7 Create and Execute Batch

To create and execute the batch:

Note:

Before executing the ADS batch, ensure the following prerequisite is met:
  • If the PBSM tenant has undergone a G2 certification update, the updated PBSM wallet must be uploaded to DFCS prior to batch execution.
  • If the wallet is not updated post-G2 certification, all ADS batch runs will fail regardless of data availability. Contact Oracle Support to complete the wallet upload.
  1. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Batch. For more details, see Define Batch.
  2. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Task. For more details, see Adding a Task.

    Refer to the following table for Component and Parameters to be defined for different tasks.

    Table 4-9 Components and Parameters

    Component Parameters Target Tables
    PBSM_DFCS_Data_Transfer_instruments

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Data File Specification Id: This displays list of seeded and user defined DFS definitions. Select one relevant value for the selected ADS.

    Data Source Id: This displays members of ‘Instrument Data Source’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    Stage Assets

    Stage Liabilities

    Stage Derivatives

    Stage Fee Based Services

    Stage Loan Commitments

    Stage Off Balance Sheet
    PBSM_DFCS_Data_Transfer_Dimensions

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    		Stage Dimensions Interface
    PBSM_DFCS_Data_Transfer_ExchangeRates

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Rate Data Source Id: This displays members of ‘Rate Data Source’ dimension. Select one value from LOV. Data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    		Stage Exchange Rates
    PBSM_DFCS_Data_Transfer_InterestRates

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Rate Data Source Id: This displays members of ‘Rate Data Source’ dimension. Select one value from LOV. Data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    		Stage IRC Rate History
    PBSM_DFCS_Data_Transfer_InstrumentSupplementary

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Data File Specification Id: This displays list of seeded and user defined DFS definitions. Select one relevant value for the selected ADS.

    Data Source Id: This displays members of ‘Instrument Data Source’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/String.

    Stage Account Index History

    Stage Account Rate Tiers

    Stage Embedded Options Schedule

    Stage Payment Schedule

    Stage Interest Rate Schedule

    PBSM_DFCS_Data_Transfer_Transaction_Summary

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Data File Specification Id: This displays the list of DFS rules defined for a Staging table. Select one relevant value for the selected ADS.

    Data Source Id: This displays members of ‘Transaction’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/ String.

    Stage Asset Transaction

    Stage Liability Transaction

    Stage Fee Based Transaction

    Stage Off Balance Sheet Transaction

    PBSM_DFCS_Data_Transfer_Customer

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Data Source Id: This displays members of ‘Customer’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/ String.

    Stage Customer Hierarchy

    Stage Customer Master

    PBSM_DFCS_Data_Transfer_Management_Ledger

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Data File Specification Id: This displays the list of DFS rules defined for a Staging table. Select one relevant value for the selected ADS.

    Data Source Id: This displays members of ‘Transaction’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/ String.

    		Stage Management Ledger
    PBSM_DFCS_Data_Transfer_EconomicInd

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Rate Data Source Id: This displays members of ‘Transaction’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/ String.

    Stage Economic Indicator Rate History
    PBSM_DFCS_Data_Transfer_VolatilityRates

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Rate Data Source Id: This displays members of ‘Transaction’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/ String.

    Stage IRC Volatility Rate History

    Stage Interest Rate Schedule
    PBSM_DFCS_Data_Transfer_VolatilitySurface

    ADS Id: This displays list of data connectors available. Select one value from LOV.

    Rate Data Source Id: This displays members of ‘Transaction’ dimension. Select one value from LOV. Instrument data belonging to this source only will be moved from DFCS to PBSM.

    Optional Input: This can be used to specify any other input parameter in JSON Object/ String.

    Stage Volatility Surface Rate History
  3. Select the seeded batch and click Edit Parameters. In the Dynamic Parameters pop-up window, change the date to the relevant As-of-Date, and then save the batch.
  4. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Execute Batch. For more information, see Schedule Batch.
  5. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Monitor Batch. For more information, see Monitor Batch.
  6. Select the Batch, MISDATE and the Batch name. Select the latest execution and click Start Monitor.