- In the Integrations section of the
project workspace, click Actions
on the integration flow, then select
Run.
- On the Configure and run page, enter a value in the throttling parameter MaxRecords_fromDB to specify the number of records that should be fetched per run from the parking lot table (PAYLOAD_PARKING_LOT_TAB) in Oracle ATP.
- On the Configure and run page, click
Run.
You've now successfully submitted
the integration for execution. The integration now reads the data from the parking lot table, and dispatches the data to the asynchronous integration flow SR_OneWay_Processor_HCM_To_Payroll, thus triggering the integration flow to process the batch records fetched from the parking lot table (PAYLOAD_PARKING_LOT_TAB). In the parking lot table, the status of the batch records that were submitted for processing changes from NEW to PROCESSED.
The SR_OneWay_Processor_HCM_To_Payroll integration flow processes the batch files and calls the downstream application via a REST API call. It updates the batch statistics (BATCH_STATISTICS) table in ATP with the status of each record that is being processed.
The records that the downstream application could not process are written to the payload error table (PAYLOAD_ERRORS_TAB) in ATP with the status as ERRORED. When the errors are rectified, the status of the records changes to READY.
The SR_ScheduledDispatcher_PayrollErrors integration flow can be run to fetch the READY records from the payload error table (PAYLOAD_ERRORS_TAB), process them, and send them to the downstream application.