Employee Annual Tax Returns (India) Errors ORA-01722 : invalid number ORA-06512: at "APPS.PAY_IN_EOY_REPORTS"

(Doc ID 1080412.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (India) - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


When attempting to run Employee Annual Tax Returns (India),
the following error occurs.

busGrpID : 81
Assessment Year : 2010-2011
employeeType : ALL
templateName : PAY_IN_ITR_EE_05
before call to pay_in_eoy_reports.load_xml
begin pay_in_eoy_reports.load_xml(:1,:2,:3,:4,:5,:6); end;
Report Generation Failed java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "APPS.PAY_IN_EOY_REPORTS", line 1992
ORA-06512: at line 1


The issue can be reproduced at will with the following steps:
1. Run End of Year Archival (India)
2. Run Employee Annual Tax Returns (India) with Parameter Employee Type as 'All Employees'


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