Tax Year End Data Validation Report Error ORA-20001: HR_ZA_ENTR_VAL_ON_COND: N, VALUE, ID Number, N, CONDITION, Nature of Person is R (Doc ID 2220382.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle HRMS (South African) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version,

When attempting to Tax Year End Data Validation Report,
the following error occurs.

ERROR
-----------------------

Problem:java.sql.SQLException: ORA-20001: HR_ZA_ENTR_VAL_ON_COND: N, VALUE, ID Number, N, CONDITION, Nature of Person is R
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.PAY_ZA_EOY_VAL", line 3420
ORA-06512: at "APPS.PAY_ZA_EOY_VAL", line 4292
ORA-06512: at "APPS.PAY_ZA_EOY_VAL", line 4910
ORA-06512: at line 1
ORA-06512: at "APPS.PAY_XML_GEN_PKG", line 37
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login using UJ Payroll Administration All Payrolls
2. (N) -> Processes & Reports > Submit Processes and Reports > Interim Tax Year End Data Validation Report
3. Review log file


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