Sunday, June 22, 2025

OIC ERP - How to Restore Missed or exhausted business events in OIC

Receiving Missed Business Event in OIC

Step1: Deactivate an OIC Orchestration which has subscribed to ERP Business Events for PO Receipts.

Note: If the orchestration to be deactivated contains a business event subscription, a message is displayed asking if you want to delete the event subscription while deactivating the orchestration. If you select to delete the event subscription, the integration does not receive any events after it is reactivated. Below is just an example screenshot.

If you do not want to delete the event subscription, the events in this integration are resent if the integration is activated within six hours. Beyond 6 hours those requests will be exhausted.

Step2: Create PO Receipt. PO Receipt 10944 is created in fusion at 10:46 AM, during that time integration was deactivated.

Step3: Re-activate orchestration after some time.

Integration was activated at 1PM and we see that the Integration subscribed to the business event for the specific Receipt (10944)

Conclusion: Business events are retried in SaaS and automatically captured within 6 hours of unavailability of OIC services.

Restoring Exhausted Business Events

Step1: Deactivate Integration.

Integration is deactivated for one day. This integration subscribes to “PurchaseOrder” Business event.


Step2: Run API to find exhausted Business Events:

Total number of Exhausted Business event count in last 24 hours is 68.

API URL: <fusion url>/soa-infra/PublicEvent/diagnostic/exhaustedEventsDetail?lastHours=24&pageSize=100

/soa-infra/PublicEvent/diagnostic/exhaustedEventsCount?lastHours=24&pageSize=100

Note: We can find exhausted events for a specific Business Event like “PurchaseOrder” using Subscription ID. We have 43 requests which are exhausted in the last 24 hours. We have filtered out these using SubscriptionID.

 Step3: Activate the integration and restore the Exhausted event for “PurchaseOrder” using APIs

API URI: /soa-infra/PublicEvent/exhaustedEvents/restore

Sample Payload:

{

"subscriptionId": "(*****-***-***-**********-hy.integration.ap-hyderabad-1.ocp.oraclecloud.com):aHR0cHM6Ly9zb21pYy1vaWMtZGV2LWF4bGc4Ymlta2ZuZC1oeS5pbnRlZ3JhdGlvbi5hcC1oeWRlcmFiYWQtMS5vY3Aub3JhY2xlY2xvdWQuY29tL2ljL3dzL2ludGVncmF0aW9uL3YxL2Zsb3dzL2VycC9QT19FVkVOVC8xLjAv",

//"startDate": "29-04-2025 04:03:24",

//"endDate": "29-04-2025 10:20:25",

"lastHours":24

}

After restoring, check the count of Exhausted business event for “PurchaseOrder” is now 0

All 43 records have been subscribed through integration.

Conclusion: Restoring exhaust events is feasible via provided Oracle APIs

Poc document link:

https://docs.google.com/document/d/1E4KYFsKJhDrEEvYo9wQcHjZQraunWKgQ/edit?usp=drivesdk&ouid=105651791254983245041&rtpof=true&sd=true

Reference Document: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=13339287498551&id=2751325.1&_afrWindowMode=0&_adf.ctrl-state=ccb6zmdcu_4



No comments:

Post a Comment

Featured Post

OIC - OIC Utility to Reprocess Failed Real-Time Integration JSON Payloads

📌 Use Case In real-time OIC integrations, JSON payloads are exchanged with external systems via REST APIs. When such integrations fail (du...