Non-Merch SKU Not Updating Dept/Class/Subclass on SA_TRAN_ITEM Table When Changed
Last updated on APRIL 08, 2016
Applies to:Oracle Retail Sales Audit - Version 14.1 and later
Information in this document applies to any platform.
In Oracle Retail Sales Audit (ReSA) 14.1.x, Non-merch SKU is not updating Dept/Class/Subclass on SA_TRAN_ITEM table when changed from 'Transaction Maintenance' window.
Steps to Reproduce:
- Log in in ReSA and go to Operations -> Manage Transaction -> Enter ReSA Tran. No. to edit transaction.
- In 'Transaction Maintenance' window, under 'Items' section, modify non-merchandise SKU to another non-merch SKU with a different merchandise hierarchy.
- Save and close the transaction.
- Go into SA_TRAN_ITEM table and note that the department, class, and subclass have not been updated.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms