CAC AP Accrual Reconciliation Load Request
Description:
Report to show when the A/P Accrual Reconciliation Load program was run and by whom, including the Ledger, Operating Unit, Build Id, Request Id, Creation Date and Last Updated By.
Parameters:
Beginning Creation Date: enter the starting creation date to report, based on the operating unit for your session’s inventory organization (optional). Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional).
/* +=============================================================================+ – | Copyright 2019 - 2025 Douglas Volz Consulting, Inc. – | All rights reserved. – | Permission to use this code is granted provided the original author is – | acknowledged. No warranties, express or otherwise is included in this permission. – +=============================================================================+ – | – | Original Author: Douglas Volz (doug@volzconsulting.com) – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 31 Oct 2019 Douglas Volz Initial Coding – | 1.1 28 Jan 2025 Douglas Volz Added creation date parameter – | 1.2 15 Feb 2025 Douglas Volz Added Operating Unit and Ledger Security – | Profile Controls and parameters. – +=============================================================================+*/
Parameters
Beginning Creation Date, Operating Unit, Ledger
Used tables
cst_reconciliation_build, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, fnd_user, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, mo_glob_org_access_tmp, dual
Categories
Related reports
CAC Inventory Organization Summary, CAC AP Accrual IR ISO Match Analysis, CAC AP Accrual Reconciliation Summary by Match Type
Dependencies
If you would like to try one of these Oracle EBS SQLs without having Blitz Report installed, note that some of the reports require functions from utility package xxen_util.
Example Report
Report SQL
www.enginatics.com/reports/cac-ap-accrual-reconciliation-load-request/
Blitz Report™ import options
CAC_AP_Accrual_Reconciliation_Load_Request.xml
Case Study & Technical Analysis: CAC AP Accrual Reconciliation Load Request
Executive Summary
The CAC AP Accrual Reconciliation Load Request report is an audit and diagnostic tool designed for Cost Accountants and Finance Managers. It tracks the execution history of the “Accrual Reconciliation Load Run” program, which is a prerequisite for reconciling the Accounts Payable (AP) accrual accounts. By providing visibility into when the load was run, who ran it, and for which operating units, this report helps ensure that the accrual data is up-to-date before month-end reconciliation activities begin.
Business Challenge
The AP Accrual Reconciliation process in Oracle EBS relies on a concurrent program to populate the reconciliation tables (CST_RECONCILIATION_BUILD). Organizations often face challenges such as:
- Stale Data: Users attempting to reconcile accounts using outdated data because the load program hasn’t been run recently.
- Process Visibility: Uncertainty about whether the load program was successfully executed for a specific Operating Unit or Ledger.
- Audit Compliance: Lack of a clear audit trail showing who triggered the data refresh and when, which is critical for financial controls.
The Solution
The CAC AP Accrual Reconciliation Load Request report solves these issues by providing a clear history of the load program’s execution. It enables users to:
- Verify Data Freshness: Confirm the “Run To Date” to ensure the reconciliation data includes the latest transactions.
- Monitor Schedule Compliance: Check if the load program is being run according to the month-end close schedule.
- Identify Process Owners: See exactly which user (
Created_By) initiated the request, facilitating accountability and communication.
Technical Architecture (High Level)
The report queries the specific build history table used by the Cost Management module.
- Core Table:
CST_RECONCILIATION_BUILDstores the history of each load request, including the build ID and date ranges. - Context:
HR_ALL_ORGANIZATION_UNITS_VLandGL_LEDGERSprovide the organizational context, linking the technical build ID to business units. - Security: The report incorporates robust security logic, respecting both Ledger Security (via
GL_ACCESS_SET_NORM_ASSIGN) and Operating Unit Security (viaMO_GLOB_ORG_ACCESS_TMP), ensuring users only see history for entities they are authorized to access.
Parameters & Filtering
The report supports the following parameters:
- Beginning Creation Date: Filters the history to show only load requests created on or after a specific date, useful for focusing on the current period.
- Operating Unit: Allows filtering by specific operating units to audit a particular entity.
- Ledger: Enables filtering by the general ledger to see all related operating units.
Performance & Optimization
The report is designed for high performance:
- Direct Table Access: It queries the build history table directly rather than calculating accruals, making it instantaneous.
- Efficient Joins: Uses standard foreign key joins between the build table, organization definitions, and user tables.
- Security Profiles: The security clauses are optimized to use standard Oracle temporary tables and profile options, ensuring consistent performance even in complex multi-org environments.
FAQ
Q: What is the “Build ID”? A: The Build ID is a unique system-generated identifier for each execution of the Accrual Load program. It links the request to the specific set of data populated in the reconciliation tables.
Q: Why is the “Run To Date” important? A: The “Run To Date” indicates the cutoff date for transactions included in that specific load. If you are reconciling for January, you need to ensure the load was run with a “Run To Date” of at least Jan 31st.
Q: Does this report show the actual accrual balance? A: No, this is a metadata report about the process of loading data. To see the actual balances and transactions, you would use reports like “CST AP and PO Accrual Reconciliation”.
Oracle E-Business Suite Reporting Library
We provide an open source Oracle EBS SQLs as a part of operational and project implementation support toolkits for rapid Excel reports generation.
Blitz Report™ is based on Oracle EBS forms technology, and hence requires minimal training. There are no data or performance limitations since the output files are created directly from the database without going through intermediate file formats such as XML.
Blitz Report can be used as BI Publisher and Oracle Discoverer replacement tool. Standard Oracle BI Publisher and Discoverer reports can also be imported into Blitz Report for immediate output to Excel. Typically, reports can be created and version tracked within hours instead of days. The concurrent request output automatically opens upon completion without the need for re-formatting.
The Filters, Columns, Rows and Values fields are used to create and deliver the data in pivot table format with full drill down to details.
The Excel template upload functionality in Blitz Report allows users to create their own layouts by uploading an Excel template with additional sheets and charts, automatically refreshed when the report runs again. This allows to create custom dashboards and more advanced visualizations of report data.
You can download and use Blitz Report free of charge for your first 30 reports.
The installation and implementation process usually takes less than 1 hour; you can refer to our installation and user guides for specific details.
If you would like to optimize your Oracle EBS implementation and or operational reporting you can visit www.enginatics.com to review great ideas and example usage in blog. Or why not try for yourself in our demo environment.
Useful Links
Blitz Report™ – World’s fastest data upload and reporting for Oracle EBS
Oracle Discoverer replacement – importing worksheets into Blitz Report™
Blitz Report™ Questions & Answers
Supply Chain Hub by Blitz Report™
© 2025 Enginatics