CAC AP Accrual Reconciliation Load Request – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

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. – +=============================================================================+*/

Report Parameters

Beginning Creation Date, Operating Unit, Ledger

Oracle EBS Tables Used

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

Report Categories

Enginatics

CAC Inventory Organization Summary, CAC AP Accrual IR ISO Match Analysis, CAC AP Accrual Reconciliation Summary by Match Type, CAC Missing WIP Accounting Transactions, CAC AP Accrual Accounts Setup, CAC Material Account Alias with Lot Numbers, CAC Interface Error Summary, CAC New Standard Item Costs, CAC Standard Cost Update Submissions

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output None
Blitz Report™ XML Import CAC_AP_Accrual_Reconciliation_Load_Request.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-ap-accrual-reconciliation-load-request/

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:

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:

Technical Architecture (High Level)

The report queries the specific build history table used by the Cost Management module.

Parameters & Filtering

The report supports the following parameters:

Performance & Optimization

The report is designed for high performance:

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”.

© 2026 Enginatics