My Oracle Support Banner

PAYUSEET Form - Updating US State Tax Rules Update For Georgia Results in Data Corruption (Doc ID 2697219.1)

Last updated on OCTOBER 07, 2020

Applies to:

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

Symptoms

On : 12.2 HRMS RUP13 version, US Payroll Tax Issues

ACTUAL BEHAVIOR
---------------
When attempting to update the State Tax Rules for Georgia employees from "Married Filing Jointly with one spouse" to "Head of Household" and Allowance information in PAY_US_EMP_STATE_TAX_RULES_F is missing.


For example

Before the update
Filing status : Married Filing Jointly with one spouse
  Allowance: 2

State details (PAY_US_EMP_STATE_TAX_RULES_F)

EFFECTIVE_START_DATE EFFECTIVE_END_DATE ASSIGNMENT_ID JURISDICTION_CODE STATE
07-JAN-2010 29-JUN-2019 ******* 11-000-0000 Georgia
30-JUN-2019 11-JUL-2019 ******* 11-000-0000 Georgia
12-JUL-2019 31-DEC-4712 ******* 11-000-0000 Georgia

Change
Filing status : Head of Household
  Allowance: 1

Save as update

After the Change: period 12-JUL-2019 - 27_JUN-2020 is missing
State details (PAY_US_EMP_STATE_TAX_RULES_F)

EFFECTIVE_START_DATE EFFECTIVE_END_DATE ASSIGNMENT_ID JURISDICTION_CODE STATE
07-JAN-2010 29-JUN-2019 *******  11-000-0000 Georgia
30-JUN-2019 11-JUL-2019 *******   11-000-0000 Georgia
28-JUN-2020 31-DEC-4712 *******  11-000-0000 Georgia


EXPECTED BEHAVIOR
-----------------------
After the update expect
State details (PAY_US_EMP_STATE_TAX_RULES_F)

EFFECTIVE_START_DATE EFFECTIVE_END_DATE ASSIGNMENT_ID JURISDICTION_CODE STATE
07-JAN-2010 29-JUN-2019 ******* 11-000-0000 Georgia
30-JUN-2019 11-JUL-2019 *******  11-000-0000 Georgia
12-JUL-2019 27-JUN-2020 *******  11-000-0000 Georgia
28-JUN-2020 31-DEC-4712 ******* 11-000-0000 Georgia


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In US HRMS Manager Responsibility navigate to Assignment - Tax Info - State Tax
2. Change Filing status and allowance
3. review PAY_US_EMP_STATE_TAX_RULES_F


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.