| layout | default |
|---|---|
| title | CAC Missing WIP Accounting Transactions | Oracle EBS SQL Report |
| description | Report to find work in process (WIP) accounting entries where the WIP transaction has been created but the WIP accounting entries do not exist. If you… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, CAC, Missing, WIP, Accounting, cst_cost_types, cst_resource_costs, wip_transactions |
| permalink | /CAC%20Missing%20WIP%20Accounting%20Transactions/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Report to find work in process (WIP) accounting entries where the WIP transaction has been created but the WIP accounting entries do not exist. If you enter Yes for "Only Costed Resources" the report ignores WIP transactions where the resource code is defined as not allowing costs (not costed). If you enter No for "Only Costed Resources" the report includes WIP transactions where the resource code does not allow costs as well as costed resources. And to get all transactions which are missing the WIP accounting entries, even for transactions where the resources are not costed, set the "Only Costed Resources" to No and the Minimum Transaction Amount to zero (0).
/* +=============================================================================+ -- | Copyright 2022 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. |
| -- +=============================================================================+ |
|---|
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- |
| -- +=============================================================================+*/ |
Transaction Date From, Transaction Date To, Minimum Transaction Amount, Only Costed Resources, Organization Code, Operating Unit, Ledger
cst_cost_types, cst_resource_costs, wip_transactions, wip_entities, bom_resources, cst_cost_elements, mtl_system_items_vl, mtl_txn_source_types, org_acct_periods, mtl_parameters, mfg_lookups, hr_organization_information, hr_all_organization_units_vl, gl_ledgers, wip_transaction_accounts, org_access_view, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, mo_glob_org_access_tmp, dual
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.
| Resource | Link |
|---|---|
| Excel Example Output | CAC Missing WIP Accounting Transactions 23-Jul-2022 161739.xlsx |
| Blitz Report™ XML Import | CAC_Missing_WIP_Accounting_Transactions.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/cac-missing-wip-accounting-transactions/ |
The CAC Missing WIP Accounting Transactions report is a diagnostic tool for the Work in Process (WIP) module. It identifies WIP transactions—such as Component Issues, Resource Transactions, and Assembly Completions—that have been processed but failed to generate the corresponding accounting entries in the WIP_TRANSACTION_ACCOUNTS table.
- WIP Valuation: If a resource is charged to a job ($100 debit to WIP) but no accounting is generated, the WIP General Ledger balance will be understated compared to the operational reality.
- Period Close: Unaccounted transactions can prevent the accounting period from closing or lead to "Sweep" transactions that distort future periods.
- Cost Accuracy: Missing entries mean the job cost is incomplete, leading to incorrect variance calculations upon job close.
This report identifies the gaps.
- Logic: Compares
wip_transactionstowip_transaction_accounts. - Resource Filter: Can optionally ignore "Uncosted" resources (resources set up to not generate costs), reducing false positives.
- Scope: Covers all WIP transaction types.
- Tables:
wip_transactions(WT),wip_transaction_accounts(WTA). - Join:
WT.transaction_id = WTA.transaction_id (+). - Condition:
WTA.transaction_id IS NULL.
- Transaction Date From/To: (Mandatory) Period.
- Only Costed Resources: (Mandatory) "Yes" is recommended to avoid seeing transactions for resources that are designed to be free.
- Minimum Amount: (Optional) To filter out zero-dollar transactions.
- Efficient: Uses standard anti-join logic.
- Volume: WIP transaction volume can be high in manufacturing environments, so date filtering is important.
Q: How do I fix these? A: These often require a data fix from Oracle Support or a specialized script to re-trigger the "WIP Cost Manager".
Q: Does this include "Move" transactions? A: Only if the Move transaction includes a "Resource" charge (Shop Floor Move). Pure moves often do not generate accounting unless they trigger a resource or overhead charge.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics