My Oracle Support Banner

Pay Advice India Error When Mailed To Employees (Doc ID 2502255.1)

Last updated on JANUARY 08, 2020

Applies to:

Oracle HRMS (India) - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, India Payroll

Pay Advice (India) goes into error when mailed to employees.

busGrpID : XX
startDate : 2018/12/01 00:00:00
endDate : 2018/12/31 00:00:00
payrollId : XX
consolidation set Id : XX
assignment set Id : XXXXXX
employee number : -1
sort order 1 : null
sort order 2 : null
sort order 3 : null
sort order 4 : null
Output Type : XML
before call to pay_in_soe.load_xml_burst
begin pay_in_soe.load_xml_burst(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12); end;
Report Generation Failed java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.PAY_IN_SOE", line 2437
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Under India HRMS Manager responsibility, complete the following
2. Payroll Run
3. Prepayments
4. Payroll Reports Archive (India)
5. Submit Pay Advice (India) with "Mail Individual Payslip" option

The issue has the following business impact:
Due to this issue, users cannot email Payslips to their employees.
Issue happens with few employees.

For the impacted employees, it works fine if Pay Advice (India) submitted with 'View Consolidated Payslips as PDF'.

Create an Assignment Set and submit Pay Advice (India) with 'View Consolidated Payslips as PDF'.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.