My Oracle Support Banner

Why is Audit Report by Document Sequence (ARXINVAD) Not Displaying Who/When the Receipt Number has Been Deleted? (Doc ID 1580829.1)

Last updated on AUGUST 07, 2020

Applies to:

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

Goal

How to find the receipt number(s) that are deleted and who deleted it?

Sometimes there are some document numbers being skipped.

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.


Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.