OBIA 7963: PeopleSoft Payroll for North America Tax Update 11-F Results In Duplicate Records In W_PAYROLL_FS / W_PAYROLL_F Table
(Doc ID 1437348.1)
Last updated on DECEMBER 05, 2019
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199 [AN 1900] to 188.8.131.52 [AN 1900] [Release V7]
Information in this document applies to any platform.
- BI Apps version 184.108.40.206 and Peoplesoft 9.0.1
- The recent patch PeopleSoft Payroll for North America Tax Update 11-F applied to PeopleSoft 9.0.1 databases caused new columns to be added;
WORK_PSD_CD and RES_PSD_CD to several tables including PS_PAY_TAX.
This column causes duplicate rows in the out of the box source qualifier query of SDE_PSFT_PayrollFact_Taxes.
Subsequently creating duplicate records in W_PAYROLL_FS/F Table and thus causing the ETL load to fail because of unique key violation.
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