Blitz Report™ Library

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

175 reports

DescriptionDownload
CST Subinventory Account Value - Multi-Org
Report: CST Subinventory Account Value - Multi-Org Description: Shows onhand inventory value broken down by GL account and cost element across multiple organizations. For each subinventory, the report unpivots inventory value into separate rows per cost element (Material, Material Overhead, Resource, Outside Processing, Overhead), each showing the GL account where that cost element is recorded. Asset subinventories show 5 rows per item (one per cost element). Expense subinventories show 1 row per item with total cost under the expense account. Account determination follows Oracle standard…
full description
Cost Management Enginatics, R12 only XLS XML
CST Supply Chain Indented Bills of Material Cost
This report is based on the (static) Oracle Supply Chain Indented Bills of Material Cost Report and merely sums up the available information from the Cost Type. It does not do a Cost Rollup and as a result, the "Extended Cost" column might not add up to the total item cost for the assembly especially if changes have been made to the bills of material, routing or item costs, since the last cost rollup. If this is the case, run a Supply Chain Cost Rollup in Pending or some other cost type (such as Current) for reporting purposes, to synchronize the cost information and then use this report,…
full description
Cost Management BI Publisher, Enginatics, R12 only XLS XML
CST Uninvoiced Receipts
Application: Bills of Material Description: Uninvoiced Receipts Report Templates: Select a template to show Accruals summarized by - PO/Release Distributions (Default) - PO/Release Shipments - PO/Release Lines Each template includes a Pivot summarizing the accruals by Accrual Account and the Pivot/Sort Parameter Value (Vendor, Category, PO/Release Number) Source: Uninvoiced Receipts Report Short Name: CSTACREP DB Package: XXEN_CST
Cost Management Enginatics, R12 only XLS XML
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, Creation Date, Created By and Last Updated By. The A/P Accrual Load Program uses these accounts to find the Payables, Receiving and Inventory accounting accrual entries for the A/P Accrual Load results. Parameters: =========== Operating Unit: enter the specific operating unit(s) you wish to report (optional). Ledger: enter the specific ledger(s) you wish to report (optional). /*…
full description
Cost Management Enginatics, R12 only XML
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 and line number. If run in Detail Mode, shows inventory receipts and payables invoices on separate lines with detailed information, if run in Summary Mode, the sales order line is summarized into one row. Parameters: =========== Report Mode: you can get a summary by sales order and line or a detailed report, enter Detail or Summary (mandatory). Transaction Date from: enter the IR/ISO beginning transaction date you wish to report…
full description
Cost Management Enginatics, R12 only XML
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 and Last Updated By. Parameters: =========== Beginning Creation Date: enter the starting creation date to report, based on the operating unit for your session's inventory organization (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). /* +=============================================================================+ -- |…
full description
Cost Management Enginatics, R12 only XML
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 organization. Use this report for summary reconciliation purposes, to justify the "at time of receipt" accrual balances for your inventory and expense A/P accrual accounts. Parameters: =========== Transaction Date From: enter the accrual starting transaction date you wish to report. Defaults to the earliest date found (mandatory). Transaction Date To: enter the accrual ending transaction date you wish to report. Defaults to the latest…
full description
Cost Management Enginatics, R12 only XML
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 your Cost Type. You automatically save off your month-end quantities and values when you close the inventory accounting period. Parameters: ========== Period Name (Closed): the closed inventory accounting period you wish to report (mandatory). Cost Type: enter a Cost Type to compare against the stored month-end items, quantities and values (mandatory). Item Number: enter the specific item number(s) you wish to report…
full description
Cost Management Enginatics XML
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 item is rolled up, as opposed to the item status. Parameters: =========== Cost Type: enter the cost type to report (mandatory). Defaults to your Costing Method cost type. Inactive Item Status: enter the item statuses which should not be rolled up (mandatory). Defaults to 'Inactive'. 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,…
full description
Cost Management Enginatics XML
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 you enter a cost type this report uses the item costs from the cost type; if you leave the cost type blank it uses the item costs from the month-end snapshot. In either case this report uses the month-end quantities, based on the entered period name, calendar code and period code. As these quantities come from the month-end snapshot, this also also allows you to specify the lot number and locator (row/rack/bin) for your onhand…
full description
Cost Management Enginatics, R12 only XML
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 quantities from the month-end snapshot; if you leave the period name blank it uses the real-time quantities. The Cost Type (Old) defaults to your Costing Method Cost Type (Average, Standard, etc.); and the To Currency Code and the Organization Code default from the organization code set for this session. Unlike the CAC Inventory Pending Cost Adjustment report, this version does not display any cost differences due to changes in foreign…
full description
Cost Management Enginatics XML
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: =========== Cost Type: enter the cost type(s) you wish to report (mandatory). Make or Buy: enter Buy, Make or leave blank to get all items (optional). Based on Rollup: enter Yes to get the rolled up items, No to get the non-rolled-up items (optional). Basis Type: enter the basis type you wish to report, such as Item, Lot, Res Units, Res Value, or Ttl Value (optional). Item Status to Exclude: enter the item status you wish to exclude,…
full description
Cost Management Enginatics XML
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, before updating to your new standard costs for the following year. Including various item controls, last cost update submission, last standard item cost and current (Frozen) item cost. And whether or not BOMs, routings or (inventory organization) sourcing rules exist for the item as of the specified cost update date. And as allowed with no onhand or intransit quantities, if an item cost has been directly entered into the Frozen Cost Type,…
full description
Cost Management Enginatics XML
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 job and potential variances are 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 the report will automatically adjust the assembly completion, assembly scrap, component issue and resource quantities to reflect the reported accounting period,…
full description
Cost Management Enginatics XML
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 transaction lot number. And if processed by Create Accounting, the Create Accounting column shows "Yes". Parameters: =========== Transaction Date From: enter the starting transaction date (mandatory). Transaction Date To: enter the ending transaction date (mandatory). Show Lot Number: enter Yes to see transactions by lot number, enter No to exclude lot information (mandatory). Account Alias: enter the account alias to report…
full description
Cost Management Enginatics, R12 only XML
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 and current (Frozen) item cost, by cost update date. And whether or not BOMs, routings or (inventory organization) sourcing rules exist for the item. As allowed with no onhand or intransit quantities, if an item cost has been directly entered into the Frozen Cost Type, the Cost Update Request Id, Cost Update Description, Cost Update Status and related cost update submission columns will be blank or empty. Parameters: Cost Update…
full description
Cost Management Enginatics XML
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 accounting period or batches which were closed during the monthly inventory accounting period. If you enter a cost type this report uses the item costs from the cost type; if you leave the cost type blank it uses the item costs from the month-end item costs. Parameters: ========== Period Name: enter the monthly inventory accounting period you wish to report (mandatory). Cost Type: enter a Cost Type to value the quantities using the Cost…
full description
Cost Management Enginatics, R12 only XML
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 Indicator (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc), then by the Cost Component Class. With the "Other Costs" column summing up any other non-displayed Cost Component Classes. For a different selection of Cost Component Classes, you may override any of the defaulted Cost Component Classes. If you have fewer than thirty Cost Components the report automatically displays "Not Available", for the succeeding Cost Component…
full description
Cost Management Enginatics, R12 only XML
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 valuation accounts come from the cumulative WIP Valuation accounting entries, as processed by Create Accounting. Parameters: =========== Period Name: the inventory accounting period you wish to report (mandatory). Include Lab Batches: enter Yes to include laboratory batches. Enter No to exclude them. Defaults to No (mandatory). Show Batch Details: enter Yes to display the formula, routing and recipe numbers and versions. Defaults to…
full description
Cost Management Enginatics, R12 only XML
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 or closed accounting periods. If run for a prior period the report automatically rolls back the quantities and values to the prior period's period end date. if run for a current period, the report shows the real-time quantities and values. This report displays both the receiving valuation account as well as the offset (expense or CapEx) account. Parameters: Period Name: the accounting period you wish to report (mandatory). Category…
full description
Cost Management Enginatics XML
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 report when you need to make manual journal entry corrections to your COGS entries, due to incorrect item costs. In addition to reporting the normal COGS entries for the COGS Recognition, Sales Order Issue, RMA Receipt and RMA Return transactions, you can also report user-defined material transactions such as Account Issues/Receipts, Miscellaneous Issues/Receipts and Account Alias transactions which could represent COGS entries from…
full description
Cost Management Enginatics, R12 only XML
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. Parameters: Cost Update Date From: starting cost update date, based on standard cost submission history (required). Cost Update Date To: ending cost update date, based on standard cost submission history (required). From Cost Type: enter the cost type implemented by the Standard Cost Update into the Frozen costs (optional). Organization Code: enter the specific inventory organization(s) you wish to report (optional). Operating Unit:…
full description
Cost Management Enginatics XML
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, job close variance and standard cost update transactions. With WIP class, job status, name and other details. This report shows both WIP jobs which were open during the accounting period as well as jobs closed during the accounting period. If the stored WIP period balances agree to the period WIP accounting activity, the "Difference" columns have a zero amount. //*…
full description
Cost Management Enginatics XML
CST Department Overhead Rate Upload
CST Department Overhead Rate Upload =================================== This upload can be used to - Upload new Department Overhead Rates - Download the current Department Overhead Rates for a Cost Type, update, and upload the amended rates - Download the current Department Overhead Rates from a Source Cost Type and upload them to a different Target Cost Type - Delete existing Department Overhead Rates Department Overhead Rates associate Overhead sub-elements with Departments and specify the rate or amount charged, per basis (Item, Lot, Resource Units, or Resource Value). The rates are…
full description
Cost Management Enginatics, R12 only, Upload XML
CST Item Average Cost Upload
CST Item Average Cost Upload ============================ This upload supports the uploading of item average costs for organizations using the Average Costing Method. The upload delivers equivalent functionality to the Average Cost Update form in Oracle EBS (At this time the upload does not support value change quantity adjustments). Upload Mode: Use the “Create” upload mode to generate an empty excel into which you can paste the average cost updates to be uploaded. Use the “Create, Update” upload mode if you wish to download the current average costs for a specified set of items into…
full description
Cost Management Enginatics, Upload XML
CST Item Standard Cost Upload
CST Item Standard Cost Upload ============================= This upload can be used to - Upload New Item Costs - Download the current Item Costs, Update, and Upload the amended item costs for a specified Cost Type - Download the current item Costs from one Source cost type, update, and upload the amended item costs to a different Target Cost Type NOTE: You can only upload costs to cost types that are not flagged as frozen and are flagged as updateable. This upload is used for updating cost types using the standard costing method. Optionally, the upload can perform a Cost Rollup after the…
full description
Cost Management Enginatics, R12 only, Upload XML
CST Resource Overhead Association Upload
CST Resource Overhead Association Upload ======================================== This upload can be used to - Upload new Resource Overhead Associations - Download the current Resource Overhead Associations for a Cost Type and upload them to a different Target Cost Type - Update the descriptive flexfield attributes of existing associations by re-uploading them in 'Remove and replace' mode - Delete existing Resource Overhead Associations Resource Overhead Associations link Resource or Outside Processing sub-elements to the Overhead or Material Overhead sub-elements they absorb. The…
full description
Cost Management Enginatics, R12 only, Upload XML
CST Resource Rate Upload
CST Resource Rate Upload ======================== This upload can be used to - Upload new Resource Rates - Download the current Resource Rates for a Cost Type, update, and upload the amended rates - Download the current Resource Rates from a Source Cost Type and upload them to a different Target Cost Type - Delete existing Resource Rates Resource Rates apply to rate based Resource and Outside Processing sub-elements (sub-elements whose charge basis is not currency based). The rates are imported via the Oracle Cost Import Process. NOTE: You can only upload rates to cost types that are not…
full description
Cost Management Enginatics, R12 only, Upload XML
CST All Inventories Value
Imported from BI Publisher Description: All Inventories Value Report Application: Bills of Material Source: All Inventories Value Report (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG
Cost Management BI Publisher XLS XML
CST Intransit Value
Imported from BI Publisher Description: Intransit Value Report Application: Bills of Material Source: Intransit Value Report (XML) Short Name: CSTRITVR_XML DB package: BOM_CSTRITVR_XMLP_PKG
Cost Management BI Publisher XLS XML
CST Inventory Subledger
Imported from BI Publisher Description: Inventory Subledger Report Application: Bills of Material Source: Inventory Subledger Report (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG
Cost Management BI Publisher XLS XML
CST Overhead
Imported from BI Publisher Description: Overhead Report Application: Bills of Material Source: Overhead Report (XML) Short Name: CSTROVHD_XML DB package: BOM_CSTROVHD_XMLP_PKG
Cost Management BI Publisher XLS XML
CST Shipping Transaction Summary
Imported from BI Publisher Description: Shipping Transaction Summary Report Application: Bills of Material Source: Shipping Transaction Summary Report (XML) Short Name: CSTRSTSR_XML DB package: BOM_CSTRSTSR_XMLP_PKG
Cost Management BI Publisher XLS XML
CAC Inventory and Intransit Value (Period-End) - Diagnostic Report
Diagnostic script for CAC Inventory and Intransit Value (Period-End) report
Cost Management XML
CST Activity Cause
Imported from BI Publisher Description: EAM Activity Cause Report Application: Bills of Material Source: Activity Cause Report (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG
Cost Management BI Publisher XML
CST All Inventories Value Report - by Cost Group
Imported from BI Publisher Description: All Inventories Value Report - by Cost Group Application: Bills of Material Source: All Inventories Value Report - by Cost Group (XML) Short Name: CSTRAIVA_XML DB package: BOM_CSTRAIVA_XMLP_PKG
Cost Management BI Publisher XML
CST Cost Type Comparison
Imported from BI Publisher Description: Cost Type Comparison Report Application: Bills of Material Source: Cost Type Comparison Report (XML) Short Name: CSTRCTCRG_XML DB package: BOM_CSTRCTCR_XMLP_PKG
Cost Management BI Publisher XML
CST Create Accounting - Cost Management
Imported from BI Publisher Description: Create and view accounting for Inventory, WIP, and Receiving Application: Bills of Material Source: Create Accounting - Cost Management Short Name: CSTCRACC DB package: XLA_CREATE_ACCT_RPT_PVT
Cost Management BI Publisher XML
CST Create Accounting - Receiving
Imported from BI Publisher Description: Create and view accounting for Receiving Application: Bills of Material Source: Create Accounting - Receiving Short Name: CSTCRACCRCV DB package: XLA_CREATE_ACCT_RPT_PVT
Cost Management BI Publisher XML
CST Department Actual Cost
Imported from BI Publisher Description: EAM Department Actual Cost Report Application: Bills of Material Source: Department Actual Cost Report (XML) Short Name: CSTRDACR_XML DB package: BOM_CSTRDACR_XMLP_PKG
Cost Management BI Publisher XML
CST Discrete Job Value Report - Average/FIFO/LIFO Costing
Imported from BI Publisher Description: WIP Discrete Job Value Report - Average/FIFO/LIFO Costing Application: Bills of Material Source: Discrete Job Value Report - Average/FIFO/LIFO Costing (XML) Short Name: CSTRDJVA_XML DB package: BOM_CSTRDJVA_XMLP_PKG
Cost Management BI Publisher XML
CST Elemental Cost
Imported from BI Publisher Description: Elemental Cost Report Application: Bills of Material Source: Elemental Cost Report (XML) Short Name: CSTRELCRG_XML DB package: BOM_CSTRELCR_XMLP_PKG
Cost Management BI Publisher XML
CST Elemental Inventory Value Report - by Cost Group
Imported from BI Publisher Description: Elemental Inventory Value Report - by Cost Group Application: Bills of Material Source: Elemental Inventory Value Report - by Cost Group (XML) Short Name: CSTREIVW_XML DB package: BOM_CSTREIVW_XMLP_PKG
Cost Management BI Publisher XML
CST Elemental Inventory Value Report - by Subinventory
Imported from BI Publisher Description: Elemental Inventory Value Report Application: Bills of Material Source: Elemental Inventory Value Report - by Subinventory (XML) Short Name: CSTREIVR_XML DB package: BOM_CSTREIVR_XMLP_PKG
Cost Management BI Publisher XML
CST Historical Intransit Standard Cost Adjustment
Application: Bills of Material Source: Historical Intransit Standard Cost Adjustment Report (XML) Short Name: CSTCUSTA_XML DB package: BOM_CSTRUSTA_XMLP_PKG
Cost Management BI Publisher XML
CST Historical Inventory Standard Cost Adjustment
Application: Bills of Material Source: Historical Inventory Standard Cost Adjustment Report (XML) Short Name: CSTCUSIA_XML DB package: BOM_CSTRUSIA_XMLP_PKG
Cost Management BI Publisher XML
CST Historical Inventory Standard Cost Adjustment Report - Warehouse Management
Application: Bills of Material Source: Historical Inventory Standard Cost Adjustment Report - Warehouse Management (XML) Short Name: CSTCUSIW_XML DB package: BOM_CSTRUSIW_XMLP_PKG
Cost Management BI Publisher XML
CST Inventory Master Book
Imported from BI Publisher Description: Inventory master Book Report Application: Bills of Material Source: Inventory Master Book Report (XML) Short Name: CSTGMSBK_XML DB package: CST_MGD_MSTR_BOOK_RPT
Cost Management BI Publisher XML
CST Inventory Value Report - by Cost Group
Imported from BI Publisher Description: Inventory Value Report - by Cost Group Application: Bills of Material Source: Inventory Value Report - by Cost Group (XML) Short Name: CSTRIRVW_XML DB package: BOM_CSTRIRVW_XMLP_PKG
Cost Management BI Publisher XML
CST Inventory Value Report - by Cost Group (1)
Imported from BI Publisher Description: Inventory Value Report - by Cost Group Application: Bills of Material Source: Inventory Value Report - by Cost Group (XML) Short Name: CSTRIRVW_XML DB package: BOM_CSTRIRVW_XMLP_PKG
Cost Management BI Publisher XML