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

Last updated on JUNE 12, 2017

Applies to:

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

Goal

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
order by DOC_SEQUENCE_VALUE

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

 

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

Solution

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