My Oracle Support Banner

HR_ADP_WORK_STATE_TAX_V Not Fetching US Associate Records (Doc ID 2430002.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP7 version, 3rd Party Interfaces

HR_ADP_WORK_STATE_TAX_V : Not fetching US associate records

HR_ADP_WORK_STATE_TAX_V is not fetching US associate records where as it fetches from HR_ADP_RESIDENT_STATE_TAX_V .

Associates are from 'Saint Louis' city from Missouri (MO ) state.

On further debug , the pay_us_city_names table has multiple city codes for Saint Louis City , Missouri ( MO ) state.  Also the primary flag is "N" for these city codes.

The jurisdiction code in pay_us_emp_city_tax_rules_f table does not seem to be populated correctly for the Saint Louis city associates.

No error, but incorrect behavior



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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