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…
Pause/Resume OIC Integrations as per Oracle Fusion Patch Cycle
1. Summary Lot of times we have a need to pause all OIC integrations, primarily for ex. when there are scheduled downtimes. Below is a tentative, production‑ready solution design for managing pause and resume of scheduled integrations in Oracle Integration Cloud (OIC). In this solution, integration state is persisted in…