Oracle Retail Sales Audit (ReSA) Product Overview
(Doc ID 1554852.1)
Last updated on MARCH 11, 2021
Applies to:Oracle Retail Sales Audit - Version 13.1 and later
Information in this document applies to any platform.
Oracle Retail Sales Audit is an agile tool that evaluates all sales transaction from all channels, ensuring clean and consistent sales information. With a highly configurable and integrated sales audit solution, the retailer can maintain existing business practices while providing for future options as the operations grow and change and have full visibility to point-of-sale information to support compliance objectives. The solution identifies any missing, duplicate or erroneous data, highlights any suspicious transactions and ensures errors are resolved so that all downstream systems operate off the same cleansed sales information.
- Trickle Polling of Point-of-Sale Data. Sales Audit has the ability to process point of sale information from selling locations multiple times throughout the day according to the retailer’s requirements. The retailer can also define the frequency of when sales data is sent to downstream applications. Certain downstream systems, like merchandising, often receive sales data in near real time, whereas more analytical systems, like the data warehouse, may wait for the daily audited sales.
- Multi and Single-Level Auditing. The solution provides retailers with the option to perform auditing at the Store, Corporate Headquarters, or both. By using these different levels and the exception definitions, a workflow for error resolution is clearly established.
- Security Controls. The retailer defines the actions that are available to Store and Headquarter users. Store users only see their particular Store information, whereas Headquarter users generally have the ability to view multiple stores as well as change more information. Audit rule exceptions are defined so that anomalies can be quickly identified and resolved by the appropriate resources. In certain areas, Sales Audit also provides field level security by Oracle role to ensure complete integrity.
- Automatic Totaling of Point-of-Sale Transactions. The Sales Audit totaling process allows retailers to sum or count any data in the system. The totals can be used to roll-up information for export to downstream systems, facilitate loss-prevention analysis or simply for reporting. Users create the totals via a wizard that guides them through the process. Totals such as Over/Short, allow users to compare the declared totals from the POS with the system calculated totals and enter corrective information. Combined totals are sums of existing totals, which are often useful for more complex analysis or aggregation.
- Retailer-defined Audit Rules and Exceptions. Audit rules are applied against retailer defined totals and transaction data to identify exceptions for further research. While some rules are inherent in the system, like unidentified SKU transactions, others are completely defined by the retailer via a wizard. The rules and their corresponding errors, provide the ability to easily identify any anomalies, which allows the users to focus on exceptions rather than sifting through vast amounts of data. The rule definition determines who receives the exception, the impact of the error, whether it can be overridden, and also provides a recommended resolution.
- Customer Reservation and Layaway – As the variety of purchase options change, retailers need to account for them accurately. Sales Audit plays a role by integrating the activity at the POS with the merchandising and store inventory management systems. Whether the customer purchases online for home delivery, online for store pickup or in a store for pickup at a later date, Sales Audit accounts for the appropriate reservation of inventory, creation of liability and subsequent release with the recognition of the sale at time of pick-up or delivery.
- Automated Clearing House (ACH) Deposit Processing. Sales Audit calculates estimated store deposits for the following business day based on deposit history data. These calculations can be sent to the consolidating bank in the National Automated Clearing House Association (NACHA) file format.
- Integration. Oracle Retail Sales Audit shares core foundation elements such as items, locations, pricing, and tax information with the Oracle Retail Merchandising System. Transactions, including key totals, are integrated with the POS, Store Inventory Management
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document