PAYUSTX2 Error in pay_us_tax_bal_summary_pkg.get_local When trying To Display Balances For Any Local Added In RUP 7

(Doc ID 1924320.1)

Last updated on MARCH 27, 2017

Applies to:

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

Symptoms

On : 12.1 HRMS RUP7 version,

When attempting to display balances for any employer local taxes added in the HRMS 12.1RUP 7 update in the "Tax Balance Summary" window, the following error occurs.

ERROR
-----------------------
ORA-20101: Error in pay_us_tax_bal_summary_pkg.get_local - ORA-20101: Error in pay_us_tax_bal_summary_pkg.get_local_balances - User-Defined Exception
ORA-06512: at "APPS.PAY_US_TAX_BAL_SUMMARY_PKG", line 1607

--------------------------------------------------------------
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-20101.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open the Tax balance Summary window.
2. Find employee.
3. Enter following criteria.

GRE: ...
ER
Assignment
State: Colorado
County:Denver
City:Denver

4. Error occurs.

 

Cause

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