Blitz Report™ Library
837 reports
| Description | Download | ||
|---|---|---|---|
| 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 | 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 | 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. | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Enginatics | |
| CE Bank Account Balances | Application: Cash Management
Description: Bank Accounts - Balances Report
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Bank Account Balances OAF Page
- Bank Account Balance Range Day Report
- Bank Account Balance Single Date Report
- Bank Account Balance Actual vs Projected Report
Single (As Of) Date Report
- Specify the required Date in the As Of Date parameter
- Specify Yes in the 'Bring Forward Prior Balances' if you want to roll the most recent prior balance entries forward if a balance does not exist on the specified As Of Date
- Specify No in the… full description | Enginatics, R12 only | |
| CE Bank Branches | This Report is the repository of all bank branches covering both internal and external bank accounts and will list the bank branches along with an indication of usage:
-Internal
-Supplier
-Customer | Enginatics, R12 only | |
| CE Bank Statement Import Execution | Application: Cash Management
Source: Bank Statement Import Execution Report
Short Name: CEIMPERR
DB package: CE_CEXINERR_XMLP_PKG | BI Publisher, Enginatics, R12 only | |
| CE Bank Statement and Reconciliation | Application: Cash Management
Description: Bank Statements - Bank Statement Details and Reconciliation
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Bank Statements and Reconciliation Form
Applicable Templates:
Pivot: Bank Statement by Transaction Type
Bank Statement Detail
Bank Statement Detail with Reconciled Trxs
- Bank Statement Summary Report
Applicable Templates:
Pivot: Bank Statement by Transaction Type
Bank Statement Summary
- Bank Statement Detail Report
Applicable Templates:
Pivot: Bank Statement by Transaction Type
Bank… full description | Enginatics, R12 only | |
| CE Bank Transaction Codes Listing | Imported from BI Publisher
Description: Bank Transaction Codes
Application: Cash Management
Source: Bank Transaction Codes Listing
Short Name: CEXTRXCD
DB package: CE_CEXTRXCD_XMLP_PKG | Enginatics, R12 only | |
| CE General Ledger Cash Account Usage | Application: Cash Management
Description: Cash Account Usage
This report details the General Ledger Cash Accounts assigned to Bank Accounts, and their usage.
The following templates are available:
Pivot: Bank Accounts, Assigned Cash Accounts - Pivot by Bank Account, Cash Account showing cash account usage within each bank account.
Pivot: Cash Account, Assigned Bank Accounts - Pivot by Cash Account, Bank Account, showing cash account usage within each bank account. | Enginatics, R12 only | |
| CE General Ledger Reconciliation | Application: Cash Management
Description: Bank Statements - General Ledger Reconciliation
Provides equivalent functionality to the following standard Oracle Forms/Reports
- General Ledger Reconciliation Report
Applicable Templates:
Pivot: Reconciliation Summary
Source: General Ledger Reconciliation Report
Short Name: CEXRECRE
DB package: CE_CEXRECRE_XMLP_PKG | Enginatics, R12 only | |
| CRP Available Resources | Detail report showing the date range availability of each resource, as well as daily hours and unit capacity of the resource. | Enginatics | |
| CRP Resource Plan | Detail report for each resource code, showing the resource date, hours, work start and end date, type of work scheduled, and the quantity scheduled. | Enginatics | |
| CS Service Requests | Service requests with customer, product, owner, status and response and resolution times, one row per request.
Response and resolution hours are measured from the reported date to the responded and resolved dates. A request is overdue when it was responded to or resolved after its respond by or resolve by date. Without a responded or resolved date, its close date is used, or the current date while it is open.
Detail Level adds the request's tasks or notes, one row per task or note; private notes are listed only for the user who entered them. | Enginatics | |
| CSI Counter Readings | Counter and meter readings, one row per reading, with the item instance or maintainable asset and the service contract the counter belongs to.
Reading Change is the net reading minus the net reading of the counter's previous enabled reading, so it shows the usage since the last reading, also across resets and adjustments. It is blank for the first reading of a counter.
Work Order is the maintenance work order on whose completion the reading was recorded. Contract Number lists the contract of a counter attached to a contract line, or the contracts whose usage lines cover the counter. | Enginatics, R12 only | |
| CSI Customer Products Summary | Imported Oracle standard Installed Base Customer Products Summary report
Source: CSI: Customer Products Summary Report (XML)
Short Name: CSICPREP_XML
DB package: CSI_CSICPREP_XMLP_PKG
Owner Party is the owner of the instance, also for internal instances without an owner account. Parent Instance is the instance this one is an active component of.
Contract Number lists the service contracts with a covered product line in status Active for the instance. Contract Coverage restricts the report to instances with or without such coverage.
Show Parties adds one row per party and account role of… full description | Enginatics | |
| CSI Installed Base Extended Attributes Summary | Master data report of extended Installed Base attribute levels and names | Enginatics | |
| CSI Installed Base Summary by Organization | Count of installed base products by hierarchy type (parent / child), instance usage and related organizations, such as sold from and owner operating unit, last validation and master inventory organization | 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 | 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 | Enginatics, R12 only | |
| CST Cost Groups | Master data report that lists all item cost groups along with their corresponding GL posting codes and descriptions. | Enginatics | |
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…