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…
Taming SLA – Mapping Set Explosion cured by user-defined functions
Why this matters Most SLA implementations start with Mapping Sets because they’re easy to explain: ‘If attribute X = Y, return segment Z.’ But when Natural Account derivation depends on multiple conditions, Mapping Sets can grow into hundreds or thousands of rows—hard to maintain, risky to change, and painful to…
Identifying Approvers in Oracle Fusion – What SQL Can and Cannot Tell You
Approvals are where business controls, compliance, and user experience intersect. When a change request, purchase, or HR action stalls, knowing exactly who it has now, who already acted, and why it failed is critical for unblocking the process, meeting SLAs, and proving auditability. In Fusion Apps, that trail is split…
Mining Average Daily Balances (ADB) from Oracle ERP Cloud
• If you’ve enabled Average Daily Balances (ADB), daily data is stored in GL_DAILY_BALANCES (one row per period with day buckets) and made report-friendly by GL_DAILY_BALANCES_V (one row per GL date). • For functional/entered balances (currency types U/E/C), End-of-Day (EOD) is derived from period aggregates; the physical END_OF_DAY# columns are…