My Oracle Support Banner

ReSA Transaction Detail Screen Allows User to Enter and Commit Invalid Salesperson Value (Doc ID 2168657.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Retail Sales Audit - Version 14.0.3 and later
Information in this document applies to any platform.


The Transaction Detail [satrdetl] screen in Retail Sales Audit (ReSA) allows the user to exit after entering an invalid value for salesperson.

Steps to Reproduce:

  1. Set up AUTO_VALIDATE_TRAN_EMPLOYEE_ID (auto validation of employees) to 'Y' in SYSTEM_OPTIONS.
  2. Upload a RTLOG transaction such that it contains an invalid salesperson ID at line item level.
  3. Go to Error List [saerrlst] screen and note that transaction is in error due to invalid salesperson.
  4. Press on 'Fix Error' and go to Transaction Detail screen -> Employee tab.
  5. Enter an invalid value for the salesperson manually.  Do not select from LOV.  Press tab.
  6. Note that screen displays message "The entered salesperson is not a valid employee for this store".
  7. Press OK on the error message and then OK on Transaction Detail screen.
  8. Note that the user is allowed to exit, and the invalid value is updated to SA_TRAN_ITEM table.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.