EAP: Gaps in the Document Sequencing Numbering feature (PS_VCHR_DOCSEQ_HDR) and no rows are inserted into the PS_SEQ_NBR_DEL_TBL for the missing Document Sequencing Number (Doc ID 1600946.1)

Last updated on APRIL 01, 2024

Applies to:

Symptoms

Gaps in the Document Sequencing Numbering feature (PS_VCHR_DOCSEQ_HDR) and no rows are inserted into the PS_SEQ_NBR_DEL_TBL for the missing Document Sequencing Number.

STEPS
1.  On the Set Up Financials/Supply Chain > Install > Installation Options > Overall page, box for "Enable Document Sequencing" is checked
2.  On the Set Up Financials/Supply Chain > Install > Business Unit Related > General Ledger > General Ledger Definition > Definition page, box for "Enable Document Sequencing" is checked
3. Create a Voucher and save it
4.  On the Voucher > Invoice Information page, click on the Document Sequence hyperlink to display the Document Sequence page
5.  On the Document Sequence page, Document Sequence Number = 201309000002, which is correct
6.  Query PS_VCHR_DOCSEQ_HDR --  DOC_SEQ_NBR = 201309000002 for the Voucher created
7.  Re-display the Voucher and access the Document Sequence page
8.  On the Document Sequence page, erase "AP-DOM" from the Document Type field
9.  Tab out of the Document Type field -- Once this is done, the fields of Document Type, Journal Code, Document Sequence Number and Document Sequence Date are blanked out
10.  On the Document Sequence page, re-enter the Document Type = AP-DOM
11.  Save the Voucher
12.  On the Voucher > Invoice Information page, click on the Document Sequence hyperlink
13.  On the Document Sequence page, Document Sequence Number = 201309000003, which is a new Document Sequencing Number
14.  Query PS_VCHR_DOCSEQ_HDR
15.  DOC_SEQ_NBR = 201309000003 for the Voucher but DOC_SEQ_NBR = 201309000002 is not on the table
16.  No rows are inserted into the tracking deletion table of PS_SEQ_NBR_DEL_TBL for DOC_SEQ_NBR = 201309000002
17.  As a result, DOC_SEQ_NBR = 201309000002 is not used and not tracked in the database. This causes gaps / holes in the numbering, which is not compliant with the French law that requires the numbering to be continuous.

Cause

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