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 OCTOBER 02, 2023

Applies to:

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.

Changes

Cause

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