EAP: Voucher Source Is Being Updated From XML To XLS While Upgrading From 8.9 To 9.2 (Doc ID 1914389.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Goal

The voucher source field on PS_VOUCHER table is being updated to XLS in 9.2 when the voucher source in 8.9 was XML.

Here is the SQL from the BUG 16729602 in PUM IMAGE 2 that is updating the translate value on the field, VCHR_SRC:
UPDATE PS_VOUCHER
  SET VCHR_SRC ='XLS'
 WHERE VCHR_SRC ='XML'
  AND NOT EXISTS (
 SELECT 'X'
  FROM PS_EM_BUY_REG_TBL A
 WHERE A.BUSINESS_UNIT = PS_VOUCHER.BUSINESS_UNIT))

These vouchers were XML vouchers and not spreadsheet vouchers so is it necessary to run the SQL?


 

Solution

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