Executive summary Peak loads often transform a healthy Oracle Integration (OIC Gen3 / Integration 3) flow into intermittent timeouts—especially when a downstream database slows down and the integration holds connections open too long. Using a real community scenario (PostgreSQL via Agent → Fusion receipt creation → PostgreSQL back update), this…
How to implement a configurable delay by invoking a parameterized BI Publisher report from Oracle Integration Cloud
Dynamic Wait in OIC Gen3 When the Wait Action Isn’t Truly Runtime-Parameterized: A BI Publisher (BIP) + PL/SQL Pattern How to implement a configurable delay by invoking a parameterized BI Publisher report from Oracle Integration Cloud Executive summary Teams often need a “dynamic wait” in Oracle Integration Cloud (OIC) Gen3…
Multiple Callback Integrations for the Same FBDI Job — How to Route by Source
OIC Gen3: Multiple Callback Integrations for the Same FBDI Job — How to Route by Source A practical pattern for Oracle ERP Cloud Adapter callbacks when multiple upstream sources submit the same FBDI process Problem statement In Oracle Integration Cloud (OIC) Gen3, it’s common to have multiple upstream systems that…
OIC Schedule startDate Format Defect Workaround
OIC Schedule REST API “startDate” Gotcha and What Works Instead A practical troubleshooting note for Oracle Integration schedule automation Executive summary When automating Oracle Integration Cloud (OIC) scheduled integrations via REST, you would typically expect the start timestamp to accept ISO 8601. However, multiple practitioners have observed HTTP 500 errors…
How to access Oracle Fusion GL Account Hierarchies with REST API
Accessing Oracle Fusion GL Account Hierarchies with REST API Overview In Oracle Fusion Cloud Financials, General Ledger (GL) account hierarchies are implemented using the Trees framework. An account hierarchy is a Tree defined under a Tree Structure and can have multiple date-effective versions. The most practical REST approach for reading…
Building Custom AI Bots in Oracle ERP Cloud: Lessons from a Proof of Concept
From RAG-based user guidance to API-driven financial copilots and AI-powered automations Executive summary In a recent proof of concept (PoC), we explored how to create custom AI bots that sit alongside Oracle ERP Cloud to help end users find guidance, retrieve transactional insights, and automate high-volume finance processes. The PoC…
How to Bulk Upload Oracle Fusion Lookup Codes with Context-Based DFF Values
If you’ve tried to bulk-load Lookup Codes in Oracle Fusion and also populate context-based Descriptive Flexfield (DFF) values, you may have seen errors like: This post explains why those errors occur and provides a repeatable, practical method to load lookup codes with a DFF context and segment values correctly. The…