Audit Report by Document Sequence (ARXINVAD) does not display who/when the receipt number has been deleted
Last updated on JUNE 12, 2017
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).
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?
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