My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

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.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.


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.