EAP: Record VCHR_DOCSEQ_HDR Is Not Populated When Two Recycled Vouchers Are Corrected On The Same Time

(Doc ID 1575003.1)

Last updated on MARCH 18, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

PS_VCHR_DOCSEQ_HDR  is not populated when two users are correcting  two different recycled vouchers on the same time. Also, vouchers will get the same document sequence number.
This will prevent voucher posting to happen.

STEPS

  1. Enable Document Sequencing at Installation level and General Business Unit level
  2. Create 2 new quick invoices with 2 distribution lines each. Account and Dept on second distribution line has invalid values
  3. Build the quick invoices. After vouchers are built , they got in recycle status
  4. Open first voucher. It is in recycle status with 2 errors
  5. Correct account number and save the voucher and will get the message that Dept ID is invalid
  6. Vouchers status shows as Postable and Doc Seq Number is populated.However, data is not saved on database. 
  7. Stay on this page and move to a different station
  8. From another computer open the second voucher. It is in recycle status with 2 errors
  9. Correct the account and save . Voucher shows Postable, but data is not yet saved on database – like for the first voucher
  10. Correct also the Dept ID and save the voucher. This time voucher has been saved
  11. Go back to the first voucher , correct the Dept ID and save the voucher. Voucher will be saved
  12. No data inserted into PS_VCHR_DOCSEQ_HDR and both vouchers have the same Document Sequence Number

Cause

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