Non-Merch SKU Not Updating Dept/Class/Subclass on SA_TRAN_ITEM Table When Changed

(Doc ID 2124085.1)

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:

  1. Log in in ReSA and go to Operations -> Manage Transaction -> Enter ReSA Tran. No. to edit transaction.
  2. In 'Transaction Maintenance' window, under 'Items' section, modify non-merchandise SKU to another non-merch SKU with a different merchandise hierarchy.
  3. Save and close the transaction.
  4. 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