Order Management provides you with a variety of flexible and easy-to-use reports to help you improve productivity and increase control.
Order-related reports include the following:
Commitment Balance Report
Comprehensive Order Detail Report
Order/Invoice Detail Report
Orders by Item Report
Workflow Assignments Report
Sales Order Acknowledgement
Sales Order Workflow Status Report
Export Compliance Screening Failure Report
Export Compliance Report to Government
Credit Order-related reports include the following:
Credit Order Detail Report
Credit Order Discrepancy Report
Credit Order Summary Report
Credit Limit Usages Report
Credit Exposure Report
Customer Credit Snapshot Report
Orders On Credit Check Hold Report
Lines on Credit Check Hold Report
Payment Receipt
Exception reports include the following:
Hold Source Activity Report
Outstanding Holds Report
Sales Order and Purchase Order Discrepancy Report
Internal Order and Purchasing Requisition Discrepancy Report
Order Discount Detail Report
Order Discount Summary Report
Unbooked Orders Report
Unbooked Orders Detail Report
Cancelled Orders Report
RetroBilling Report
Returns by Reason Report
Cancelled Orders Reasons Detail Report
Administration reports include the following:
Agreement Activity Report
Orders Summary Report
Order/Invoice Summary Report
Salesperson Order Summary Report
Audit History Report
Setup-related reports include the following:
Defaulting Rules Listing Report
Processing Constraints Listing
Transaction Types Listing Report
OE-OM Order Line Transaction Count Summary/ Comparison Reports
All reports are classified as Single Org (Single operating unit) or global (across operating units).
Submitting Single Org Reports for multiple Operating Units
You can submit Single Org reports for any of the Operating Units that are accessible to you. When you launch the concurrent request, the Operating Unit is available as a parameter. This mandatory parameter in the launch request window displays your default Operating Unit. However you can choose a different one from the LOV, which displays all Operating Units accessible to you. Thus you can run the report for multiple Operating Units, one Operating Unit at a time without switching responsibilities. The Single Org reports are:
Agreement Activity Report
Audit History Report
Cancelled Orders Reason Detail Report
Cancelled Orders Report
Credit Exposure Report
Comprehensive Order Detail Report
Credit Order Discrepancy Report
Credit Order Detail Report
Credit Order Summary Report
Export Compliance Report for Government
Export Compliance Screening Failure Report
Hold Source Activity Report
Internal Order and Purchasing Req Discrepancy Report
Lines on Credit Check Hold Report
Order Discount Summary Report
Order Discount Detail Report
Order/Invoice Detail Report
Order/Invoice Summary Report
Orders Summary Report
Orders by Item Report
Outstanding Holds Report
Orders on Credit Check Hold Report
Payment Receipt
Retroactive Billing Report
Returns by Reason Report
Sales Order Acknowledgement
Sales Order WF status report
Sales Order and Purchase Order Discrepancy Report
Salesperson Order Summary Report
Transaction Types Listing Report
Unbooked Orders Detail Report
Unbooked Orders Report
Workflow Assignments Report
The following reports are global (report on data across Operating Units):
Defaulting Rules Listing Report
Processing Constraints Listing Report
Order Line Transaction Count Summary Report
OE-OM Order Line Transaction Count Comparison Report
Use this report to review summary information for your customer commitments. Oracle Receivables automatically prints all invoices and credit memos against the initial commitment, and displays the remaining balance of the commitment.
See: Oracle Receivables, Commitment Balance Report.
The Comprehensive Order Detail Report reviews comprehensive details of all orders. This report provides a detailed, comprehensive listing of information about each order, including sales credits, price adjustments, shipping, cancellation and schedule details.
In the Order Management Reports window, select Comprehensive Order Detail Report in the Name field.
When you request a Comprehensive Order Detail Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order, enter the same order number in the Order Number From/To fields.
Warning: When running this report you must specify at least one of the parameters, for example, Order Number range. If no parameters are specified you will be selecting everything in your database.
Determine the report output sort option. Select from:
Agreement: Order Management sorts this report alphabetically by Agreement name.
Customer: Order Management sorts this report by customer name, order number, return line number
Order Date: Order Management sorts this report by order date, order number, return line number
Order Number: Order Management sorts this report by order number, return line number
Order Type: Order Management sorts this report by order type, order number, line number
Sales Representative: Order Management sorts this report alphabetically by Salesperson.
Ship to Country: Order Management sorts this report alphabetically by Ship To Country.
The default value is Order Type. This field is required.
Optionally, select a specific order type or range of order types on orders that you want printed in this report.
Optionally, select a specific order line type or range of order line types you want print in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select a customer name or range of customer names you want printed in this report.
Optionally, select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer Number From field or the report output may complete with errors.
Optionally, select a salesperson or range or salespeople you want printed in this report.
Optionally, select the user id of the order entry clerk or range of user ids whose orders you want printed in this report.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that have at least one return line
Sales Orders Only: Include only orders that have at least one sales order line
The default value is Sales Orders Only.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales Order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is All Lines.
Determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes. This field is required.
Optionally, determine whether you want to print sales credits in this report.
The default value is Yes.
Optionally, determine whether you want to print price adjustments in this report.
The default value is Yes.
Optionally, determine whether to print report output information in the functional currency for the ledger from the operating unit the report is submitted from
Yes: Print currency amounts in the functional currency for your set of book
No: Print currency amounts in the functional currency for the order
The default value is No.
Optionally, determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description.
The Comprehensive Order Detail Report prints comprehensive order details and displays the following 3 report sections sequentially for each order selected.
Order Header Information
Order Sales Credit Information
Order Line Details
Order Header and Order Sales Credit Information is only printed once for order details that span multiple output pages.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Note: When Multiple Payments functionality is enabled this report shows additional details as follows:
Header region - Payment Type, Prepayment, Percent and Amount.
Lines region: Payment type, Percent and Amount. Account numbers or similar data is not included in this report.
Page breaks are provided for each order selected.
The Order/Invoice Detail Report reviews detailed invoice information for orders that have invoiced. You can Select from a variety of parameters to print the invoice information for a specific order or group of orders. If there are no invoices for a particular order that meets your parameter criteria, Order Management prints in the report that no invoices exist for that order.
In the Order Management Reports window, select Order/Invoice Detail Report in the Name field.
When you request an Order/Invoice Detail Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order, enter the same order in the From/To fields.
Determine the report output sort option. Select from:
Customer: Order Management sorts this report by customer name, order number, return line number
Order Type: Order Management sorts this report by order type, order number, line number
Sales Person: Order Management sorts this report by alphabetically by Salesperson
The default value is Customer Name. This field is required.
Determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes. This field is required.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific Sales person or range of salespeople on orders you want printed in this report.
Optionally, select a specific order type or range of order types on orders that you want printed in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers
Optionally, select the country for the ship to addresses of the orders you want printed in this report.
Optionally, determine the types of orders you want printed on this report. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
The default is Sales Orders Only.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is Sales Order Lines only.
Optionally, determine whether to print report output information in the functional currency for the ledger from the operating unit the report is submitted from.
Yes: print currency amounts in the functional currency for your set of book
No: print currency amounts in the functional currency for the order
The default value is No.
This report is automatically sorted by order number, order date, bill-to address, ship-to address, and salesperson. If invoice information is not available for orders selected, Order Management will provide the following information.
Order Number: Order Management prints the order number for each order selected
Order Date: Order Management prints the order date for each order selected
Customer Name: Order Management prints the associated Customer Name for each order selected
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
Page breaks are provided for each currency/customer combination selected by the report input parameters. Additional page breaks occur for each currency selected by the report input parameters.
The Orders by Item Report reviews all sales for a particular item or group of items. You can restrict the output of this report by customer, order number range or range of order dates. Order Management automatically sorts this report by item, customer name, and then order number.
This report provides a listing of each item, customer name and number, order number, purchase order number, order date, ordered quantity, shipped quantity, and outstanding quantity, and subtotals for each item and customer.
In case of a shippable item, the outstanding quantity is calculated as the difference between ordered quantity and shipped quantity. However for a non-shippable item, the outstanding quantity is calculated as the difference of ordered quantity and fulfilled quantity. The ordered quantity and fulfilled quantity lines are summed before calculating their difference. The outstanding quantity therefore represents the unfulfilled quantity.
In the Order Management Reports window, select Orders by Item Report in the Name field.
When you request an Orders by Item Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order, enter the same order in the From/To fields.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select a specific item or range of item that you want printed in this report.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
The default value is Sales Orders Only.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is Sales Order Lines only.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is null.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
The Workflow Assignments Report displays the header and line flow combinations and item types for order workflows. The report includes selected OM Transaction Types and both header and line workflows.
In the Order Management Reports window, select the Workflow Assignments Report in the Name field.
When you request a Workflow Assignments Report, Order Management provides you with the following parameter. If you leave any parameter blank, this report includes all workflow assignments that meet your other parameter criteria. In order to obtain a single workflow assignment, enter the same workflow assignment in the From/To fields.
Optionally, select a specific order transaction type or range of OM order transaction types to include in this report.
Note: If you enter a value for the order transaction type parameter, the workflow assignments will be listed for that order transaction type only. If you leave this parameter blank, the workflow assignments for all OM order transaction types will be displayed.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Sales Order Acknowledgement communicates to your customers the items, prices, delivery dates, service, and installation details for orders they place with you. Use this report to provide a printed document that can be mailed or faxed to a customer as a record of the order placed.
When you submit the Sales Order Acknowledgement report, if your Oracle Applications uses the Multiple Language Support (MLS) functionality, the report will be run once for each language supported.
This report is designed for printing on pre-printed forms. Contact your Oracle Consultant for information regarding pre-printed forms.
In the Order Management Reports window, select Sales Order Acknowledgement in the Name field.
When you request a Sales Order Acknowledgement, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all sales orders that meet your other parameter criteria. In order to obtain a single sales order, enter the same sales order number in the in the Oder Number From/To fields.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, select the booked status of the orders you want printed in this report.
Optionally, select the order type you want printed in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select a specific customer or range of invoice to customers to include in this report.
Optionally, select the name(s) of the ship-to customer(s) you want printed in this report.
Optionally, select a specific schedule date or range of schedule dates to include in this report.
Optionally, select a specific request date or range of request dates you want printed in this report.
Optionally, select a specific promise date or range of promise dates to include in this report.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that have at least one return line
Sales Orders Only: Include only orders that have at least one sales order line
The default value is Sales Orders Only.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales Order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is All Lines.
Optionally, select the salesperson for the orders you want printed in this report.
Optionally, select the user id of the sales entry clerk whose orders you want printed in this report.
Optionally, determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes.
Optionally, select the range of deliver to customer names to include in this report.
Optionally, determine whether to print all order header attachments.
The default value is No.
Optionally, determine whether to print all Body attachments.
The default value is No.
Optionally, determine whether to print all Footer attachments.
The default value is No.
The Sales Order Acknowledgement Report has a different output display than other Oracle Order Management reports, because it is typically faxed or mailed to customers. Differences include:
Input parameters are not listed on the first page of the report
The title is not listed on each page of the report
The page number listed on the report resets with new orders
The Sales Order Acknowledgement Report is automatically sorted by order number, order date, bill-to address, ship-to address, and salesperson. The report displays the following 2 report sections for each order selected.
Order Header Information
Order Line Details
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed prior to the next order selected.
Note: Sales Order Acknowledgement does not show any prepayment information.
Page breaks are provided for each order selected by the report input parameters.
The Sales Order Workflow Status Report enables Order Management users to locate orders that are not progressing through associated workflows as expected. There could be several reasons why the orders are not progressing. For example:
Order Lines which are entered but not booked
Booked Order Lines which have not been scheduled prior to the request date
Order lines which have shipped but not yet closed
Order Lines which have been scheduled but not pick released
Order Lines which have been pick released but not ship confirmed
Order Lines which have been shipped via Oracle Shipping Execution, but awaiting actually shipping in OM
Order lines which have been shipped but not invoice interfaced
The Sales Order Workflow Status Report has been updated to improve printing and output formatting.
In the Order Management Reports window, select the Sales Order Workflow Status Report in the Name field.
When you request a Sales Order Workflow Status Report, Order Management provides you with the parameters listed below. If you leave any optional parameters blank, this report will include all possible values for the parameters and includes all order lines that meet your other parameter criteria. In order to obtain the workflow status for all for a single order, enter the same value in the Order Number (From/To) fields.
Enter a numeric value for orders that have not progressed through a particular workflow activity for a certain number of days. The workflow activity used to determine report output selection for overdue days is the value selected for the input parameter Actions.
The default for this field is NULL, and the field is required.
Select an action to limit the report output to display only orders that have not progressed through that activity. The default for this field is NULL, and the field is required.
Select from:
Order lines entered but not booked
Order lines booked but not scheduled
Order lines scheduled but not pick released
Order lines pick released but not ship confirmed
Order lines shipped in shipping but awaiting shipping in OM
Order lines ship confirmed but not invoice interfaced
Order lines shipped but not closed
Order lines invoice interfaced but not closed
Select an Order type to limit the report output by order transaction type, and the workflow activity selected in the input parameter Action.
The default for this field is NULL, and the field is optional.
Enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers
The default for these fields is NULL, and the fields are optional.
Determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales Order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default for this field is Null, and the field is optional.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value for this field is Null, and the field is optional.
The Sales Order Workflow Status Report displays the following details for each order selected.
Order Line Details
Page Summary Details
The Export Compliance Screening Failure Report provides you with an output of all order and lines that have failed export compliance screening and meet your input criteria.
In the Order Management Reports window, select the Export Compliance Screening Failure Report in the Name field.
When you request the Export Compliance Screening Failure Report, Order Management provides you with the parameters listed below. If you leave any optional parameters blank, this report will include all possible values for the parameters and includes all failed export compliance order lines that meet your other parameter criteria. In order to obtain export compliance order line failures for a single order, enter the same value in the Order Number (From/To) fields.
Customer Name: Order Management sorts this report by customer name. Order Type: Order Management sorts this report by order type
Order Date: Order Management sorts this report by the order screening date associated with an order
Order Number: Order Management sorts this report by order number
The default value is Customer Name, and this field is required.
Optionally, enter a specific order number or range of order numbers to include on this report. These fields accept any integer value, without validation against available order numbers
Optionally, select a specific screening date or range of screening dates for the orders to include on this report. Screening date is the date the order or line was screened for export compliance by your ITM vendor software application.
Optionally, select a specific order type to include on this report.
Optionally, select a specific customer number or range of customer numbers to include on this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
Optionally, determine the screening type failures to include on this report. Select from:
Denied Party
Embargo
The Export Compliance Screening Failure Report displays the following 3 report sections for each order selected.
Order Header Information
Order Line Details
Screening Details
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Export Compliance Report to Government reports provides you with the ability to quickly produce evidence of due diligence when screening shipments for export compliance. The report output displays order line details for all order lines that have undergone export compliance screening, with the exception of order lines that underwent screening but were cancelled. Order lines screened but cancelled do not appear in the report output.
In the Order Management Reports window, select the Export Compliance Report to Government in the Name field.
When you request the Export Compliance Report to Government, Order Management provides you with the parameters listed below. If you leave any optional parameters blank, this report will include all possible values for the parameters and includes all order lines that meet your other parameter criteria. In order to obtain export compliance details for a single order, enter the same value in the Order Number (From/To) fields.
Customer Name: Order Management sorts this report by customer name, order number, return line number
Screened Date: Order Management sorts this report by the screening date associated with an order line
Order Number: Order Management sorts this report by order number, line number
Shipped From: Order Management sorts this report by order line Ship From
The default for this field is Screening Date, and this field is required.
Optionally, select a specific screening date or range of screening dates for the orders you want included in this report. Screening date is the date the order or line was screened for export compliance by your ITM vendor software application.
The Export Compliance Report to Government displays the following 3 report sections for each order selected.
Ship From Order Information
Order Line Details
Shipped To Order Information
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Credit Orders Detail Report displays returned lines for a specific credit order type, credit order line type, specific item, date range, order number, and salesperson.
In the Order Management Reports window, select the Credit Orders Detail Report in the Name field.
When you request a Credit Orders Detail Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all returned lines that meet your other parameter criteria. In order to obtain a single return line, enter the same return line in the From/To fields.
Determine the report output sort. Select from:
Customer Name: Order Management sorts this report by customer name, order number, return line number
Return Number: Order Management sorts this report by return order number, line number
Return Type: Order Management sorts this report by return type, order number, line number
The default is Customer Name. This field is required.
Determine whether to include open credit orders only.
The default value is Yes. This field is required.
Optionally, enter the item number or partial item number to include in the report output.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, select the salesperson to include in this report.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
Optionally, select the credit order type to include in this report.
Optionally, select the credit order line type to include in this report.
Optionally, determine whether to print all order lines or only credit order lines. Select from:
All Lines: Display all order lines
Credit Order Lines Only: Display only return lines
The default is Credit Order Lines Only.
Optionally, enter a specific credit order number or range of credit order numbers to include in this report. These fields accept any integer value, without validation against available return order numbers.
Optionally, select a specific credit order date or range of credit order dates you want printed in this report.
The Credit Orders Detail Report displays the following 2 report sections for each order selected.
Order Header Information
Order Line Details
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
The Credit Order Discrepancy Report is used to review discrepancies between RMA lot and serial numbers returned by the customer and lot and serial numbers on the rma return order.
In the Order Management Reports window, select the Credit Order Discrepancy Report in the Name field.
When you request a Credit Order Discrepancy Report, Order Management provides you with the input parameters to limit report output. If you leave any parameters blank, this report includes all returned lines that meet your other parameter criteria.
Determine the report output sort option. Select from:
Customer Name: Order Management sorts this report by customer name, order number, return line number
Credit Order type: Order Management sorts this report by credit order type, line type, customer, order number, line number
Credit Order Number: Order Management sorts this report by credit order number, line number
The default value is Customer. This field is required.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers
Optionally, select a specific order date or range of order dates for the returns you want printed in this report.
Optionally, select a specific order type or range of order types to include in this report.
Optionally, select a specific customer name or range of customer names to include in this report.
Optionally, select a specific customer number or range of customer numbers to include in this report.
Optionally, select a specific item or range of range of items for the returns you want printed in this report.
Optionally, select a specific receipt date or range or receipt dates for the returns you want printed in this report.
Optionally, select from either item description or item flexfield.
The default value is Description.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Credit Orders Summary Report displays all return lines in an order. This report can be used to provide comprehensive order details for return order lines received from customers. The report output can contain either open or closed orders that have at least one credit line, and also displays summary information by customer order, and currency.
In the Order Management Reports window, select Credit Orders Summary Report in the Name field.
When you request a Credit Orders Summary Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all return lines that meet your other parameter criteria. In order to obtain a single return line, enter the same return line in the From/To fields.
Determine the report output sort option. Select from:
Credit Order Type: Order Management sorts this report by order type, order number, line number
Customer Name: Order Management sorts this report by customer name, order number, line number
Warehouse name: Order Management sorts this report by warehouse name, order number, line number
The default value is Customer Name. This field is required.
Determine whether to include open credit orders only.
The default value is Yes. This field is required.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, determine whether to print credit summary information in the functional currency for the ledger from the operating unit the report is submitted from.
Yes: print currency amounts in the functional currency for your ledger
No: print currency amounts in the functional currency for the order
The default value is No.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
Optionally, select the location receiving the return to include in this report.
Optionally, select the credit order type to include in this report.
Optionally, select the credit order line type to include in this report.
Optionally, determine whether to print all order lines or only credit order lines. Select from:
All Lines: Display all order lines
Credit Order Lines Only: Display only return lines
The default is Credit Order Lines Only.
Optionally, enter a specific credit order number or range of credit order numbers to include in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific credit order date or range of credit order dates you want printed in this report.
Optionally, enter the range of credit order days to include in this report.
Optionally, enter the range of expected receipt dates to include in this report.
Optionally, enter the range of days from authorization to receipt to include in this report.
The Credit Order Summary Report prints summary order details and displays the following 3 report sections sequentially for each order selected.
Order Header Information
Order Line Information
Order Summary Information
Order Header Information is only printed once for order details that span multiple output pages.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
Page breaks are provided for each order Currency selected by the report input parameters.
The Credit Limit Usages Report enables you to review credit information by credit profile types. The report is available from Oracle Receivables Listing SRS window, providing you with a listing of credit limits, credit usage rules, and currency credit limit usages associated with either:
Customer or Customer Site Credit Profiles
Review credit limits by customer or customer site (order and overall), and usage rules assigned to a customer or customer site. You can specify a range of customers or list customers assigned to a specific rule set.
Customer Class Credit Profile
Review credit limits (order and overall), and usage rules by customer class credit profile. You can specify a range of profile classes or list customer class credit profiles assigned to a specific rule set.
Operating Unit Credit Profiles
Review credit limits (order and overall) and default usage rules by Operating Unit. You can specify effective dates and usage rules.
Item Categories Credit Profiles
Review credit limits (order only), effective dates and usage rules by Item category. You can specify a range of item categories or list categories assigned to a specific rule set.
The Credit Limit Usages Report can also be used to view customers credit limits that do not have any associated credit usages rule sets and currencies included or excluded within a specific rule set
From an Accounts Receivables responsibility, Report Listing standard report submission window, select the Credit Limit Usages Report in the Name field. If you leave any parameters blank, this report includes all records that meet your other parameter criteria. In order to obtain specific input selection, enter the same value in the From/To fields.
When you request a Customer Credit Limits and Usages Report, the application provides you with the following input parameters to limit the report output.
Include Operating Unit: Optionally, determine whether to display operating unit credit profile information
The default value is No.
Operating Unit: Optionally, select a single operating unit to display it's associate credit profile information or leave the parameter blank to include all operating units credit profile information for the report output
Using Rule Set: Optionally, select a specific Credit Usage Rule Set name to further limit operating unit selection criteria for your report output
For example, if you choose to leave the Operating Unit input parameter blank, specify a Credit Usage Rule Set name in this field to display only operating units using the specific Credit Usage Rule Set name selected
Include Item Category Information: Optionally, determine whether to display Order Entry Item Category Code credit profile information
The default value is No.
Item Categories (From/To): Optionally, select a specific Item Category credit profile or a range of Item Categories credit profiles for the report output
Using Rule Set: Optionally, select a specific Credit Usage Rule Set name to further limit item category selection criteria for your report output
For example, if you choose to leave the Item Category From/To input parameters blank, specify a Credit Usage Rule Set name in this field to display only item categories using the specific Credit Usage Rule Set name selected
Include Profile Class: Optionally, determine whether to display Customer Profile Class credit profile information
The default value is No.
Profile Classes (From/To): Optionally, select a specific profile class or a range of profile classes for the report output
Using Rule Set: Optionally, select a specific Credit Usage Rule Set name to further limit item category selection criteria for your report output
For example, if you choose to leave the Profile Class From/To input parameters blank, specify a Credit Usage Rule Set name in this field to display only profile classes using the specific Credit Usage Rule Set name selected.
Include Customer Information: Optionally, determine whether to display Customer Credit Profile information
The default value is No.
Customers (From/To): Optionally, select a specific customer name or range of customer names to include customer credit profile information for the report output
Using Rule Set: Optionally, select a specific Credit Usage Rule Set name to further limit item category selection criteria for your report output
For example, if you choose to leave the Customer Name From/To input parameters blank, specify a Credit Usage Rule Set name in this field to display only customer names using the specific Credit Usage Rule Set name selected
Include Rule Set Information: Optionally, determine whether to display Credit Usage Rule Set information
The default value is No.
Credit Usages Rule Sets (From/To): Optionally, select a specific Credit Usage Rule Set Name or a range of Credit Usage Rule Set Names to include in this report
Note: The values entered for Global Rule Set Information are independent of all other report input parameter sections that utilize the parameter Using Rule Sets.
Note: For example, if you choose a specific Using Rule Set name for input parameters under the Operating Unit section, and specified a different usage rule set name in the Rule Set From/To fields within the Global Rule Set section, you will still receive output usage rule set information under the operating unit section of the report. You will also receive additional usage rule set information under the Usage Rules output section of the report.
The application displays all report input parameters and respective input values selected on the first page of the report output.
The report output may contain up to 5 headings. Output report heading are available for printing if the appropriate input parameter is set accordingly:
Include Operating Unit = Yes: Print operating unit credit information
Include Item Category Information = Yes: Print Item category credit information
Include Customer Information = Yes: Print Customer credit information
Include Profile Class = Yes: Print Profile Class credit information
Include Rule Set Information = Yes: Print Rule Set Information
If no records exist based upon your input selection criteria, the application will display a message informing you no records met your respective criteria.
The Credit Exposure Report can be used to analyze your customers total credit exposure. The report can be run in either detail or summary mode and is dependent upon the value selected for the Report Type input parameter:
The Credit Exposure Summary Report output details the credit limit, credit exposure, and available credit for every customer, based on the selected input parameters.
The Credit Exposure Detail Report shows the credit limit, credit exposure, and available credit for every customer, to include all Bill To sites, based on the selected input parameters.
The Credit Exposure Report includes detailed information for:
Overall credit limits per customer and customer site
Overall credit balances (exposure) per customer and customer site
Remaining available credit for either customers or customer sites. The remaining balance is converted to the draft functional currency (ledger currency of the current operating unit). Available credit is calculated by subtracting the total exposure from the overall credit limit.
Remaining available balance currently not attached to a specific customer credit limit as reflected by transactions that have not undergone the credit check process
Risks incurred by performing transactions in currencies that are not under credit limit control. These amounts are reported in the functional currency and these appear as unchecked balances.
The report output includes both Oracle Order Management and Oracle Receivables balances, based on your credit check rule definitions. Selecting a credit check rule for this report enables you to choose combinations of credit balance types to include when determining your customers' overall credit exposure. Each credit check rule can enable or disable the following credit balance types:
exchange rate type
include open receivables balance
include payments at risk
include uninvoiced orders
include tax
include freight and special charges
include orders currently on hold
scheduled lines only
shipped lines only
To determine a customer's existing credit exposure eliminating Oracle Order Management credit balances, submit the Oracle Receivables Customer Credit Snapshot report which does not include Order Management credit balances, which affect the current available credit exposure of your customers.
See: Oracle Receivables, Customer Credit Snapshot Report.
In the Order Management Reports window, select Credit Exposure Report in the Name field.
When you request a Credit Exposure Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report output includes all records that meet your other parameter criteria. To obtain a single credit exposure for a customer, enter the same value in the Customer Names (From/To) fields or the Customer Numbers (From/To) fields.
These fields are optional.
These fields are optional.
These fields are optional.
This field is required.
Select from:
Summary
Detail
This field is required.
Oracle Order Management displays all report input parameters and respective input values selected on the first page of the report output.
If you choose to run the report in detail mode (selecting Detail for the input parameter Report Type) additional credit usage details by Customer Bill To site are included in the report output.
Additional summary information is also provided.
The Oracle Receivables Customer Credit Snapshot Report has been enhanced to support multi-currency credit checking. This report is only available from Receivables Collections SRS window. Please refer to the Oracle Receivables User Guide for Information on this report.
See: Oracle Receivables, Customer Credit Snapshot Report.
Note: This report does not include Order Management credit balances, which affect the current available credit exposure of your customers.
The Orders On Credit Check Hold Report identifies all of the credit holds currently outstanding for a customer within a date range, or identify why a particular order is on hold. Order Management enables you to perform a credit check on customer orders and automatically places orders on hold that violate your credit checking rules.
All balances are calculated as they are using the on-line credit check rule, including the factor for shipments and receivables for a certain number of days. In the Orders on Credit Check Hold Report for the field 'Number of days on Credit Hold', the number of days is displayed.
Note: If a hold is applied due to exceeding the order limit, and upon reducing the quantity or applying a discount so that the order limit is not exceeded the hold is released automatically. But, if hold is applied due to an overall credit limit the hold it is not released automatically. If the quantity is reduced or an adjustment applied so the credit limit for the customer is not exceeded the hold is not released automatically. Only if the Credit Check Processor concurrent program runs will the hold be released.
In the Order Management Reports window, select Orders On Credit Check Hold Report in the Name field.
When you request an Orders On Credit Check Hold Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all holds that meet your other parameter criteria. In order to obtain a single hold, enter the same hold in the From/To fields.
Optionally, select the customer name that you want printed in this report.
Optionally, select the customer number that you want printed in this report.
Optionally, select the order type that you want printed in this report.
Optionally, select the order number that you want printed in this report.
Optionally, select a specific hold applied date or a range of hold applied date on which the holds were applied.
Optionally, select the currency code that you want printed in this report.
The Orders On Credit Check Hold Report prints order information for orders on credit check hold and displays the following 4 report sections sequentially for each order selected.
Customer Information
Customer Credit Limit Information
Customer Orders on Credit Hold Information
Summary Information
The report is automatically sorted by Customer. Within Customer, the report is further sorted by currency code, credit check rule name, and order number.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional summary information is also provided.
Page breaks are provided for each Customer selected by the report input parameters. Additional page breaks are provided for each customer/currency combination selected by the report input parameters.
In the Order Management Reports window, select the Lines on Credit Check Hold Report in the Name field.
When you request a Lines on Credit Check Hold Report, Order Management provides you with the following parameter. If you leave is blank, this report includes all order lines on hold that meet your other parameter criteria.
Optionally, select credit order lines on hold for a specific Customer Name you want printed in this report.
Optionally, select credit order lines on hold for a specific Customer Number you want printed in this report.
Optionally, select credit order lines on hold for a specific order type you want printed in this report.
Optionally, select credit order lines on hold for a specific order line type you want printed in this report.
Optionally, select credit order lines on hold for a specific order number you want printed in this report.
Optionally, determine how you wish to display items on hold for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description.
Optionally, select a specific hold applied date or a range of hold applied dates for credit order lines on hold.
Optionally, select credit order lines on hold for a specific currency you want printed in this report.
The Lines On Credit Check Hold Report prints order information for orders on credit check hold and displays the following 3 report sections sequentially for each order selected.
Customer Order Information
Order Line Credit Limit Information
Summary Information
The report is automatically sorted by Customer. Within Customer, the report is further sorted by currency code, credit check rule name, and order number.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional summary information is also provided.
Page breaks are provided for each Customer selected by the report input parameters. Additional page breaks are provided for each customer/currency combination selected by the report input parameters.
This document can used as a payment receipt when funds are collected along with the order. It can be called from a workflow, so it can be placed in the order flow to print automatically. It is also accessible from the Action menu and can be run as a standalone report.
In the Order Management Reports window, select Payment Receipt in the Name field, or run automatically from a workflow.
When you request a Payment Receipt, Order Management provides you with the following parameters.
Note: The Order Number is a required parameter when submitting via the concurrent manager. When run from Workflow, the Order Number defaults.
In the header area of the receipt, are header level attachments for this document, following are: Order Number, Created By, and Order Type.
In the body of the receipt, for each item: the Internal Item, the Item Description, the Unit Selling Price, the Quantity, and the Extended Selling Price. If there are price adjustments applied, a down arrow is located next to the Extended Price. After listing the items, there are a Subtotal of the extended prices, Tax, and Charges total, ending with the order Total. The Payment type is listed along with the Amount Paid and Balance Due. If Payment Type is Credit Card - then Credit Card type is also reported.
In the footer section are Number of items and the Sum of the quantities and any footer attachments.
Order Management displays all report input parameters and respective input Seed Data: Quick Codes and Messages
The Hold Source Activity Report reviews holds placed and removed under a hold source during the time period you specify. This report indicates the date and the type of activity for each hold transaction.
In the Order Management Reports window, select Hold Source Activity Report in the Name field.
When you request a Hold Source Activity Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all holds that meet your other parameter criteria. In order to obtain a single hold, enter the same hold in the From/To fields.
Optionally, select a specific hold source type or a range of hold source types that you want printed in this report.
Optionally, select a specific hold source name or range of hold source names that you want printed in this report.
Optionally, select a specific activity date or a range of activity dates that you want printed in this report.
Optionally, select the range of activity types that you want printed in this report. Select from
Apply hold
Release hold
The report output is sorted alphabetically by Hold Name, associated order Order Date.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Page breaks are provided for each Hold Type selected by the report input parameters.
The Outstanding Holds Report reviews order holds for the customer or customers you Select. This report displays the order number, order date, ordered items, and order amount for each order line on hold for each customer you select. It is automatically sorted by customer, order number, order line, and then order line detail. Hold Comment are listed in the report output, if available. This report lists only orders on hold, not orders that have been released from hold.
In the Order Management Reports window, select Outstanding Holds Report in the Name field.
When you request an Outstanding Holds Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all outstanding holds that meet your other parameter criteria. In order to obtain a single outstanding hold, enter the same outstanding hold in the From/To fields.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific hold source name or range or hold source names you want printed in this report.
Optionally, select a specific item or range of items you want printed in this report.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
If you are printing this report in multiple currencies you can use Mixed Precision to ensure that all currency values align at the radix character for easy readability. Mixed precision is the distance between the radix (the decimal, or any dividing symbol between the whole and parts of the currency) and the right side of the column. It is right padded if the currency's standard precision is less than the mixed precision.
Order Management defaults this report parameter from the system profile option Currency: Mixed Currency Precision. This field is required.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Sales Order and Purchase Order Discrepancy Report displays differences between the sales orders and purchase orders for a drop shipment so that you can identify where manual changes must be made. These differences arise when you modify the purchase order or requisition associated with a drop-ship sales order after successfully running Purchase Release.
Note: With Enhanced Change Management Support between Order Management and Purchasing changes on Requisitions and Purchase Orders will now be automatically synchronized with the Sales Order Line. Therefore there is no need to run this Report. However the Report still exists to support handling of discrepancies in pre-existing Sales Orders and PO's before an upgrade.
In the Order Management Reports window, select Sales Order and Purchase Order Discrepancy Report in the Name field.
When you request a Sales Order and Purchase Order Discrepancy Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all orders that meet your other parameter criteria.
Optionally, determine the output report sort option. Select from:
Customer Name: Order Management sorts this report by the customer name associated with an order
Order Date: Order Management sorts this report by the order creation date associated with an order
Order Type: Order Management sorts this report by order type entered for the Sales Order Header
Purchase Order Number: Order Management sorts this report by the Purchase Order Number entered for the Sales Order Header
Sales Order Number: Order Management sorts this report by the Sales Order Number
The default value is Customer Name.
Optionally, determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select a specific order type that you want printed in this report.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders selected based upon input parameters entered
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
Optionally, select the item to print for the report output.
Optionally, determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description.
Optionally, select a specific purchase order number or range of purchase order numbers you want printed in this report.
Optionally, select a specific requisition number or range of requisition numbers you want to print on this report.
The Sales Order and Purchase Order Discrepancy Report prints sales order and purchase order discrepancy details and displays the following 3 report sections sequentially for discrepancy selected.
Order Header Information
Order Line Information
Purchase Order/Requisition Information
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Internal Order and Purchasing Requisition Discrepancy Report displays the differences between the purchasing requisition entered and the actual items ordered in the during order entry. This report includes all open and closed orders, order numbers, order date ranges, order types, requisition numbers, items, ship to information, scheduled dates, and internal requisition and internal sales order hold discrepancies.
In the Order Management Reports window, select Internal Order and Purchasing Requisition Discrepancy Report in the Name field.
When you request a Internal Order and Purchasing Requisition Discrepancy Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order, enter the same order in the From/To fields.
Optionally, determine the report output sort option. Select from:
Order Number: Order Management sorts this report by the order number
Order Date: Order Management sorts this report by the order creation date associated with an order
Order Type: Order Management sorts this report by order type entered for the Sales Order Header
The default value is Order Date.
Optionally, determine whether to print all orders or only open orders. Select from:
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes.
Optionally, select a specific internal order number or range of internal order numbers you want printed in this report.
Optionally, determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description.
Optionally, select a specific internal order date or range of internal order dates you want printed in this report.
Optionally, select a specific internal order type or range of order types to include in this report.
Optionally, select a specific requisition number or range of requisition numbers to include in this report.
Optionally, select a specific internally order item or range of internally ordered items to include in this report.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Order Discount Detail Report reviews discounts applied to orders by order line detail. This report provides detailed line pricing information, including price list price, selling price, and discount information.
In the Order Management Reports window, select Order Discount Detail Report in the Name field.
When you request a Order Discount Detail Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order discount, enter the same order discount in the From/To fields.
Determine the report output sort option. Select from:
Customer Name: Order Management sorts this report by customer name, order number, return line number
Order Number: Order Management sorts this report by order number, line number
The default value is Customer. This field is required.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
Optionally, select a specific sales person or range of salespeople that you want printed in this report.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select a specific order type or range of order types on orders that you want printed in this report.
Optionally, select a specific order line type or range of order line types you want print in this report.
Optionally, enter a specific order number or range of order numbers that you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes. This field is required.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
The default value is All Orders.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is All Lines.
If you are printing this report in multiple currencies you can use Mixed Precision to ensure that all currency values align at the radix character for easy readability. Mixed precision is the distance between the radix (the decimal, or any dividing symbol between the whole and parts of the currency) and the right side of the column. It is right padded if the currency's standard precision is less than the mixed precision.
Order Management defaults this report parameter from the system profile option Currency: Mixed Currency Precision. This field is required.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional page breaks are provided for each order type selected by the report input parameters.
The Order Discount Summary Report reviews discounts applied to orders. This report provides order level pricing information, including agreement, salesperson and total order discount.
In the Submit Requests window, select Order Discount Summary Report in the Name field.
When you request a Order Discount Summary Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order discount, enter the same order discount in the From/To fields.
Determine additional report output sort options. The report output is always sorted alphabetically by Currency and within each currency, alphabetically by Order Type. The value selected for this parameter determines additional sorting within the currency/order type combination. Select from:
Customer: Order Management sorts this report by the customer name associated with an order
Order Number. Order Management sorts this report by order number
The default value is Order Number. This field is required.
Determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes. This field is required.
Select a specific customer name or range of customer names on orders you want printed in this report.
These fields are optional.
Optionally, select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
Optionally, select a specific sales person or range of salespeople that you want printed in this report.
Optionally, select the customer agreement that you want printed in this report.
Optionally, select a specific order type or range of order types on orders that you want printed in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select a specific order monetary amount or range of order total monetary amounts that you want printed in this report.
Optionally, select a specific order list process or range of total order list prices that you want printed in this report.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Unbooked Orders Report reviews orders you have entered but not booked.
In the Order Management Reports window, select Unbooked Orders Report in the Name field.
When you request a Unbooked Orders Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all unbooked orders that meet your other parameter criteria.
Determine additional report output sort options. The report output is always sorted alphabetically by Currency. The value selected for this parameter determines additional sorting within each Currency. Select from:
Created By: Order Management sorts the report by the user id associated with an unbooked order or order line
Order Number: Order Management sorts this report by order number, line number
The default value is Order Number. This field is required.
Optionally, enter a specific user id or range of user ids whose orders you want to print.
Optionally, enter the order date or range of order dates for the orders you want to print.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders selected based upon input parameters entered
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
The default value is Sales Order Only.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is Sales Order Lines only.
Optionally, determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description.
When you request a Unbooked Orders Detail Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report includes all unbooked orders that meet your other parameter criteria.
Determine additional report output sort options. The report output is always sorted alphabetically by Currency. The value selected for this parameter determines additional sorting within each Currency. Select from:
Created By: Order Management sorts the report by the user id associated with an unbooked order or order line
Manager: Order Management sorts this alphabetically by Manager Name (last name)
Order Number: Order Management sorts this report by order number, line number
The default value is Order Number. This field is required.
Optionally, enter a specific user id or range of user ids whose orders you want to print.
Optionally, enter the order date or range of order dates for the orders you want to print.
Optionally, select a specific order type or range of order types on orders that you want printed in this report.
Optionally, enter a manager name or range of manager names whose orders you want to print. Management names are derived from associations created in Oracle Human Resources when entering employee information.
Optionally, print unbooked order information in functional currency amounts of the ledger entered in for the report parameter.
Yes: print currency amounts in the functional currency for your ledger
No: print currency amounts in the functional currency for the order
The default value is No.
The Unbooked Orders Report displays summary order information by item for orders current not booked. For orders than contain more than one line, Order Management will display summary order information for each order line.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed prior to the next order selected
Page breaks are provided for each order Currency selected by the report input parameters.
The Cancelled Orders Report reviews all orders that have been cancelled. This report provides a summary of each cancelled order, including order number, customer name, line number and item, the date, and the quantity cancelled.
This report can be used to report total dollars cancelled in a specified time-frame, and enable you to evaluate the most common cancellation reasons, review cancellations by salesperson, or review cancellations by customers.
In the Order Management Reports window, select Cancelled Orders Report in the Name field.
When you request a Cancelled Orders Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all cancelled orders that meet your other parameter criteria. In order to obtain a single cancelled order, enter the same cancelled order in the From/To fields.
Determine the report output sort option. Select from:
Customer: Order Management sorts this report by the customer name associated with an order
Order Date: Order Management sorts this report by the order creation date associated with an order
Order Number: Order Management sorts this report by order number, line number
Salesperson: Order Management sorts this report by salesperson, order number, line number
The default value is Customer. This field is required.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific sales person or range of salespeople that you want printed in this report.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select the item that you want printed in this report.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders selected based upon input parameters entered
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
The default value is Sales Orders Only.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is Sales order Lines only.
Optionally, determine whether to print report output information in the functional currency for the ledger from the operating unit the report is submitted from
Yes: print currency amounts in the functional currency for your ledger
No: print currency amounts in the functional currency for the order
The default value is No.
If you are printing this report in multiple currencies you can use Mixed Precision to ensure that all currency values align at the radix character for easy readability. Mixed precision is the distance between the radix (the decimal, or any dividing symbol between the whole and parts of the currency) and the right side of the column. It is right padded if the currency's standard precision is less than the mixed precision.
Order Management defaults this report parameter from the system profile option Currency: Mixed Currency Precision. This field is required.
The Cancelled Orders Report displays the following 2 report sections sequentially for each order selected.
Order Header Information
Order Line Details
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Use the RetroActive Billing report to view orders that have been created as the result of a Retrobilling Preview action. This report provides you with the information needed to identify down to the specific customer/destination/order/item those orders that are going to be retro-billed. You run this report from the Standard Report Submission window.
Grouping invoice lines by destination, you can review the following information:
Item
Shipped quantity
Retrobilled quantity
Invoiced unit price
Extended price
If the item is taxed
New unit price
New extended price
Variance in unit price
Variance in extended price
The RetroActive Billing Report contains the following parameters. If you leave any parameters blank, this report includes all orders that meet your other parameter criteria.
The following report parameters are used to specify the desired reporting for sequenced items.
Choose the request name to print in this report.
Choose Description or Flexfield depending on how the item name or description is to print in this report under the Item column heading. The default value is Description.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
Choose how report should be sorted. Valid choices are: Customer/Address, Invoice Number, Item, and Order Number. The default value is Item.
Report headings provide you with general information about the contents of your report such as company date, report title, date and time you run the report and page number.
When multiple items are selected the item appears as ITEM: xxxxxxxxxxxx on a single line indicating that all information listed below until the next item ITEM: xxxxxxxxxxxx appears pertains to it.
The customer appears in the same column as the item but just below it. Just below that is the address.
The order numbers that are eligible for retro-billing in the specified time period.
The date of the order.
The invoice number.
Is this item on this order taxable.
Number of items shipped on this order.
Number of items retrobilled on this order.
Unit price applied to this order at Invoice time.
Shipped Quantity times the Invoiced Unit Price.
The new Unit price applicable to this order.
Shipped Quantity times the Invoiced unit Price.
The difference of the New Unit Price minus Invoice Unit Price.
The difference of the New Extended Price minus Invoiced Unit Price. This would be the applicable sum for retro-billing on the specified order.
The Returns by Reason Report reviews all return material authorizations for various return reasons. Order Management automatically sorts this report by currency, return reason, and then item.
In the Order Management Reports window, select Returns by Reason Report in the Name field.
When you request a Returns by Reason Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all returns that meet your other parameter criteria. In order to obtain a single return, enter the same return in the From/To fields.
Optionally, select the return reason that you want printed in this report.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select the credit order type to include in this report.
Optionally, select the order line types to include in this report.
Optionally, enter the item or a partial item value (with wildcard) you want order return lines printed for in this report.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
If you are printing this report in multiple currencies you can use Mixed Precision to ensure that all currency values align at the radix character for easy readability. Mixed precision is the distance between the radix (the decimal, or any dividing symbol between the whole and parts of the currency) and the right side of the column. It is right padded if the currency's standard precision is less than the mixed precision.
Order Management defaults this report parameter from the system profile option Currency: Mixed Currency Precision. This field is required.
The report output is sorted alphabetically by Currency.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
Page breaks are provided for each order Currency selected by the report input parameters.
The Cancelled Orders Reasons Detail Report displays the reasons for the cancelled lines and who entered the cancellation.
In the Order Management Reports window, select the Cancelled Orders Reasons Detail Report in the Name field.
When you request a Cancelled Orders Reasons Detail Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all cancelled order details that meet your other parameter criteria. In order to obtain a single cancelled order detail, enter the same cancelled order detail in the From/To fields.
Determine the report output sort. Select from:
Order Number: Order Management sorts this report by the order number
Order Date: Order Management sorts this report by the order creation date associated with an order
Item: Order Management sorts this report by the name or description of the credit item, depending on your selection for the Item Display input parameter
Salesperson: Order Management sorts this report by order salesperson
Customer: Order Management sorts this report by the customer name
Cancel date: Order Management sorts this report by the order cancel date
Cancel reason: Order Management sorts this report by the cancel reason name
Cancelled by: Order Management sorts this report by the user id of the person who cancelled the order number
The default value is Cancel Reason. This field is required.
Optionally, select the reason for cancellation.
Optionally, select a specific cancel date or range of cancel dates to include in this report.
Optionally, select a specific cancelled by user id or range of cancelled by user ids to include in this report.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific sales person or range of salespeople to include in this report.Orders will be summarized by association between SalesPerson and Sales Order Header only.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, enter the item number to include in this report.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders selected based upon input parameters entered
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
The default value is Sales Orders Only.
Optionally, determine the types of order lines you wish to print. Select from:
All Lines: Order Management will display all Sales Order Lines on the report output
Credit Order Lines only: Order Management will display only Return Orders that have at least one sales order return line on the report output
Sales order Lines only: Order Management will display only Sales Orders that have at least one sales order line on the report output
The default is Sales Order Lines only.
Optionally, determine whether to print report output information in the functional currency for the ledger from the operating unit the report is submitted from
Yes: print currency amounts in the functional currency for your ledger
No: print currency amounts in the functional currency for the order
The default value is No.
If you are printing this report in multiple currencies you can use Mixed Precision to ensure that all currency values align at the radix character for easy readability. Mixed precision is the distance between the radix (the decimal, or any dividing symbol between the whole and parts of the currency) and the right side of the column. It is right padded if the currency's standard precision is less than the mixed precision.
Order Management defaults this report parameter from the system profile option Currency: Mixed Currency Precision. This field is required.
The Cancelled Orders Reasons Detail Report displays the following 2 report sections sequentially for each order selected.
Order Header Information
Order Line Details
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
The Agreement Activity Report reviews order line details that include agreement name defined in Order Management.
In the Order Management Reports window, enter Agreement Activity Report in the Request Name field.
When you request an Agreement Activity Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all agreements that meet your other parameter criteria. In order to obtain a single Agreement for the report output, enter the same Agreement Name in the Agreement Low/High fields.
Choose the agreement(s) that you want printed in this report.
Choose the customer(s) that you want printed in this report.
Choose the agreement type that you want printed in this report.
Choose the purchase order numbers for the orders for the agreements that you want printed in this report.
Choose the salesperson that you want printed in this report.
Choose Yes if you want to print any currency amounts in the functional currency for your ledger, or No if you want to print any currency amounts in the currency for the order.
The default value is No.
The Agreement Activity Report prints comprehensive Agreement order line details. Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Page breaks are provided for each currency/customer combination selected by the report input parameters. Additional page breaks occur for each currency selected by the report input parameters.
Page breaks are provided for each unique Agreement Name /Customer name combination selected.
The Orders Summary Report provides a one-line order summary by currency and order type. The report enables you to quickly summarize orders by entities such as customer or salesperson and can be used to supplement on-line inquires via the Sales Order Organizer.
In the Order Management Reports window, select Orders Summary Report in the Name field.
When you request a Orders Summary Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all orders that meet your other input parameter criteria. In order to obtain a entity, enter the same value in the in the From/To fields.
Determine additional report output sort options. The report output is always sorted alphabetically by Currency and within each Currency, alphabetically by Order Type. The value selected for this parameter determines additional sorting within the currency/order type combination. Select from:
Agreement Name: Order Management sorts the report by the agreement name associated with an order
Customer: Order Management sorts this report by the customer name associated with an order
Order Date: Order Management sorts this report by the order creation date associated with an order
Purchase Order: Order Management sorts this report by the purchase order number (if present) associated with an order
Salesperson: Order Management sorts this report by the salesperson (if present) associated with an order
The default value is Order Date. This field is required.
Optionally, select a specific customer name or range of customer names whose orders you want to print.
Optionally, select a specific salesperson (by name) or range of salespeople whose orders you want to print. Orders will be summarized by association between SalesPerson and Sales Order Header only.
Optionally, select a specific order date or range of order dates for orders you want to print.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific ship-to country or range of ship-to countries whose orders you want to print.
Optionally, select a specific order type or range of order types that you want to print.
Optionally, select a specific customer PO number or range of customer PO numbers that you want to print. Orders will be summarized by association between Customer PO number and Sales Order Header only.
Optionally, enter a single created by user id (by name) or range of users ids whose orders you want to print. Orders will be summarized by the user id associated with the Sales Order Header creation date only.
Optionally, enter an original system document reference for orders you want to print.
Determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes. This field is required.
Optionally, print order information in functional currency amounts of the ledgers entered in for the report parameter.
Yes: print currency amounts in the functional currency for your set of book
No: print currency amounts in the functional currency for the order
The default value is No.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
Page breaks are provided for each Currency/Order Type combination selected by the report input parameters.
The Order/Invoice Summary Report reviews summary invoice information about orders that have invoiced, including ordered amount, invoiced amount, adjusted receivables, and balance due. Order Management automatically sorts this report by order type and lists all orders that have been invoiced.
Warning: Non-invoiced orders print which display a zero (0) balance due. Non-invoiced orders display the message, No Invoices Exist For This Order.
In the Order Management Reports window, select Order/Invoice Summary Report in the Name field.
When you request a Order/Invoice Summary Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order, enter the same order in the From/To fields.
Determine the report output sort option. Select from:
Customer: Order Management sorts this report by the customer name
Order Type: Order Management sorts this report by order type
Salesperson: Order Management sorts this report by order salesperson
The default value is Customer. This field is required.
Determine whether to print all orders or only open orders.
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes.This field is required.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific sales person or range of salespeople that you want printed in this report.
Optionally, select a specific order type or range of order types on orders that you want printed in this report.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select the country for the ship to addresses of the shipments you want printed in this report.
Optionally, determine whether to print report output information in the functional currency for the ledger from the operating unit the report is submitted from
Yes: print currency amounts in the functional currency for your ledger
No: print currency amounts in the functional currency for the order
The default value is No.
This report is automatically sorted by order number, order date, bill-to address, ship-to address, and salesperson. If invoice information is not available for orders selected, Order Management will provide the following information.
Order Number: Order Management prints the order number for each order selected
Order Date: Order Management prints the order date for each order selected
Customer Name: Order Management prints the associated Customer Name for each order selected
Message text: *** No invoices exist for this Order ***
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
Page breaks are provided for each Currency selected by the report input parameters. Additional page breaks are provided for each customer/currency combination selected by the report input parameters.
The Salesperson Order Summary Report reviews orders for one or more salespeople. This report displays the order and each order line associated with each salesperson.
Your salespeople can use this report to see their current outstanding orders and their status. This report shows open orders, quantity ordered, shipped, cancelled, and invoiced and their potential commission.
The report displays all open and closed orders for a salesperson, customer or customer number, agreements, order numbers, order date ranges, order types, line type, and detailed sales credit information for lines in a selected range.
In the Order Management Reports window, select Salesperson Order Summary Report in the Name field.
When you request a Salesperson Order Summary Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all orders that meet your other parameter criteria. In order to obtain a single order, enter the same order in the From/To fields.
Determine additional report output sort options. The report output is always sorted alphabetically by Salesperson. The value selected for this parameter determines additional sorting within each Salesperson. Select from:
Customer: Order Management sorts this report by the customer name
Order Number: Order Management sorts this report by the order number
The default value is Order Number. This field is required.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific order date or range of order dates you want printed in this report.
Optionally, select the order type that you want to print in this report.
Optionally, select the order line type to you want to include in this report.
Optionally, select the customer agreement that you want to print in this report.
Optionally, select a specific sales person or range of salespeople that you want to print in this report.
Optionally, select a specific customer name or range of customer names on orders you want printed in this report.
Optionally, select a specific customer number or range of customer numbers you want printed in this report. Ensure the value entered within the Customer Number To field is greater than the value entered in the Customer From field or the report output may complete with errors.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
The default value is Sales Orders Only.
Optionally, determine whether to print all order lines or only credit order lines. Select from:
All Lines: Display all order lines
Credit Order Lines Only: Display only return lines
Sales Order Lines Only:
The default is Credit Order Lines Only.
Determine how you wish to display item information for the report output. Select from:
Both: Order Management will print both the Internal Item name and the internal item description (item as defined within the Master Items window)
Description: Order Management will print only the Internal Item description
Flexfield: Order Management will print only the Internal Item name
Item and Description: Order Management will print both the ordered item name and the associated ordered item description
Ordered Description: Order Management will print only the ordered item description
Ordered Item: Order Management will print only the ordered item
The default value is Description. This field is required.
If you are printing this report in multiple currencies you can use Mixed Precision to ensure that all currency values align at the radix character for easy readability. Mixed precision is the distance between the radix (the decimal, or any dividing symbol between the whole and parts of the currency) and the right side of the column. It is right padded if the currency's standard precision is less than the mixed precision.
Order Management defaults this report parameter from the system profile option Currency: Mixed Currency Precision. This field is required.
Determine whether to print all orders or only open orders. Select from:
No: Include both open and closed orders to print
Yes: Include only open orders to print
The default value is Yes. This field is required.
Determine whether to print report output information in the functional currency for the ledgers from the operating unit the report is submitted from
Yes: print currency amounts in the functional currency for your ledger
No: print currency amounts in the functional currency for the order
The default value is No. This field is required.
The Salesperson Order Summary Report prints sales order details specific to a salesperson. The report is automatically sorted by Salesperson, then within Salesperson, by the value selected for the input parameter Sort By, and displays the following 4 report sections sequentially for each order selected.
Order Header Information
Order Sales Credit Information
Order Line Details
If no information exists for any of the sections above, Order Management will not print the column headings for the sections
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
Additional report summary information is also printed.
Page breaks are provided for each Salesperson selected by the report input parameters.
The Audit History Report displays recorded audit history details captured for updates to orders based upon your current audit history processing constraint definitions.
Note: You must successfully submit the Audit History Consolidator program at least once to display Audit History details within Audit History Report output or you will receive the message No Data Found.
When you request the Audit History Report, Order Management provides you with the following parameters. If you leave any of the non-required parameters blank, this report displays the history changes of all attributes.
Note: It is recommended to provide at least Entity and Attribute input parameters for the report to reduce report processing run times.
Select a History Date From, a History Date To, or a combination of History Date From and History Date to limit Audit history output details to order updates within a specific time period.
History Date From is required, History Date To is optional.
Select the constrained entity you want to print in this listing.
Line Price Adjustment
Line Sales Credit
Order Header
Order Line
Order Price Adjustment
Order Sales Credit
This field is optional.
Optionally, select an accompanying level attribute to limit Audit History output details. You must select an entity before choosing a level attribute.
Optionally, enter a specific order number or range of order numbers you want printed in this report. These fields accept any integer value, without validation against available order numbers.
Optionally, select a specific user name to limit Audit History output details to all order updates performed by a single user.
Optionally, select a specific responsibility to limit Audit History output details to all order updates performed by users within a responsibility.
The report output is always sorted by effectivity date changed, order number, entity, and attribute.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Defaulting Rules Listing Report displays the defaulting rules you have defined for various objects and attributes in Order Management. This listing includes objects, conditions, attributes, and seeded data.
Please note that for this Order Management report, the output display layout for report columns is designed so that the columns expand vertically and their horizontal width remains the same.
In the Order Management Reports window, select Defaulting Rules Listing in the Name field.
When you request a Defaulting Rules Listing Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all defaulting rules that meet your other parameter criteria. In order to obtain a single defaulting rule, enter the same defaulting rule in the From/To fields.
Select the object that you want listed in the report output. Select from:
Header Pricing Attrs
Header Qualifier Attrs
Line Price Adjustment
Line Pricing Attrs
Line Qualifier Attrs
Line Sales Credit
Order Header
Order Line
Order Price Adjustment
Order Sales Credit
This field is optional.
Select the condition that you want printed in this report. The LOV for the Condition field is based upon the value selected for the input parameter Object.
If you select an value for the Object parameter, you can select an associated attribute to limit the report output listing selected for the Object.
This field is optional.
Determine if you wish to display seeded values or non seeded defaulting rules in the report output listing. Select from:
Yes: Displays only seeded defaulting rules in this report
No: Displays only non-seeded defaulting rules in this report
This field is optional.
Note: If you leave this parameter blank, both seeded and non-seeded values are listed in the report.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Processing Constraints Listing report lists all processing constraints and the corresponding constrained entities, constrained attributes, constrained operations, validation entities, record sets, validation templates and responsibility to which this constraint is applicable.
In the Order Management Reports window, select Processing Constraints Listing in the Name field.
When you request a Processing Constraints Listing, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all processing constraints that meet your other parameter criteria. In order to obtain a single processing constraint, enter the same processing constraint in the From/To fields.
Optionally, select the constrained entity you want to print in this listing.
Line Price Adjustment
Line Sales Credit
Order Header
Order Line
Order Price Adjustment
Order Sales Credit
Optionally, select the processing attribute that you want to print in this listing. You must select an entity before choosing an attribute.
Optionally, select the operation that you want to print in this listing. Select from:
Cancel
Delete
Insert
Split
Update
Note: This field is only enabled if the Attribute is disabled.
Optionally, select the validation entities that are based on the processing constraint conditions to print in this listing.
Note: This field is only enabled if the Object is selected.
Optionally, select the record set parameter to include the processing constraints that have conditions based on the record set to print in this listing.
Optionally, select the validation template parameter to include processing constraints that have conditions using the validation template.
Note: This field is only enabled if the Validation Entity is selected.
Optionally, determine if you wish to display seeded values or non seeded values for this report. Select from:
Yes: Displays only seeded values in this report
No: Displays only non-seeded values in this report
Note: If you leave this parameter blank, both seeded and non-seeded values are printed in this report.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
See: Oracle Order Management Implementation Manual, Defining Processing Constraints.
The Transaction Types Listing Report lists displays the OM transaction types of orders and order lines and the attributes and controls for transaction types.
In the Order Management Reports window, select Transaction Types Listing Report in the Name field.
When you request a Transaction Types Listing Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all transaction types that meet your other parameter criteria. In order to obtain a single transaction type, enter the same transaction type in the From/To fields.
Optionally, select a specific Order Management transaction type name or range of Order Management transaction type names you want printed in this listing.
Optionally, select the transaction type code for an order or order line.
Optionally, determine the types of orders you wish to print. Select from:
All Orders: Include all orders
Credit Orders Only: Include only orders that at least one return line
Sales Orders Only: Include only orders that at least one sales order line
Note: If the transaction type code is Order, possible values include Order, Return, or Mixed. If the transaction type code is Line, possible values include Order or Return.
The report output is sorted alphabetically by object name, and within each object name alphabetically by attribute name.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Item Orderability Rules Listing Report displays the item orderability rules for a selected item or category.
In the Order Management Reports window, select Item Orderability Rules Listing Report in the Name field.
When you request an Item Orderability Rules Listing Report, Order Management provides you with the following parameters. If you leave any parameters blank, this report includes all item orderability rules that meet your other parameter criteria.
You can select either Item or Category from this LOV. If you select Item, you need to specify an item in the next field Item, or if you select Category, you need to specify Category details.
Specify an item number in the flexfield that displays. You will also be prompted to enter Category details, however you can click Cancel to bypass entering Category details since Item details are necessary only. This is relevant only if you have selected Item in the Item Level parameter.
If you have selected Category in the Item Level parameter, you will be prompted for the Category details. Enter values in the Family and Class flexfields to complete the parameter details for Category.
Select Yes or No to specify general availability.
The report output is sorted alphabetically by object name, and within each object name alphabetically by attribute name.
Order Management displays all report input parameters and respective input values selected on the first page of the report output.
The Order Line Transaction Count Summary and Order Line Transaction Count Comparison Reports are not intended for general usage. Both reports are for internal purposes only, and are not supported by Oracle.