My Oracle Support Banner

Audit Report by Document Sequence (ARXINVAD) does not display who/when the receipt number has been deleted (Doc ID 1580829.1)

Last updated on OCTOBER 22, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


Sometimes there were some document number in AR skipped. e.g. 1, 2, 4, 5, 8 (3,6,7 missed) in Audit Report by Document Sequence (ARXINVAD).
For example:

1. From Audit Report:

11410470           Not Entered
11410471 27-JAN-13 Deleted    
11410472           Not Entered
11410473 27-JAN-13 Deleted    
11410474           Not Entered
11410475 27-JAN-13 Deleted    

2. select * from AR_DOC_SEQUENCE_AUDIT

11410470, 11410472, 11410474 were missing.
11410471, 11410173, 11410475 is there.


How to find out the receipt number that are deleted and who deleted it?


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.