My Oracle Support Banner

EAP 9.2: Voucher Post Not Updating PS_VOUCHER Record Fields Of LAST_UPDATE_DT, LAST_UPDATE_DTTM, and OPRID_LAST_UPDT (Doc ID 2758803.1)

Last updated on MARCH 08, 2021

Applies to:

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

Symptoms


It has been detected that after successfully completing the Voucher Post process (AP_VCHRPST AE Program), which sets the Voucher as Posted, and generates the Accrual Accounting Entries needed into PS_VCHR_ACCTG_LINE, the below Record Fields are not being updated accordingly:

    - Record Field PS_VOUCHER.LAST_UPDATE_DT = Contains the last Date the Voucher was modified
    - Record Field PS_VOUCHER.LAST_UPDATE_DTTM = Contains the last Date and Time stamp the Voucher was modified
    - Record Field PS_VOUCHER.OPRID_LAST_UPDT = Contains the value of the Operator ID who last updated the Voucher (Online, or through a Batch Process launched by that User)

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as Payables User #1
    2.- Create a brand new Voucher in Postable status, and save the changes
    3.- Confirm that the below Record Fields are properly updated:
          a) Record Field PS_VOUCHER.LAST_UPDATE_DT
          b) Record Field PS_VOUCHER.LAST_UPDATE_DTTM
          c) Record Field PS_VOUCHER.OPRID_LAST_UPDT
    4.- Log into the FSCM Online Application as Payables User #2
    5.- Go to the Voucher Post Run Control ID, and define this Voucher transaction
    6.- Launch the Voucher Post process
    7.- Confirm that the Voucher is now in Posted status, and Accrual Accounting Entries are created
    8.- Confirm that the below Record Fields have not been updated as expected:
          a) Record Field PS_VOUCHER.LAST_UPDATE_DT
          b) Record Field PS_VOUCHER.LAST_UPDATE_DTTM
          c) Record Field PS_VOUCHER.OPRID_LAST_UPDT

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

While the Voucher transaction has been set to Posted status, (Record Field PS_VOUCHER.POST_STATUS_AP = 'P'), and Accrual Accounting Entries exist, (Record PS_VCHR_ACCTG_LINE), the fact that the 3 Fields in Record PS_VOUCHER (LAST_UPDATE_DT, LAST_UPDATE_DTTM, OPRID_LAST_UPDT), are not updated ensure that there is no real data consistency, and leads to audit inaccuracies.

If a User has launched Voucher Post, and this has effectively modified the Voucher, those Fields should be updated as well.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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