Oracle EBS Cost Accounting Reports
108 ready-to-run SQL reports for Oracle E-Business Suite Cost Accounting, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Cost Accounting tables in these reports are mtl_parameters, gl_ledgers, hr_organization_information, hr_all_organization_units_vl, org_access_view, mfg_lookups.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
Cost Accounting SQL Reports
| Report | Description |
|---|---|
| CAC AP Accrual Accounts Setup | 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… |
| CAC AP Accrual IR ISO Match Analysis | Use this report to match the A/P Accrual entries for internal order inventory receipts with the internal order payables invoices, by the internal sale order… |
| CAC AP Accrual Reconciliation Load Request | 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… |
| CAC AP Accrual Reconciliation Summary by Match Type | Use this report to summarize the A/P Accrual entries from the Accrual Reconcilation Report tables, by operating unit, accrual match type and inventory… |
| CAC Accounting Period Status | Report to show the accounting period status for General Ledger, Inventory, Lease Management, Payables, Projects, Purchasing and Receivables. You can choose All… |
| CAC Calculate Average Item Costs | Using purchase order receipts, calculate average item costs over a specified transaction date range and compare against the Comparison Cost Type. In addition… |
| CAC Calculate ICP PII Item Costs | Report to identify the intercompany “To Org” profit in inventory (also known as PII or ICP) for each inventory organization and item. Report gets the PII item… |
| CAC Calculate ICP PII Item Costs Multi-Hop | Calculates the intercompany profit in inventory (PII or ICP) for each item and receiving organization, accumulated over every transfer of the sourcing chain… |
| CAC Calculate ICP PII Item Costs by Where Used | Report to identify the intercompany “To Org” profit in inventory (also known as PII or ICP) for each inventory organization and item. Gets the PII item costs… |
| CAC Category Accounts Setup | Report to show the category accounts in use. If category accounts have been set up with your Subledger Accounting Rules, the Inventory Cost Processor can use… |
| CAC Cost Group Accounts Setup | Report to show the cost group accounts in use. If using Average Costing, FIFO Costing, LIFO Costing, WMS (Warehouse Management System) or Project… |
| CAC Cost Type Costs Not in Period Close Inventory Snapshot | Report comparing the month-end items, balances and costs against any entered Cost Type, showing which item numbers in your month-end inventory which are not in… |
| CAC Cost vs. Planning Item Controls | Compare item make/buy controls vs. costing based on rollup controls, to find errors with your cost rollup results. There are twelve included reports, see below… |
| CAC Deferred COGS Out-of-Balance | Report to find the out-of-balance deferred COGS entries by organization, item and sales order number. You do not need to run Create Accounting as this report… |
| CAC Department Overhead Rates | Report to show departmental overheads and rates / +=============================================================================+ – | Copyright 2016 - 2020… |
| CAC Department Overhead Setup | Report to show the departments and the overhead codes assigned to each department. In addition, this report displays the corresponding overhead and resource… |
| CAC Department Overhead Setup Errors | This report displays two types of department overhead setup errors. First, show overheads which are not assigned to departments, but, have been assigned to… |
| CAC ICP PII Inventory Pending Cost Adjustment | Report showing potential standard cost changes for onhand and intransit inventory value which you own, for gross, profit in inventory and net inventory values… |
| CAC ICP PII Inventory and Intransit Value (Period-End) | Report showing amount of profit in inventory at the end of the month. If you enter a cost type this report uses the item costs from the cost type; if you leave… |
| CAC ICP PII Item Cost Summary | Report to show item costs in any cost type, including the profit in inventory costs (also known as ICP or PII). For one or more inventory organizations. /… |
| CAC ICP PII Material Account Detail | Report to get the Material accounting distributions, in detail, for each item, organization and individual transaction. Including profit in inventory amounts… |
| CAC ICP PII Material Account Summary | Use this report to eliminate your internal profit in inventory (PII) at month-end. This report to sums up the material accounting entries for each item… |
| CAC ICP PII WIP Material Usage Variance | For your open and closed WIP jobs use this report to calculate the amount of profit in inventory (PII) in WIP as well as the amount of PII in the WIP variances… |
| CAC ICP PII WIP Pending Cost Adjustment | Report showing the potential standard cost changes for WIP discrete jobs, for the WIP completions, WIP component issues and WIP resource (labor) transactions… |
| CAC ICP PII vs. Item Costs | Report to compare the Frozen or Pending Costs against the PII item costs. If you enter a Period Name this report also shows the stored month-end from the… |
| CAC Inactive Items Set to Roll Up | Report to show items which are set to roll up even though these items have an inactive status. The Cost Rollup uses the Based on Rollup Flag to control if an… |
| CAC Intercompany Relationship Setup | Report to show accounts used for the intercompany parameters and relationships across operating units. /… |
| CAC Intercompany SO Price List | Report to show the intercompany sales order (SO) price list information, including the item number, price list name and related information. Price list… |
| CAC Intercompany SO Price List vs. Item Cost Comparison | Report to show the internal SO price lists, source org item costs and compare against the “To Org” item costs and PII (profit in inventory) amounts. This… |
| CAC Intercompany SO Shipping Transaction vs. Invoice Price | Report to compare the transaction item cost from the selling internal org to the invoice sales price the selling internal organization is charging the internal… |
| CAC Interface Error Summary | Use this report to view your transactions that are pending or have errors in the Oracle interface tables. Across both Financial and Supply Chain Applications… |
| CAC Internal Order Shipment Margin | Report to display the internal sales orders/requisition shipments with COGS, margin, inter-company profit and other useful information. This report separately… |
| CAC Intransit Value (Real-Time) | Report to show intransit values across all ledgers for current onhand balances and current costing method costs. This is a “real-time” report, showing the… |
| CAC Inventory Account Alias Setup | Report to show accounts assigned for inventory account aliases / +=============================================================================+ – | Copyright… |
| CAC Inventory Accounts Setup | Report to show Valuation, Receiving, Profit and Loss and Inter-Org accounts as setup in the inventory organization parameters. /… |
| CAC Inventory Lot and Locator OPM Value (Period-End) | Report showing amount of inventory at the end of the month for Process Manufacturing (OPM) inventory organizations, for both onhand and intransit inventory. If… |
| CAC Inventory Organization Summary | Report to show inventory org names, summary org controls, org hierarchy, operating unit and Ledger, and whether or not the Org should be rolled up for costing… |
| CAC Inventory Out-of-Balance | Report to show any differences in the period end snapshot that is created when you close the inventory periods. This represents any differences between the… |
| CAC Inventory Pending Cost Adjustment | Report showing the potential standard cost changes for onhand and intransit inventory value which you own. If you enter a period name this report uses the… |
| CAC Inventory Pending Cost Adjustment - No Currencies | Report showing the potential standard cost changes for onhand and intransit inventory value which you own. If you enter a period name this report uses the… |
| CAC Inventory Periods Not Closed or Summarized | Report to find all inventory accounting periods which are either still open or closed but not summarized. When you close the inventory accounting period, the… |
| CAC Inventory and Intransit Value (Period-End) | Report showing amount of inventory at the end of the month. If you enter a cost type this report uses the item costs from the cost type; if you leave the cost… |
| CAC Inventory and Intransit Value (Period-End) - Discrete/OPM | Report showing amount of inventory at the end of the month for both Discrete and Process Manufacturing (OPM) inventory organizations. If you enter a cost type… |
| CAC Inventory to G/L Reconciliation (Restricted by Org Access) | For Discrete Costing, this report compares the General Ledger inventory balances with the perpetual inventory values (based on the stored month-end inventory… |
| CAC Inventory to G/L Reconciliation (Unrestricted by Org Access) | Report to compare the General Ledger inventory balances with the perpetual inventory values (based on the stored month-end inventory balances, generated when… |
| CAC Invoice Price Variance | Report to display the Invoice Price Variances (IPV), Exchange Rate Variances (ERV) and A/P Accrual Write-Off Variances for an entered date range. IPV is the… |
| CAC Item Cost & Routing | Report to show detailed item costs for buy and make items for one or any two cost types. If you enter multiple cost types you will get a row-by-row comparison… |
| CAC Item Cost Break-Out by Activity | Report to show item costs by cost element, by activity. Using up to five entered activities. In order for this report to show your activity costs you must… |
| CAC Item Cost Comparison | Report to compare the item costs from two cost types in any two inventory orgs, converting the Org Code 1 (Source Org) into the currency of Org Code 2 (To… |
| CAC Item Cost Out-of-Balance | Report to compare summary and detail item cost information and show any out-of-balances. Any difference may cause an inventory reconciliation issue between the… |
| CAC Item Cost Summary | Report to show item costs in any cost type. For one or more inventory organizations. Parameters: =========== Cost Type: enter the cost type(s) you wish to… |
| CAC Item List Price vs. Item Cost | Compare item master list price against any cost type (Cost Type 1) and also list the Standard Price (Market Price), Last PO Price, Converted Last PO Price and… |
| CAC Item Master Accounts Setup | Report to show item master accounts and related information by item. / +=============================================================================+ – |… |
| CAC Item vs. Component Include in Rollup Controls | Use this report to find items where the item master default setting for include in rollup does not match the BOM component include in rollup setting. This… |
| CAC Items Without This Level Material Overhead | Report to show item costs which do not have this level material overhead, for any cost type. For one or more inventory organizations. Parameters: ===========… |
| CAC Last Standard Item Cost | Report to show the last standard item cost as of a specified cost update date; expecially useful if you have not saved off your Frozen costs at year-end… |
| CAC Load More4Apps Buy Item Costs | Report to fetch all buy items (based on rollup = No). Used as a source of item costs for buy items which you wish to edit or change using the More4Apps Item… |
| CAC Manufacturing Variance | Report your summary or detail manufacturing variances for open and closed WIP jobs. If the job is open the Report Type column displays “Valuation”, as this WIP… |
| CAC Margin Analysis Account Summary | Report for the margin from the customer invoices and shipments, including the Sales and COGS accounts, based on the standard Oracle Margin table… |
| CAC Margin Analysis Summary | Report for the margin from the customer invoices and shipments, based on the standard Oracle Margin table, cstmarginsummary. (If you want to show the COGS and… |
| CAC Material Account Alias with Lot Numbers | Report to display the material account alias transactions by lot number. Specify Yes for Show Lot Number to split out the transaction quantities and amounts by… |
| CAC Material Account Detail | Report to get the Material accounting distributions, in detail, for each item, organization and individual transaction. Including Ship From and Ship To… |
| CAC Material Account Summary | Report to get the Material accounting distributions, in summary, for each item, organization and subinventory. Including Ship From and Ship To information for… |
| CAC Material Overhead Setup | Report to show the material overhead sub-element definition and the default material overheads, if any. /… |
| CAC Missing Material Accounting Transactions | Report to find material accounting entries where the material transaction’s costed flag says that the transaction has been costed but the material accounting… |
| CAC Missing Receiving Accounting Transactions | Report to find receiving transactions where the receiving accounting entries do not exist, for PO receipts into receiving and for returns from inventory and… |
| CAC Missing WIP Accounting Transactions | 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… |
| CAC New Items | Report to show items which have been recently created, including various item controls, item costs (per your Costing Method), item master accounts, last… |
| CAC New Standard Item Costs | Report to show items which have recent item cost changes, including various item controls, last cost update submission, new standard item cost, prior item cost… |
| CAC Number of Item Costs by Cost Type | Report to show the count of item costs by cost type. Use this report after you copy from one cost type to another, to ensure all rows have been copied over. /… |
| CAC OPM Batch Material Summary | Report showing Batch materials in summary for each product, byproduct and ingredient. Displaying batches which were open during the monthly inventory… |
| CAC OPM Costed Formula | eport showing OPM formulas and item costs, by OPM Cost Component Class. The report automatically displays the first thirty Cost Components, sorted by Usage… |
| CAC OPM Item Cost Detail | Oracle Process Manufacturing (OPM) item cost detail: the costed value of each item broken out by cost component class (material, labor, burden, overhead) and… |
| CAC OPM WIP Account Value | Report to show WIP values for process manufacturing (OPM), in summary by inventory organization and batch, with batch status, name and other details. The… |
| CAC Onhand Lot Value (Real-Time) | Report for onhand inventory at the time you run the report (real-time). By organization, Lot and Subinventory. If you leave the Cost Type blank the report will… |
| CAC Open Purchase Orders | Report to show open purchase orders and related information. This report will convert any foreign currency purchases into the currency of the general ledger… |
| CAC Order Type Setup | Report to display the sales order transaction types with the corresponding receivables (A/R) transaction types. /… |
| CAC PO Price vs. Costing Method Comparison | Report to compare the open purchase order lines and unit prices with the costing method item cost in Oracle (Average, Standard, FIFO or LIFO). Used by the… |
| CAC PO Receipt History for Actual Costing | Report to show Purchase Order (PO) Receipt History for non-Standard Cost inventory organizations, by PO receipt date range. You may also use this report for… |
| CAC PO Receipt History for Item Costing | Report to show Purchase Order (PO) Receipt History for inventory organizations, for a selected PO receipt date range. If the Comparison Cost Type is not… |
| CAC Purchase Price Variance | Report for Purchase Price Variance accounting entries for external inventory purchases, external outside processing purchases, (internal) intransit shipments… |
| CAC Receiving Account Detail | Receiving accounting distributions in detail by item, purchase order, release, transaction date, creation date, created by and transaction id. Show SLA… |
| CAC Receiving Account Summary | Report to get the receiving accounting distributions, in summary, by item, purchase order, purchase order line, release and project number. With the Show SLA… |
| CAC Receiving Activity Summary | Especially for companies who do not use separate inspection receipt processes, this report nets the initial purchase order receipt into receiving against the… |
| CAC Receiving Expense Value (Period-End) | Report to show receiving value for expense locations and expense destination types, for expenses accrued at time of receipt. You may run this report for open… |
| CAC Receiving Value (Period-End) | Report to show receiving value for all locations, as of the end of an accounting period. You may run this report for open or closed accounting periods. With… |
| CAC Recost Cost of Goods Sold | Report to compare the “as transacted” cost of goods sold (COGS) transactions in Oracle Inventory with the “what if” costs from a simulation cost type. Use this… |
| CAC Resource Costs | Report to show the resource and outside processing costs by organization and cost type. Parameters: Cost Type: enter the cost type you wish to report, defaults… |
| CAC Resources Associated with Overheads Setup | Report to show which resources are associated with which overheads and which resources are associated with which departments. And find any resources which do… |
| CAC Resources by Department Setup | Report to show which resources are assigned to which departments. With the respective resource rates as well. /… |
| CAC Shipping Network (Inter-Org) Accounts Setup | Report to show accounts used for the inter-org shipping network. If the accounts are missing or invalid the account segments are shown as blank entries. /… |
| CAC Shipping Networks Missing Interco OU Relationships | Report to show the missing inventory intercompany operating unit relationships. This report has no parameters. /… |
| CAC Standard Cost Update Submissions | Report to show the Standard Cost Update submissions, by Cost Update Date. Including the parameters used and the overall inventory and WIP adjustment values… |
| CAC Subinventory Accounts Setup | Report to show accounts used for the subinventories; these valuation and expense accounts are used with Standard Costing. /… |
| CAC User-Defined and Rolled Up Costs | Use this report to find items with both user-defined (manually entered) and rolled up costs, for material and other cost elements. Useful to find rolled up… |
| CAC WIP Account Detail | Report to get the WIP accounting distributions, in summary, by WIP job, resource, overhead and WIP cost update. With the Show SLA Accounting parameter you can… |
| CAC WIP Account Summary | Report to get the WIP accounting distributions, in summary, by WIP job, resource, overhead and WIP cost update. With the Show SLA Accounting parameter you can… |
| CAC WIP Account Value | Report to show WIP values and all accounts for discrete manufacturing, in summary by inventory, organization, with WIP class, job status, name and other… |
| CAC WIP Accounts Setup | Report to show accounts used for WIP accounting classes. Parameters: Organization Code: specific inventory organization to report (optional) Operating Unit… |
| CAC WIP Jobs With Complete Status But Not Ready for Close | Report WIP jobs which have a status of “Complete” but exceed variance tolerances, have uncompleted assemblies, open material requirements, unearned OSP… |
| CAC WIP Jobs With Complete Status Which Are Ready for Close | Report WIP jobs which have a status of “Complete”, do not exceed variance tolerances, have completed or exceeded the WIP start quantity, with no open material… |
| CAC WIP Material Relief | Report to show WIP material variances on closed jobs for discrete manufacturing, in summary by inventory organization, with WIP class, job status, name and… |
| CAC WIP Material Usage Variance | Report your material usage variances for your open and closed WIP jobs. This report replicates the Material Variance Section for the Oracle Discrete Job Value… |
| CAC WIP Pending Cost Adjustment | Report showing the potential standard cost changes for WIP discrete jobs, for the WIP completions, WIP component issues, WIP resource (labor) and WIP overhead… |
| CAC WIP Period Balances to Accounting Activity Reconciliation | Report to compare the monthly WIP Period Balances with the pre-Create Accounting WIP accounting entries for material, resource, overhead, outside processing… |
| CAC WIP Resource Efficiency | Report your resource efficiency variances for your open and closed WIP jobs. Resource efficiency measures the WIP routing requirements against the actual… |
| CAC Where Used by Cost Type | Report to download the single-level bills of materials and related component information, by organization by cost type. And while exploding the bills of… |
| CAC Zero Item Costs | Report to show zero item costs in the Costing Method cost type, the creation date, the last transaction id, last transaction date and any onhand stock, based… |
Useful Links
- 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
© Enginatics GmbH