This chapter describes the steps to view the RMS Business Intelligence (BI) Publisher reports by accessing Reports from the Tasks menu in the Oracle Retail Merchandising System (RMS) application.
Depending on the report, you can use prompts to select report Parameters.
Some prompts allow you to filter the report contents and limit the information in the report. For example, you can filter on Dept or Item to filter the content of the Pick List report.
Some reports require a parameter, such as a letter of credit ID.
Some reports require no parameters, and no prompts are displayed.
Select values as needed from the list for the prompts displayed.
Select the report output you may want to view.
HTML (default, Web page format)
PDF (Adobe Acrobat Portable Document Format)
RTF (Rich Text Format, used by Microsoft Word and other programs)
Excel (Microsoft Excel format)
PowerPoint (Microsoft PowerPoint format)
CSV (comma-separated values file)
Data (XML)
Note: Not all output formats may be available. |
Click View. The report is displayed in Oracle BI Publisher.
(If you select another output format, you have the option to save the report to disk. You can also open the report with another program, such as Microsoft Excel).
Close the browser window when you are finish viewing, printing, or saving the report.
The RMS BI Publisher reports are as follows:
Daily Purge Report
Mass Item Change Rejection
Cost Change Conflicts
Franchise Item Catalog
Orders
Order Details
Open Orders
Open to Buy Summary
Order Redistribution
Supplier Compliance Order Summary
Inventory
Transfer Details
Open Stock Orders
Bill of Lading Manifest
Stock Order Pick List
Inbound Purchase Orders
Inventory Adjustments
Missing Stocktake Results
Stock Count Worksheet
Off Retail Sales
Import Management
HTS Mass Update Impact
Letter of Credit Details
Letter of Credit Amendments
Finance
Financial Transaction Data
Fixed Deal Transaction Data
Division Year End Valuation
Department Year End Valuation
A regularly scheduled batch program deletes records that you have marked for deletion. Some records may not be deleted if the system determines that the record is still in use in RMS. If an item is marked for deletion the dlyprg.pc program checks that the item was not put on order later in the day. If the relations are found to exist, a record is written to an error table (DAILY_PURGE_ERROR_LOG).
You can enter a request in RMS to make the same change to multiple items. The Mass Item Change Rejection report lists those changes that are rejected by the system and why the request could not be completed.
The Cost Change Conflicts report identifies any conflicting cost changes that are entered into the system.
The Franchise Item Catalog report lists the items available for sale to wholesale stores, showing the current cost and suggested retail for each item.
The Orders report are as follows:
Order Details
Open Orders
Open to Buy Summary
Order Redistribution
Supplier Compliance Order Summary
To view the order details report:
From the Tasks menu, select Reports > Orders > Order Details. The Order Details Report window appears.
The Open Orders report shows details about purchase orders that are not fully received.
To view the open orders report:
From the Tasks menu, select Reports > Orders > Open Orders. The Open Orders Report window appears.
The Open to Buy Summary report shows open-to-buy and related information by week for a selected department, class, or subclass for a selected time period.
To view the open to buy summary report:
From the Tasks menu, select Reports > Orders > Open to Buy Summary. The Open to Buy Summary Report window appears.
The Order Redistribution report shows open-to-buy and related information by week for a selected department, class, or subclass for a selected time period.
To view the order distribution report:
From the Tasks menu, select Reports > Orders > Order Redistribution. The Order Redistribution Report window appears.
The Inventory report are as follows:
Transfer Details
Open Stock Orders
Bill of Lading Manifest
Stock Order Pick List
Inbound Purchase Orders
Inventory Adjustments
Missing Stocktake Results
Stock Count Worksheet
Off Retail Sales
The Transfer Details report displays the details the details of a given transfer.
To view the transfer details report:
From the Tasks menu, select Reports > Inventory > Transfer Details. The Transfer Details Report window appears.
The Open Stock Orders report shows information about open transfers and allocations that have been shipped. Optionally, the report can include information about transfers and allocations that have been approved but not yet shipped.
To view the open stock orders report:
From the Tasks menu, select Reports > Inventory > Open Stock Orders. The Open Stock Orders Report window appears.
The Bill of Lading Manifest report displays relevant information for each item on a bill of lading, such as the quantity, unit cost, and unit retail price for each item.
To view the bill of lading manifest report:
From the Tasks menu, select Reports > Inventory > Bill of Lading Manifest. The Bill of Lading Manifest Report window appears.
The Stock Order Pick List report shows items and quantities to be picked in the specified warehouse for outbound transfers and allocations.
To view the stock order pick list report:
From the Tasks menu, select Reports > Inventory > Stock Order Pick List. The Stock Order Pick List Report window appears.
The Inbound Purchase Orders report shows details about inbound purchase order shipments for a specified time range and location. The warehouse can use this report along with the Open PO report to aid in creating schedules.
To view the inbound purchase orders report:
From the Tasks menu, select Reports > Inventory > Inbound Purchase Orders. The Inbound Purchase Orders Report window appears.
The Inventory Adjustments report displays items that exceed the unit, cost, or retail stocktake variance system settings.
To view the inventory adjustments report:
From the Tasks menu, select Reports > Inventory > Inventory Adjustments. The Inventory Adjustments Report window appears.
The Missing Stocktake Results report identifies the locations where a stock count is scheduled for the current week but for which stock count data has not yet been entered into the system.
To view the missing stocktake results report:
From the Tasks menu, select Reports > Inventory > Missing Stocktake Results. The Missing Stocktake Results Report window appears.
The Stock Count Worksheet report lists the items that are to be counted at a location on a specified date. You can enter the results of the physical count next to each item on the worksheet.
To view the stock count worksheet report:
From the Tasks menu, select Reports > Inventory > Stock Count Worksheet. The Stock Count Worksheet Report window appears.
The Import Management report are as follows:
HTS Mass Update Impact
Letter of Credit Details
Letter of Credit Amendments
The HTS Mass Update Impact report lists the items and purchase order/items that were affected by a change in the harmonized tariff schedule.
To view the HTS mass update impact report:
From the Tasks menu, select Reports > Import Management > HTS Mass Update Impact. The HTS Mass Update Impact Report window appears.
The Letter of Credit Details report displays the details of a given letter of credit.
To view the letter of credit details report:
From the Tasks menu, select Reports > Import Management > Letter of Credit Details. The Letter of Credit Details Report window appears.
The Finance report are as follows:
Financial Transaction Data
Fixed Deal Transaction Data
Department Year End Valuation
The Financial Transactional Data report shows the transaction history of the accounting entry detail by item and location.
To view the financial transaction data report:
From the Tasks menu, select Reports > Finance > Financial Transaction Data. The Financial Transaction Data Report window appears.
The Fixed Deal Transaction Data report shows the fixed deal data for accounting entry by deal and supplier.
To view the fixed deal transaction data report:
From the Tasks menu, select Reports > Finance > Fixed Deal Transaction Data. The Fixed Transaction Data Report window appears.
The Division Year End Valuation Report shows the inventory valuation for a fiscal year at the location and division level.
To view the division year end valuation report:
From the Tasks menu, select Reports > Finance > Division Year End Valuation. The Division Year End Valuation Report window appears.