There Are 11 PSD Codes In The Table That Are Duplicate, But There Should NOT Be Any Duplicates

(Doc ID 1450740.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle HRMS (US) - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

We have discovered that the Pay_US_School_dsts_Tax_Info_F table has 11 separate PSD Codes that are in there as duplicates with multiple Jurisdiction Codes against them. This is not accurate. Per Pennsylvania, each PSD Code is specific to the city jurisdiction and the school code combination so there would not be an instance when they are two jurisdictions with one PSD code.

 

 

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