CAC AP Accrual Accounts Setup – Oracle EBS SQL Report

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

Overview

Report to show the valid A/P Accrual Accounts which have been set up in the Select Accrual Accounts Form. Showing the Ledger, Operating Unit, Accrual Accounts, Creation Date, Created By and Last Updated By. The A/P Accrual Load Program uses these accounts to find the Payables, Receiving and Inventory accounting accrual entries for the A/P Accrual Load results.

Parameters:

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 2008 - 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 10 Nov 2008 Douglas Volz Initial Coding – | 1.1 08 Nov 2011 Douglas Volz Modified for Release 12 – | 1.2 15 Feb 2025 Douglas Volz Added Ledger and Operating Unit parameters, – | and added G/L and Operating Unit Security Controls. – +=============================================================================+*/

Report Parameters

Operating Unit, Ledger

Oracle EBS Tables Used

cst_accrual_accounts, gl_code_combinations, 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 AP Accrual IR ISO Match Analysis, CAC AP Accrual Reconciliation Summary by Match Type, CAC Receiving Value (Period-End), CAC Inventory Organization Summary, CAC Material Account Alias with Lot Numbers, CAC Cost Group Accounts Setup, CAC Subinventory Accounts Setup, CAC Category Accounts Setup, CAC ICP PII Inventory Pending Cost Adjustment

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_Accounts_Setup.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-ap-accrual-accounts-setup/

CAC AP Accrual Accounts Setup Report

Executive Summary

The CAC AP Accrual Accounts Setup report provides a detailed listing of all valid A/P accrual accounts that have been configured in the Select Accrual Accounts form. This report is a critical tool for cost accountants and system administrators, offering a clear view of the accounts that are used to track uninvoiced receipts and other accruals. By providing a comprehensive view of the A/P accrual account setup, the report helps to ensure that the A/P Accrual Load program runs correctly and that the accrual reconciliation process is accurate and efficient.

Business Challenge

The A/P accrual reconciliation process is a critical part of the month-end close. However, if the A/P accrual accounts are not set up correctly, it can lead to a number of challenges, including:

The Solution

The CAC AP Accrual Accounts Setup report provides a clear and detailed view of the A/P accrual account setup, helping organizations to:

Technical Architecture (High Level)

The report is based on a query of the cst_accrual_accounts table. This table stores all of the valid A/P accrual accounts that have been set up in the Select Accrual Accounts form. The report also uses several other tables to retrieve additional information, such as the ledger, operating unit, and the user who created and last updated the account.

Parameters & Filtering

The report includes two parameters that allow you to filter the output by operating unit and ledger.

Performance & Optimization

The CAC AP Accrual Accounts Setup report is designed to be efficient and fast. It uses direct table access to retrieve the data, which is much faster than relying on intermediate views or APIs. The report is also designed to minimize the use of complex joins and subqueries, which helps to ensure that it runs quickly and efficiently.

FAQ

Q: What is the purpose of the Select Accrual Accounts form? A: The Select Accrual Accounts form is used to define the A/P accrual accounts that are used by the A/P Accrual Load program. This program is used to load the A/P accrual data into the cst_ap_po_reconciliation table, which is the main table used for A/P accrual reconciliation.

Q: Why is it important to have a clear understanding of the A/P accrual account setup? A: A clear understanding of the A/P accrual account setup is essential for ensuring the accuracy of your A/P accrual reconciliation process. It can also help you to troubleshoot any issues that you may encounter with the A/P Accrual Load program.

Q: Can I use this report to see who created and last updated the A/P accrual accounts? A: Yes, the report includes the creation date, the user who created the account, the last update date, and the user who last updated the account.

© 2026 Enginatics