EAP: Voucher Source Is Being Updated From XML To XLS While Upgrading From 8.9 To 9.2
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.
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:
SET VCHR_SRC ='XLS'
WHERE VCHR_SRC ='XML'
AND NOT EXISTS (
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?
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