Transaction Audit Trail Screen Throws "Invalid Input Parameters" Error for Transactions Without Revisions
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.
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.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.
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