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.

Symptoms

On : 12.2.7 version, India Payroll

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

ERROR
-----------------------
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

STEPS
-----------------------
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

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

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

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

Cause

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
Symptoms
Cause
Solution
References


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