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
29 reports
| Description | Download | ||
|---|---|---|---|
| ONT Blanket Sales Agreements | Blanket sales agreements, one row per agreement line, with the minimum and maximum quantity and amount, and the quantity and amount released, fulfilled and returned by the sales order lines that reference the agreement.
Remaining is the maximum plus the returned less the released quantity or amount, the limit that Order Management validates new releases against. Agreement level amounts are shown on the first line of each agreement only, so that they can be summed. Releases counts the sales orders with a not cancelled line released against the agreement line.
Use ONT Orders and Lines with… full description | Order Management Enginatics |   |
| ONT Cancelled Orders | Imported from BI Publisher
Description: Cancelled Orders Report
Application: Order Management
Source: Cancelled Orders Report (XML)
Short Name: OEXOEOCS_XML
DB package: ONT_OEXOEOCS_XMLP_PKG | Order Management Enginatics | |
| ONT Defaulting Rules | Shows the complete Order Management defaulting rules setup | Order Management Enginatics | |
| ONT Order Holds | Detail Sales Order report with line item details for all order lines that are on hold and the reason for the hold. | Order Management Enginatics | |
| ONT Orders | Detail Sales Order or Quote header report, including status, amount and invoice status information. | Order Management Enginatics | |
| ONT Orders and Lines | Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information.
Show Sales Credits adds one row per sales credit of each line, taken from the line, or from the order header for lines without sales credits of their own. Credited Amount is the line extended price times the credit percent and is shown once per line and credit, so it can be summed by salesperson; the other amount columns stay on one row per line.
Show Order to Cash Details adds the booked date and open holds of each line, and for the line's latest invoice the due date,… full description | Order Management Enginatics | |
| ONT Price Adjustments and Charges | Price adjustments applied to sales orders: discounts, surcharges, price breaks, promotional goods and freight and special charges, one row per adjustment of an order header or line.
Extended Amount is the unit adjustment times the ordered quantity, a lumpsum charge once per line. Discounts and credits are negative, and line amounts of return lines carry the reverse sign, as in ONT Orders and Lines.
Order level modifiers are stored once per order without a line. The line selling prices include their effect, but Oracle stores no amount for it, so Unit Adjustment and Extended Amount are blank… full description | Order Management Enginatics | |
| ONT Recurring Billing Plan | Profile report showing the Sales order recurring billing plan for header and line details including status, frequency, billing period, billing amounts and dates. | Order Management Enginatics, R12 only | |
| ONT System Parameters | Order Management Enginatics | | |
| ONT Transaction Types Listing | Imported Oracle standard Order Management transaction types listing, enhanced to show the setup across all operating units
Description: Transaction Types Listing Report
Application: Order Management
Source: Transaction Types Listing Report (XML)
Short Name: OEXORDTP_XML
DB package: ONT_OEXORDTP_XMLP_PKG | Order Management Enginatics | |
| ONT Transaction Types and Line WF Processes | Master data report showing the setup of order management transaction types and associated line types and workflow processes. | Order Management Enginatics | |
| QP Customer Pricing Engine Request | QP Customer Pricing Engine Request
==============================
This report requests Item Selling Price information by Customer across Price Lists from the Pricing Engine.
The report also displays the Items Costs for the specified Organization and based on the Unit Selling Price and Item Cost, displays a Margin Analysis.
The report can be run in Summary or Detail Mode.
In Summary Mode, the report will display a summary of Applied Price Lists, List Price, Adjustment Amount, Final Unit Selling Price, Accrual Amount, Charge Amount, Item Cost, and Margin per Customer, requested Price List… full description | Order Management Enginatics | |
| QP Modifier Details | Imported from BI Publisher
Description: Modifier Details Report for QP
Application: Advanced Pricing
Source: Modifier Details (XML)
Short Name: QPXPRMLS_XML
DB package: QP_QPXPRMLS_XMLP_PKG
he Modifier Details (columns) are repeated across all rows pertaining to the Modifier
The List Line Details (columns) are repeated across all rows pertaining to the List Line
For a given modifier the row sequence is:
- Modifier Level Qualifiers (sorted by qualifier group, qualifier grouping number)
- Modifier List Lines (sorted by list line number)
For each Modifier List the row sequence is:
- List… full description | Order Management Enginatics, R12 only | |
| QP Price Lists | Master data report showing the setup of price lists including item prices, calculation methods, terms and dates. | Order Management Enginatics | |
| QP Pricing Agreements | Report detailing QP Pricing Agreements | Order Management Enginatics | |
| QP Pricing Attribute Definitions | Lists the Pricing and Qualifiers Attributes defined for use by Advanced Pricing | Order Management Enginatics | |
| WSH Commercial Invoice | Shipping commercial invoice report showing delivery details including shipped items, quantities, unit costs, extended costs, ship-from/ship-to addresses, freight information, and bill of lading details.
Blitz version of the Oracle standard Commercial Invoice (XML) concurrent program WSHRDINV_XML.
DB package: WSH_WSHRDINV_XMLP_PKG | Order Management Enginatics | |
| WSH Shipping/Delivery Transactions | This report provides details of Warehouse Shipping Transactions and Deliveries.
To review details of deliveries only, set the Assigned to Delivery Parameter = 'Yes'
To review details of shipping transaction not yet assigned to a delivery, set the Assigned to Delivery Parameter = 'No'
Set the parameter to null to review all shipping transations regardless of delivery assignment status. When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount,… full description | Order Management Enginatics | |
| ONT Audit History | Order Management audit history report showing changes to order headers, lines, sales credits, and price adjustments with old/new values, change reasons, and the user who made the change.
Based on Oracle standard report OEXAUDHR_XML (Audit History Report). | Order Management Enginatics | |
| ONT Order Upload | Upload to Create, Update, Book and Cancel Sales Orders in Oracle Order Management.
Supports creating new orders, updating existing orders, adding new lines to existing orders, splitting lines, booking orders and cancelling orders.
To split a line, add a row for the order with the line to split in Split From Line and the new shipment's quantity in Ordered Quantity. The original line is reduced by that quantity unless its own row sets its new quantity. As in the Split Line window, the new shipment copies all other values from the original line, only Request Date, Warehouse and Ship To can… full description | Order Management Enginatics, Upload | |
| ONT Order to Cash Tracker | One row per sales order or quote line with the date of each step from quote to payment, and the accounting and GL posting of its invoice.
Invoice columns are those of the first invoice raised for the line; Invoiced Amount sums all its invoice lines. Amount Due Remaining is shown on the invoice's first order line only, so it can be summed. Paid Date is the date the invoice's last installment closed, Receipt Number the latest receipt applied to it.
Accounted Date is when final accounting was created for the invoice, GL Posted Date when its journal was posted. | Order Management Enginatics, R12 only | |
| ONT Orders and Lines 11i | Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information.
Show Sales Credits adds one row per sales credit of each line, taken from the line, or from the order header for lines without sales credits of their own. Credited Amount is the line extended price times the credit percent and is shown once per line and credit, so it can be summed by salesperson; the other amount columns stay on one row per line.
Show Order to Cash Details adds the booked date and open holds of each line, and for the line's latest invoice the due date,… full description | Order Management Enginatics | |
| ONT Sales Quote Close Upload | Bulk closes open Oracle Order Management sales quotes (documents in the Negotiation transaction phase) - useful for cleaning up large volumes of old draft quotes.
Download the open quotes, keep the rows you want to close, set a Close Reason, and upload. Each quote is driven to the Lost terminal (status Lost, no longer open) through the standard negotiation workflow, and the reason is recorded against the quote.
Quotes are identified by Quote Number and Operating Unit, so you can also paste those two values from an external list instead of downloading. Only open quotes are closed - an order… full description | Order Management Enginatics, Upload | |
| QP GSA Pricing Upload | This upload supports the creation and update of GSA Pricing Setup in Oracle Advanced Pricing.
The upload supports creation/update/deletion of the following entities within a GSA Pricing List:
- GSA Lists (created as a Modifier List)
- GSA List Qualifiers (created as a Modifier List Qualifier)
- GSA List Lines (created as Modifier Lines)
Notes:
When downloading existing GSA Lists into the upload excel; the List level Qualifiers and the List Lines will be downloaded into separate rows in the excel. This is to minimize the duplication of data in the excel.
However:
When entering List… full description | Order Management Enginatics, Upload | |
| QP Modifier Upload | This upload supports the creation and update of Modifiers in Oracle Advanced Pricing.
The upload supports creation/update/deletion of the following entities within a Modifier List:
- Modifier List Qualifiers
- Modifier List Limits
- Modifier Lines
- Modifier Line Price Breaks. To enter the Modifier Price Breaks in the upload, repeat the Modifier Price Break Header Line and enter/adjust the Price Break Columns for each Price Break.
- Modifier Line Additional Buy Items.
- Modifier Line Get Items
- Modifier Line Pricing Attributes
- Modifier Line Qualifiers
- Modifier Line Limits
Notes:
When… full description | Order Management Enginatics, Upload | |
| QP Price List Upload | This upload supports the creation and update of Standard Price Lists in Oracle Advanced Pricing.
The upload supports creation/update/deletion of the following entities within the Price List:
- Price List Lines
'End Date Matching List Lines?'
When creating new Price List Lines, the upload can automatically end date any existing matching active price list line by setting the report parameter 'End Date Matching List Lines?' to Yes.
Set this parameter to Yes to automatically end date any active matching price list line on upload.
Any price list lines downloaded when this parameter is set to… full description | Order Management Enginatics, Upload | |
| QP Qualifier Group Upload | This upload supports the creation and update of Qualifier Groups in Oracle Advanced Pricing. | Order Management Enginatics, Upload | |
| WSH Container Items Upload | Creates, updates and deletes container-item relationships - the Container-Item Relationships form (Shipping > Setup > Container Load Details). A relationship states the maximum quantity of a load item that fits into a container item in one inventory organization; auto-pack uses the load item's preferred container.
Setting Preferred Flag to Yes removes the flag from the load item's current preferred container, as the form does after asking, and the Message names that container. When several rows of one file make different containers preferred for the same load item, the last row… full description | Order Management Enginatics, Upload | |
| WSH Pick Confirm Upload | WSH Pick Confirm Upload
=======================
Confirms released sales order pick tasks in bulk from Excel: the picked quantity, the subinventory, locator and lot actually picked, the staging location and, in WMS enabled organizations, the LPN the material was packed into.
Download the released to warehouse lines of an organization, optionally restricted to an order, delivery, trip, move order (pick slip), customer or item. One row is created per pick allocation, and per allocated lot for lot controlled items.
Overwrite the pre-filled allocation where the pick differs, enter the LPN and… full description | Order Management Enginatics, R12 only, Upload | |
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…