Employee Annual Tax Returns (India) Errors ORA-01722 : invalid number ORA-06512: at "APPS.PAY_IN_EOY_REPORTS"
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.
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
Million Knowledge Articles and hundreds of Community platforms