Transaction Audit Trail Screen Throws "Invalid Input Parameters" Error for Transactions Without Revisions (Doc ID 2244957.1)

Last updated on MARCH 22, 2017

Applies to:

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

Symptoms

ReSA (Retail Sales Audit) Transaction Audit Trail screen throws the following error for a transaction having no revision:


Steps to Reproduce:

1. Retrieve any transaction that has no revisions and tran_type is either sales or return in ReSA SA_TRAN_HEAD table.
Example: select * from sa_tran_head where rev_no = 1 and tran_type IN ('SALE','RETURN') and tran_seq_no = 11111;

2. Open the transaction maintenance [satrfind] screen in edit mode using the transaction sequence number retrieved in step 1.
2.1. Action.
2.2. Sales Audit.
2.3. Additional Operations.
2.4. Transaction Maintenance screen.
2.5. Select Edit in Action field, Enter the ReSA transaction number, and then press Tab on keyboard. Then click OK.
3. Notice that the Audit Trail button is not grayed out even though the transaction has no revision.
4. Click on the Audit Trail button and notice the error.

Changes

 

Cause

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