Blitz Report™ Library
Module GL 143 AP 143 AR 123 FA 138 CE 25 PO 116 INV 129 OM 89 MFG 214 COST 175 PA 131 HR 182 PAY 151 SYS 162
3,151 reports
| Description | Download | ||
|---|---|---|---|
| GL effective vs accounting vs period start and end date comparison | For developers to understand the GL data: Shows the relationship between effective, accounting and period start and end dates by counting how many records exist where the effective date is before or after the accounting date. | General Ledger Enginatics, R12 only |   |
| GMI Cycle Count Forms | Imported Oracle standard Cycle Count Forms Report of Oracle OPM PI report
Source: Cycle Count Forms (XML)
Short Name: PIR05_XML
DB package: GMI_PIR05_XMLP_PKG | Manufacturing Enginatics | |
| IBY Payment Process Request Details | Payment manager process request details including statuses, paid or rejected documents, amounts and rejection eror messages | Payables Enginatics, R12 only | |
| IEX Dunning History | Dunning letters sent by Advanced Collections, one row per dunning, with the customer, account or bill-to site dunned, the dunning plan, the letter template, the delivery method and the amount due at the time of the dunning.
The customer, account and bill-to site are derived from the dunning level: a customer level dunning has no account, and a delinquency level dunning shows the delinquent transaction with its due date and the days past due on the dunning date.
Collector is the collector of the bill-to site profile, else of the account profile, else of the party profile. | Enginatics, R12 only | |
| INL Duty and Tariff Analysis | Duty, other charges and taxes per landed cost shipment line, with tariff code, country of origin and supplier, to analyse duty rates and the landed cost uplift on the item value.
The charge types counted as duty are selected in the Duty Charge Type parameter, all other charges are Other Charges. Amounts are the current landed cost allocations in functional currency, Duty Estimated the first calculation. LCM allocates a charge to the shipment lines by the charge type's allocation basis, so an actual duty invoice matched to the shipment is spread over its lines, and the duty rate per line… full description | Enginatics, R12 only | |
| INL Landed Cost Adjustments | Landed cost adjustments processed by Cost Management, with the receiving accounting they generated.
One row per accounting line of each adjustment: the adjustment of the receipt (Receiving Inspection against Landed Cost Absorption) and, for delivered quantities, the adjustment of the delivery (Purchase Price Variance in a standard cost organization, otherwise the inventory or expense account). Adjustment Value, the unit landed cost change times the receipt quantity, is shown on the first row of each adjustment only, so that it can be summed.
Adjustments still pending or in error in the… full description | Enginatics, R12 only | |
| INL Landed Cost Estimated vs Actual | Landed cost per Landed Cost Management shipment line and cost component (item price, each charge type and each tax), comparing the estimate with the current landed cost.
Estimated Amount is the allocation of the shipment's first landed cost calculation (adjustment 0) and Current Amount the allocation of its latest adjustment, both in functional currency. A component without a matched AP invoice still carries its estimate; an estimate changed in the Shipment Workbench after submission shows as a variance without a match.
LCM allocates a charge to the shipment lines by the charge type's… full description | Enginatics, R12 only | |
| INL Landed Unit Cost Trend | Unit landed cost per item over its landed cost shipments, broken down into item cost, charges and taxes, with the change against the item's previous shipment in the same organization.
Unit amounts are the current landed cost allocations in functional currency divided by the shipment line's primary quantity, Estimated Unit Landed Cost the first calculation. The previous shipment is taken from the shipments within the parameter selection. | Enginatics, R12 only | |
| INL Pending Actual Charges | Estimated landed cost charges per shipment line, charge type and charging party that no AP invoice has been matched to yet, aged by shipment date at the As of Date. It lists the freight, duty and brokerage invoices still to be received and the accrual exposure they carry.
Estimated Amount is the current estimate in functional currency, including estimate changes made after the shipment was submitted, and Original Estimated Amount the first calculation. A charge type stops being pending on a receipt line once any invoice of that type is matched to it, whatever the amount.
A charge invoice… full description | Enginatics, R12 only | |
| INL Tariff Exposure on Open POs | Open quantity of approved PO shipments enabled for Landed Cost Management, with simulated and historical duty, to project the tariff cost of goods not received yet.
Simulated Duty comes from the purchase order's latest landed cost simulation, scaled to the open quantity. Historical Duty Rate is the duty to item value ratio of the shipments of the same item, organization and country of origin since History Date From. Projected Duty is the simulated duty, else the open value at the historical rate.
Additional Tariff Percent applies a what-if tariff to the open value, for example a newly… full description | Enginatics, R12 only | |
| INV ABC assignments | Imported from BI Publisher
Description: ABC assignments report
Application: Inventory
Source: ABC assignments report (XML)
Short Name: INVARAAS_XML
DB package: INV_INVARAAS_XMLP_PKG | Inventory Enginatics | |
| INV Aging | The Inventory Aging Report indicates how long an inventory item has been in a FIFO warehouse. You can define bucket days to identify the period from when an item is in the inventory.
NOTES:
This report will only run for clients running R12.2.8 or later.
This report requires the profile 'INV: FIFO for Original Receipt Date' to be set to Yes in order to return data.
For customers encountering an error running this Blitz report, please first verify the Oracle standard report Inventory Aging Report(XML) can be run in the same instance.
If the standard Oracle report does not complete… full description | Inventory Enginatics, R12 only | |
| INV Cycle count entries and adjustments | Imported Oracle standard Cycle count entries and adjustments report
Source: Cycle count entries and adjustments report (XML)
Short Name: INVARCTA_XML
DB package: INV_INVARCTA_XMLP_PKG | Inventory Enginatics | |
| INV Cycle count hit/miss analysis | Imported Oracle standard Cycle count hit/miss analysis report
Source: Cycle count hit/miss analysis (XML)
Short Name: INVARHMA_XML
DB package: INV_INVARHMA_XMLP_PKG | Inventory Enginatics | |
| INV Default Category Sets | Master data report that lists Inventory functional areas and their default category sets | Inventory Enginatics | |
| INV Intercompany Invoice Reconciliation | Intercompany invoice reconciliation for inventory transactions, including shipping and receiving organizations, ordered, transacted and invoiced quantities, amounts and possible discrepancies.
It also includes all intercompany Receivables (AR) and Payables (AP) invoice details. Optionally includes the Inventory and Intercompany AP SLA Accounting | Inventory Enginatics | |
| INV Item Attribute Master/Child Conflicts | Identifies existing Item Attribute Master/Child attribute value conflicts for Item Attributes controlled at the Master Organization Level.
These errors show as a "Master - Child Conflict in one of these Attributes: ... [MASTER_CHILD_nn]" error during Item Upload
Item Attributes with Master/Child conflicts are identified in the report by having a value in the report displayed as M:[master Org Value] C:[Child Org Value]
Item Attributes with no Master/Child conflicts will have a null value in the report. | Inventory Enginatics | |
| INV Item Category Sets | Inventory Enginatics | | |
| INV Item Default Transaction Subinventories | Master data report of inventory item relationships including the type of relationship between the item and the subinventory. | Inventory Enginatics | |
| INV Item Demand History | Imported from BI Publisher
Description: Item demand history report
Application: Inventory
Source: Item demand history report (XML)
Short Name: INVPRFDH_XML
DB package: INV_INVPRFDH_XMLP_PKG | Inventory Enginatics | |
| INV Item Import Performance | Analytical report by item to predict performance of inventory item load background processes. If the number of items processed per second is decreasing with increasing total items processed, then the interface SQLs are most likely using a wrong nonselective index and should be corrected. | Inventory Enginatics | |
| INV Item Relationships | Master listing for Inventory item relationships | Inventory Enginatics | |
| INV Item Reservations | Imported from BI Publisher
Description: Item reservations report
Application: Inventory
Source: Item reservations report (XML)
Short Name: INVDRRSV_XML
DB package: INV_INVDRRSV_XMLP_PKG | Inventory Enginatics | |
| INV Item Statuses | Master data report of inventory items with the various status attributes, such as: is BOM allowed, Build in WIP, customer orders enabled, internal orders enabled and Invoice enabled, etc. | Inventory Enginatics | |
| INV Item Supply/Demand | Inventory Item Supply/Demand data as per the standard Inventory Item Supply/Demand form | Inventory Enginatics | |
| INV Item Templates | Inventory item templates and their item attribute values | Inventory Enginatics | |
| INV Items | Master data report that lists item master attributes such as item type, UOM, status, serial control, account numbers and various other attributes | Inventory Enginatics | |
| INV Kanban Cards | Kanban cards with their pull sequence, one row per card, including card type, card status, supply status and card kanban size. Replenishment Cycles and Last Activity Date are derived from the card activity history. Only production pull sequences are listed, not those of kanban plans.
Pull Sequences Only lists one row per pull sequence without the cards. Show Activity adds one row per card activity (supply status change), with the document that replenished the card. | Inventory Enginatics | |
| INV Lot Transaction Register | Imported from BI Publisher
Description: Lot transaction register
Application: Inventory
Source: Lot transaction register (XML)
Short Name: INVTRLNT_XML
DB package: INV_INVTRLNT_XMLP_PKG | Inventory Enginatics, R12 only | |
| INV Material Account Distribution Detail | Description: Material account distribution detail
Application: Inventory
Source: Material account distribution detail (XML)
Short Name: INVTRDST_XML | Inventory Enginatics, R12 only | |
| INV Material Movements | Detailed report of On Hand Quantity with stock movements by Item , Org Code .
Material Movements involve cumulative buckets for stock/in/mvmt and month wise non cumulative buckets for stock out | Inventory Enginatics | |
| INV Material Transactions | Detail report of Inventory transactions with item, primary qty, secondary qty, transaction type, transaction ID and total transaction qty | Inventory Enginatics | |
| INV Material Transactions Summary | Summary report of Inventory item movement including transaction type, source type, and transaction ID’s. | Inventory Enginatics | |
| INV Move Orders | Move order lines of all move order types (requisition, replenishment, pick wave, manufacturing component pick, put away), one row per line, with requested, allocated (detailed), delivered, unallocated and open quantity.
Unallocated and open quantity are shown for open lines only. Source shows the sales order, WIP job, purchase order or internal requisition the line was created for; Reference Source and Kanban Card identify replenishment move orders created by kanban, min-max or replenishment counts.
Show Allocations lists the pending allocations (subinventory, locator and lot) of each line,… full description | Inventory Enginatics | |
| INV Onhand Quantities | Detail report inventory item quantities by org, sub inventory, location, unit of measure, quantity on hand, quantity reserved, quantity unpacked, lot number, lot expiration, planning information, serial control, availability type, date received, list price, min / max and safety stock.
Show Serial Numbers adds one row per serial number resident in the on-hand location; the quantity and value columns are those of the location and repeat on every serial row. | Inventory Enginatics | |
| INV Organization Access | Inventory organization access for all responsibilities, either through hr security profile or individual org_access assignment. | Inventory Enginatics | |
| INV Organization Parameters | Inventory Enginatics, R12 only | | |
| INV Period Close Pending Transactions | Summary report to display the pending transaction counts as found in the Inventory Account Periods Close form, checking open receipts, pending shipments, failed inventory, WIP, etc
The Period Count shows the pending transactions occurring within the specified period.
The Period Close Count shows the count of pending transactions as at the scheduled period close date of the specified period.
The Period Close Count are the counts displayed in the Pending Transactions Inventory Account Periods Close Form.
This is the accumulated count of pending transactions upto the shceduled close date of… full description | Inventory Enginatics, R12 only | |
| INV Physical Inventory Adjustments | Imported from BI Publisher
Description: Physical inventory adjustments report
Application: Inventory
Source: Physical inventory adjustments report (XML)
Short Name: INVARPAR_XML
DB package: INV_INVARPAR_XMLP_PKG | Inventory Enginatics | |
| INV Physical Inventory Locator Count Sheet | Count sheet listing every active stock locator of the quantity tracked subinventories, as an alternative to printed physical inventory tags.
One row per item, revision, lot and LPN on hand in the locator. A locator without on hand stock is listed once with a blank item, so counters can record stock found in locations the system considers empty.
On hand held in project and task logical locators is shown against its physical locator, with the project and task.
System Quantity is the live on hand at run time, not the physical inventory snapshot. Leave Show System Quantity empty for a blind… full description | Inventory Enginatics | |
| INV Physical Inventory Tags | Imported from BI Publisher
Description: Physical Inventory Tags
Application: Inventory
Source: Physical Inventory Tags (XML)
Short Name: INVARPTP_XML
DB package: INV_INVARPTP_XMLP_PKG | Inventory Enginatics | |
| INV Physical inventory accuracy analysis | Imported from BI Publisher
Description: Physical inventory accuracy analysis
Application: Inventory
Source: Physical inventory accuracy analysis (XML)
Short Name: INVARPIA_XML
DB package: INV_INVARPIA_XMLP_PKG | Inventory Enginatics | |
| INV Safety Stocks | Master data report for inventory safety stock with inventory org code, item, effective date, UOM,safety stock quantity, safety stock method, forecast , safety stock percent, service level and creation information. | Inventory Enginatics | |
| INV Serial Numbers | Serial numbers in any status (defined, in stores, issued out of stores, in transit, in receiving, in WIP), one row per serial number, with current organization, subinventory and locator, the last transaction source, the customer of a serial issued on a sales order and the genealogy parent.
Organization is the current organization; for an issued serial it is the organization that issued it. Customer is the sold-to customer of the sales order of the last transaction, blank when the order no longer exists. Last Transaction Type and Date are blank where Oracle did not record the last transaction… full description | Inventory Enginatics | |
| INV Slow Moving Inventory | Slow moving, excess and obsolete inventory. Lists items still holding stock as of a chosen date that have had no material movement over a chosen period, with their value, usage rate and months of supply, for obsolescence provisioning.
On Hand is the quantity as of the As of Date, not the current quantity. It is rolled back like Oracle's Transaction Historical Summary report, by reversing every material transaction posted after that date. Values use the item cost of the organization's primary cost method.
The no activity test is made per item, so an item is dropped as a whole as soon as any… full description | Inventory Enginatics | |
| INV Stock Locators | Summary report for Inventory locations, showing locator number, description, type, status, subinventory, picking order, dropping order and unit, volume, weight, dimension and co-ordinate information. | Inventory Enginatics | |
| INV Subinventories | Profile subinventory report with subinventory name, description, status, default cost group, type, restriction attributes, and general ledger account linkages. For BR100. | Inventory Enginatics | |
| INV Transaction Register | Imported from BI Publisher
Description: Transaction register
Application: Inventory
Source: Transaction register (XML)
Short Name: INVTRREG_XML
DB package: INV_INVTRREG_XMLP_PKG | Inventory Enginatics, R12 only | |
| INV Transaction Source Types | Inventory Enginatics | | |
| INV Transaction Types | Inventory 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…