CAC Receiving Account Detail – Oracle EBS SQL Report

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

Overview

Report to get the receiving accounting distributions, in detail, by item, purchase order, purchase order line, release, project number, transaction date, creation date, created by and transaction identifier. With the Show SLA Accounting parameter you can choose to use the Release 12 Subledger Accounting (Create Accounting) account setups by selecting Yes. And if you have not modified your SLA accounting rules, select No to allow this report to run a bit faster. With Show WIP Outside Processing parameter to display or not display WIP outside processing information (WIP job and OSP resource code) and Show Project Information to display or not display the project, project name and task. And if you accrue expense receipts at time of receipt, for expense destinations when there is no item number, this report will get the expense category information and put it into the columns for the first category.

(Note: this report has not been tested with encumbrance entries.)

Parameters:

Transaction Date From: enter the starting transaction date (mandatory). Transaction Date To: enter the ending transaction date (mandatory). Show SLA Accounting: enter Yes to use the Subledger Accounting rules for your accounting information. If you choose No the report uses the pre-Create Accounting entries. Show Projects: display the project, project name and task. Enter Yes or No, use to limit the reported columns (mandatory). Show WIP Outside Processing: display the WIP job and outside processing resource. Enter Yes or No, use to limit the reported columns (mandatory). Category Set 1: any item category you wish, typically the Cost or Product Line category set (optional). Category Set 2: any item category you wish, typically the Inventory category set (optional). Transaction Type: enter the transaction type to report (optional). Minimum Absolute Amount: enter the minimum debit or credit to report (optional). To see all accounting entries, enter zero (0) and leave the other parameters blank. Supplier Name: enter the specific supplier you wish to report (optional). PO Number: enter the specific purchase order number you wish to report (optional). Destination Code: enter the purchase order destination type you wish to report (optional). You can choose Inventory, Expense or Shop Floor (WIP outside processing). Item Number: enter the specific item number(s) you wish to report (optional). Organization Code: enter the specific inventory organization(s) you wish to report (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 2010 - 2022 Douglas Volz Consulting, Inc. – | 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) – | – | Program Name: xxx_rcv_dist_xla_detail_rept.sql – | – | Version Modified on Modified by Description – | ======= =========== ============== ========================================= – | 1.0 05 Apr 2010 Douglas Volz Initial Coding based on XXX_RCV_DIST_XLA_SUM_REPT.sql – | 1.18 21 Aug 2022 Douglas Volz Streamline dynamic SQL code. – | 1.19 03 Sep 2022 Douglas Volz Add Accounting Line Type, Transaction Type and Minimum Amount parameters. – | And language translations for Accounting Line Types. – | 1.20 08 Oct 2022 Douglas Volz Add project task information. – +=============================================================================+*/

Report Parameters

Transaction Date From, Transaction Date To, Show SLA Accounting, Show Project Information, Show WIP Outside Processing, Category Set 1, Category Set 2, Category Set 3, Transaction Type, Minimum Absolute Amount, Supplier Name, PO Number, Destination Code, Item Number, Organization Code, Operating Unit, Ledger

Oracle EBS Tables Used

po_releases_all, mtl_units_of_measure_vl, org_acct_periods, gl_code_combinations, fnd_lookup_values, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, po_lookup_codes, fnd_user, &project_tables, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, mo_glob_org_access_tmp, dual

Report Categories

Enginatics, Nidec changes, R12 only

CAC Receiving Expense Value (Period-End), CAC Receiving Value (Period-End), CAC Manufacturing Variance, CAC WIP Resource Efficiency, CAC Invoice Price Variance, GL Account Analysis, CAC Receiving Account Summary, GL Account Distribution Analysis

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 CAC Receiving Account Detail 03-Sep-2022 132129.xlsx
Blitz Report™ XML Import CAC_Receiving_Account_Detail.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-receiving-account-detail/

Case Study & Technical Analysis: CAC Receiving Account Detail

Executive Summary

The CAC Receiving Account Detail report is a forensic accounting tool for the Receiving module. It lists the specific accounting entries (Debits and Credits) generated by receiving transactions. This is critical for reconciling the “Receiving Inspection” (Asset) and “PO Accrual” (Liability) accounts.

Business Challenge

Solution

This report bridges the gap between Operations and Finance.

Technical Architecture

Parameters

Performance

FAQ

Q: Why are there two entries for one receipt? A: A standard receipt generates a Debit to Receiving Inspection and a Credit to the Accrual Account. Q: Does this show “Deliver” transactions? A: Yes, it shows the full flow: Receive (Dr Insp / Cr Accrual) -> Deliver (Dr Inv / Cr Insp).

© 2026 Enginatics