Blitz Report™ Library
Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
175 reports
| Description | Download | ||
|---|---|---|---|
| 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 inter-org transfers. 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 parameters to also limit the report size. Use Show Subinventories to display or not display the subinventory information. Use Show Projects to display… full description | Cost Management Enginatics |   |
| CAC Material Overhead Setup | Report to show the material overhead sub-element definition and the default material overheads, if any.
/* +=============================================================================+
-- | Copyright 2011 - 2020 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.… full description | Cost Management Enginatics | |
| 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 entries do not exist. If you enter Yes for "Only Costed Items" the report ignores material transactions where the transaction item cost does not exist (null value) or where the item's inventory asset setting in the item master is set to No. If you enter No for "Only Costed Items" the report includes material transactions where the item cost does not exist or where the item's inventory asset setting is set to No. To get all… full description | Cost Management Enginatics | |
| 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 outside processing (work in process). To get all transactions which are missing receiving accounting entries, even for transactions where the transaction amounts are too small, set the Minimum Transaction Amount to zero (0). And note the quantities and purchase order unit prices are expressed in the item's primary unit of measure.
Note: To find missing purchase order deliveries into inventory or work in process, use the CAC Missing… full description | Cost Management Enginatics | |
| 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 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… full description | Cost Management Enginatics | |
| 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 transaction and onhand stock, based on the item master creation date.
Parameters:
===========
Creation Date From: starting item master creation date (required).
Creation Date To: ending item master creation date (required).
Include Uncosted Items: enter Yes to display items which are set to not be costed in your Costing Method Cost Type, defaulted as Yes (mandatory).
Category Set 1: any item category you wish, typically the Cost or… full description | Cost Management Enginatics | |
| 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.
/* +=============================================================================+
-- | Copyright 2017 - 2019 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.… full description | Cost Management Enginatics | |
| 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 cost analysis code, per cost calendar, period and method. Answers what makes up an item's OPM cost. | Cost Management Enginatics, R12 only | |
| 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 value the inventory using the inventory organization's Costing Method (Standard, Average, FIFO, LIFO). If you enter a Cost Type the report will use these item costs, plus, if any item costs are missing from the entered Cost Type, get the remaining item costs from the Costing Method Cost Type. Note that consigned quantities are reported but not valued. And if you choose to report expense subinventories, they are not valued… full description | Cost Management Enginatics | |
| 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 (defaulted from the inventory organization for this session). Use the To and From Transaction Date parameters to create an average receipt cost and use the Comparison Cost Type parameter to show a comparison
amounts from another cost type.
Parameters:
===========
Comparison Cost Type: enter the cost type for a comparison against the purchase order prices (optional). Defaulted from your Costing Method.
Transaction Date From: starting… full description | Cost Management Enginatics | |
| CAC Order Type Setup | Report to display the sales order transaction types with the corresponding receivables (A/R) transaction types.
/* +=============================================================================+
-- | Copyright 2016 - 2020 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.… full description | Cost Management Enginatics | |
| 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 buyers and cost accounting to check the accuracy of the recently created purchase orders and run using a range of purchase order line creation dates. Foreign currency purchase orders convert to the inventory organization's currency by either using the original purchase order exchange rate, if the Invoice Match Option is "Purchase Order" or by using the latest exchange rate date if the Invoice Match Option is… full description | Cost Management Enginatics | |
| 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 Standard Cost organizations but the CAC PO Receipt History for Item Costing report may be a better choice, as the following columns will have zero or empty values for Standard Cost organizations: prior costed quantity, prior cost and new onhand quantity.
/* +=============================================================================+
-- | Copyright 2006 - 2022 Douglas Volz Consulting, Inc. |
-- | All rights… full description | Cost Management Enginatics | |
| 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 entered the report uses the Cost Type from the Primary Costing Method, such as Frozen, Average, FIFO or LIFO. And note you may use this report for any discrete costing method but the CAC PO Receipt History for Actual Costing report may be a better choice for Average, FIFO and LIFO Costing, as additional information is available, such as the prior costed quantity, prior cost and new onhand quantity.
Parameters:
===========
Transaction Date… full description | Cost Management Enginatics | |
| CAC Purchase Price Variance | Report for Purchase Price Variance accounting entries for external inventory purchases, external outside processing purchases, (internal) intransit shipments, (internal) direct organization transfers and transfer to regular (consignment) transactions. The FOB point indicates when title passes to the receiving organization and it also determines which internal transfer transaction gets the PPV. With FOB Shipment, PPV happens on the Intransit Shipment transaction. With FOB Receipt, PPV happens on the Intransit Receipt transaction. And if you enter PO receipts by lot numbers this report… full description | Cost Management Enginatics | |
| 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 Accounting = Yes reports the Subledger Accounting (Create Accounting) account, and only distributions accounted in Subledger Accounting. No reports the receiving subledger account.
Show Project Information and Show WIP Outside Processing add the project and task, and the WIP job and outside processing resource columns.
Purchasing Category is the purchase order line category, which also categorizes expense receipts without an item.
On instances… full description | Cost Management Enginatics | |
| 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 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 parameters to limit the report size, to display or not display purchase information (purchase order, line, release) and WIP outside processing information (WIP job and OSP resource code). And… full description | Cost Management Enginatics | |
| 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 delivery into stock and WIP outside processing (OSP), for the entered transaction date range. By comparing the Purchasing Receipt transactions with the Purchasing Delivery transactions (for the purchasing receipts, material deliveries and WIP OSP deliveries). Enter the date range you wish to compare, typically a monthly date range. Differences may be due to the initial receipt occurring in the prior month, not running Create… full description | Cost Management Enginatics, R12 only | |
| 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 parameters to display or not display WIP outside processing information (WIP job, status, close date and OSP resource code). If run for a prior period the report automatically rolls back the quantities and values to the prior period's period end date. In addition, for any receipt with an item number, this report displays Inventory, Shop Floor (Outside Processing) and Expense destination types.
Note: The Adjustment Amount column show… full description | Cost Management Enginatics | |
| 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 to your Costing Method (mandatory).
Include Non-Costed Resources: choose No to exclude non-costed resources, choose Yes to include them. You normally use non-costed resources for scheduling purposes (mandatory).
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… full description | Cost Management Enginatics | |
| 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 not have any overhead associations. If there are no overhead associations the first report column will say "Missing".
If the resource/overhead association exists, the first column of the report will say "Set Up".
Note: if a resource does not have a cost, the Resource Rate column has a blank or empty value.
Parameters:
===========
Resource/Overhead Cost Type: enter the cost type you wish to report for your resources and overheads.… full description | Cost Management Enginatics | |
| CAC Resources by Department Setup | Report to show which resources are assigned to which departments. With the respective resource rates as well.
/* +=============================================================================+
-- | Copyright 2016 - 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.… full description | Cost Management Enginatics | |
| 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.
/* +=============================================================================+
-- | Copyright 2009 - 2020 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.… full description | Cost Management Enginatics | |
| CAC Shipping Networks Missing Interco OU Relationships | Report to show the missing inventory intercompany operating unit relationships. This report has no parameters.
/* +=============================================================================+
-- | Copyright 2009 - 2020 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.… full description | Cost Management Enginatics | |
| CAC Subinventory Accounts Setup | Report to show accounts used for the subinventories; these valuation and expense accounts are used with Standard Costing.
/* +=============================================================================+
-- | Copyright 2009 - 22 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.… full description | Cost Management Enginatics | |
| 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 assemblies where the item costs have been accidentally doubled-up.
Parameters:
===========
Cost Type: enter the cost type to report (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).
Assignment Set: enter the sourcing rule assignment set, used when transferring items between… full description | Cost Management Enginatics | |
| 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 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 parameters to limit the number of report columns, Show Project to display or not display the project number and name, Show WIP Job to display or not display the WIP job (WIP job, description and resource codes), Show WIP… full description | Cost Management Enginatics | |
| 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 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 parameters to limit the report size, Show Project to display or not display the project number and name, Show WIP Job to display or not display the WIP job (WIP job, description and resource codes) and Show WIP Outside… full description | Cost Management Enginatics | |
| 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 details. This report uses the valuation accounts from each discrete job and reports both jobs which were open during the accounting period as well as jobs closed during the accounting period. You can also run this report for earlier accounting periods and still get the correct amounts and the jobs that were open at that time.
Parameters
==========
Period Name: the accounting period you wish to report (mandatory).
Include Expense WIP:… full description | Cost Management Enginatics | |
| CAC WIP Accounts Setup | Report to show accounts used for WIP accounting classes.
Parameters:
Organization Code: specific inventory organization to report (optional)
Operating Unit: specific operating unit (optional)
Ledger: specific ledger (optional)
/* +=============================================================================+
-- | Copyright 2009 - 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.
--… full description | Cost Management Enginatics | |
| 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 (outside processing) charges or stuck transactions in interfaces. When you include scrap quantities, any scrapped assemblies are counted with the completed units. Note that for material requirements, expense items are ignored.
Parameters:
==========
Variance Amount Threshold: absolute maximum WIP variance or current job balance that is allowed for jobs you wish to close (required).
Variance Percent Threshold: absolute maximum WIP variance… full description | Cost Management Enginatics | |
| 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 requirements, no unearned OSP (outside processing) charges and no stuck transactions in interfaces. When you include scrap quantities, any scrapped assemblies are counted with the completed units. Note that for material requirements, expense items are ignored.
Parameters:
==========
Variance Amount Threshold: maximum absolute WIP variance or current job balance that is allowed for jobs you wish to close (required).
Variance Percent… full description | Cost Management Enginatics | |
| 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 other details. Including any profit in inventory or PII amounts. But unlike the more recent CAC WIP Manufacturing Variance and CAC WIP Material Usage Variance reports, this report uses the latest material issue quantities as stored on the WIP job definition, even if you run it for a prior period. It does not rollback the component issue quantities for a prior accounting period.
Parameters:
==========
Period Name: the accounting period… full description | Cost Management Enginatics | |
| 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 - Standard Costing report.
If the job is open the Report Type column displays "Valuation", as this WIP job and potential material usage variance is still in your WIP inventory balances. If the job has been closed during the reporting period, the Report Type column displays "Variance", as this WIP job was written off on a WIP Job Close Variance transaction. You can report prior periods and this report will automatically adjust the… full description | Cost Management Enginatics, R12 only | |
| 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 transactions. However, WIP cost adjustments for Assembly Scrap is not included. The Cost Type (Old) defaults to your Costing Method Cost Type (Average, Standard, etc.); the Currency Conversion Dates default to the latest open or closed accounting period; and the To Currency Code and the Organization Code default from the organization code set for this session. And if you choose Yes for "Include All WIP Jobs" all WIP jobs will be… full description | Cost Management Enginatics | |
| 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 applied resources. This report replicates the Resource Section for the Oracle Discrete Job Value Report - Standard Costing.
If you leave the Cost Type parameter blank the report uses either your Costing Method Cost Type (Standard) or your Costing Method "Avg Rates" Cost Type (Average, FIFO, LIFO) for your resource rates. If the WIP job is open the Report Type column displays "Valuation", as this WIP job and potential material usage… full description | Cost Management Enginatics | |
| 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 material you can also compare with two cost types, as well as limit the report to only assemblies and component items with a zero item cost.
/* +=============================================================================+
-- | Copyright 2013 - 2019 Douglas Volz Consulting, Inc. |
-- | All rights reserved. |
-- | Permission to use this code is granted provided… full description | Cost Management Enginatics | |
| 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 on the item master creation date.
Parameters:
Creation Date From: starting item master creation date (required).
Creation Date To: ending item master creation date (required).
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).S
Item Number: enter the specific item number(s) you wish to… full description | Cost Management Enginatics | |
| CST AP and PO Accrual Reconciliation | Imported from Concurrent Program
Application: Bills of Material
Source: AP and PO Accrual Reconciliation Report
Short Name: CSTACRAP | Cost Management Enginatics, R12 only | |
| CST COGS Revenue Matching | Imported from Concurrent Program
Application: Bills of Material
Source: COGS Revenue Matching Report
Short Name: CSTRCMRX
The COGS/Revenue Matching Report displays earned and unearned (deferred) revenue, and cost of goods sold amounts for sales orders issues specified in the report's run-time parameters.
The report displays shipped sales order and associated sales order lines and shows the accounts where the earned and deferred COGS were charged.
The report is based on the Revenue and COGS Matching functionality delivered in Oracle EBS R12. Please refer to the following documentation… full description | Cost Management Enginatics, R12 only | |
| CST Cost Groups | Master data report that lists all item cost groups along with their corresponding GL posting codes and descriptions. | Cost Management Enginatics | |
| CST Detailed Item Cost | Detail report that lists each item and the associated costs to be recognized as part of total unit cost of producing the item. | Cost Management Enginatics | |
| CST Historical WIP Standard Cost Adjustment | WIP standard cost adjustment details recorded by a completed standard cost update, based on Oracle's Historical WIP Standard Cost Adjustment Report (CSTCUSJA).
The report shows one line per WIP discrete job, transaction type, item or resource operation and cost element, with the old and new unit costs, adjustment quantity and adjustment value, and the WIP job's valuation and standard cost adjustment accounts.
The Cost Update parameter offers the completed standard cost updates of the selected organization that saved their adjustment details, matching Oracle's View Cost Update History form.… full description | Cost Management Enginatics | |
| CST Inventory Value - Multi-Organization (Item Costs) | Report: CST Inventory Value - Multi-Organization (Item Costs)
Description:
The Inventory Value Report can be used to report Inventory Value by
- Elemental Item Cost level
- Quantity Type (Onhand, Intransit, Receiving)
The report can be used to analyze inventory value by Ledger, Operating Unit, Organization, Subinventory, Item Category, Cost Group
The report corresponds to the following standard Oracle Reports
- Elemental Inventory Value Report
- All Inventories Value Report
The report can be run across multiple Inventory Organizations
Templates are provided that match the existing… full description | Cost Management Enginatics | |
| CST Inventory Value Report - by Subinventory (Item Cost) | Imported Oracle standard inventory value subinventory report by item cost
Source: Inventory Value Report - by Subinventory (XML)
Short Name: CSTRINVR_XML
DB package: BOM_CSTRINVR_XMLP_PKG | Cost Management Enginatics, R12 only | |
| CST Item Cost Reports | Flexible costing set of reports - analyze item costs for any cost type.
Choose from the following options:
Choose one of the following options:
Activity Summary - Report item costs by activity.
Activity by Department - Report item costs by activity and department.
Activity by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter.
Activity by Operation - Report item costs by activity and operation sequence number.
Element - Report item costs by cost element and cost level.
Element by Activity - Report item costs by cost element and activity.
Element by… full description | Cost Management Enginatics | |
| CST Miscellaneous Accrual Reconciliation | Imported from Concurrent Program
Application: Bills of Material
Source: Miscellaneous Accrual Reconciliation Report
Short Name: CSTACRMI
DB package: | Cost Management Enginatics, R12 only | |
| CST Period Close Subinventory Value | Summary report that lists selected operating units with corresponding sub inventory code and Inventory value on a historic basis. | Cost Management Enginatics | |
| CST Period Close Subinventory Value Summary | Summary report that lists selected ledgers and operating units with corresponding sub inventory code and Inventory value.With Ledger export capability. | Cost Management Enginatics | |
| CST Periodic Inventory Value | Imported from BI Publisher
Description: Periodic Inventory Value Report
Application: Bills of Material
Source: Periodic Inventory Value Report (XML)
Short Name: CSTRPICR_XML
DB package: BOM_CSTRPICR_XMLP_PKG | Cost Management Enginatics, R12 only | |
No reports match. Try fewer words or categories.
Also found in SQL, tables and columns
These reports don't mention the search in their name or description, but their SQL does.
Searching SQL…