How to do reprocessing for Event driven integrations in OIC Gen 3?

Summary:

We need to receive payloads through an OIC-exposed URL, which serves as the endpoint for a publisher integration subscribing to a custom OIC event we created based on specific requirements. A subscriber integration is in place to track the event and process the data once it is published. As part of this subscriber integration, we call an Oracle ERP Cloud SaaS API to update payment attributes.

The flow generally completes without significant issues. However, we have encountered scenarios where the SaaS API may be down during the update process. In such cases, we update a table with an error status to avoid requesting the source to republish the data.