Labor Distribution PSP: Import Payroll From HRMS Process Fails Error With "Server Side API failed and did not return an error message" (Doc ID 2344749.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 12.2.6 version, Setup

When attempting to run PSP: Import Payroll Transactions from HRMS
the following error occurs.

ERROR
-----------------------
2017/12/28 15:57:33 Import process started
2017/12/28 15:57:33 l_TGL_REVB_ACC_DATE, l_TGL_DATE_USED=P,P
2017/12/28 15:57:33 l_start_date, l_end_date, l_payroll_id=01-NOV-17,30-NOV-17,61
2017/12/28 15:57:33 g_sob_currency_code, g_uom =USD,M
2017/12/28 15:57:33 g_ignore_date_earned = N
2017/12/28 15:57:33 l_column_count =4
2017/12/28 15:57:33 l_legislation_code =LB
2017/12/28 15:57:33 l_clearing_account =<CLEARNING_ACCOUNT>
2017/12/28 15:57:33 **************************************************************
2017/12/28 15:57:34 l_assigment_id, l_assignment_action_id, p_time_period_id = <ASSIGNMENT_ID>,<ASSIGNMENT_ACTION_ID>,875
2017/12/28 15:57:34 l_assigment_id, l_assignment_action_id, p_time_period_id = <ASSIGNMENT_ID>,<ASSIGNMENT_ACTION_ID>,875
2017/12/28 15:57:34 l_assigment_id, l_assignment_action_id, p_time_period_id = <ASSIGNMENT_ID>,<ASSIGNMENT_ACTION_ID>,875
2017/12/28 15:57:34 l_assigment_id, l_assignment_action_id, p_time_period_id = <ASSIGNMENT_ID>,<ASSIGNMENT_ACTION_ID>,875
.
.
2017/12/28 16:01:01 l_assigment_id, l_assignment_action_id, p_time_period_id = <ASSIGNMENT_ID>,<ASSIGNMENT_ACTION_ID>,875
2017/12/28 16:01:01 l_assigment_id, l_assignment_action_id, p_time_period_id = <ASSIGNMENT_ID>,<ASSIGNMENT_ACTION_ID>,875
2017/12/28 16:01:01 l_assigment_id, l_assignment_action_id, p_time_period_id = <ASSIGNMENT_ID>,<ASSIGNMENT_ACTION_ID>,875
The program failed with the following error :
Program error : Server Side API failed and did not return an error message. Please contact your support representative.
+---------------------------------------------------------------------------+

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PSP: Import Payroll Transactions from HRMS

FND Log shows

per.plsql.psp_paytrn.line1387 Found cost record Cost_id, costed_value =421435,15151110
per.plsql.psp_paytrn.line9045 Entering CHECK_ZERO_WORK_DAYS
per.plsql.psp_paytrn.line9046 zero work days check asg, g_no_of_person_workdays= 3937,22
per.plsql.psp_paytrn.line9090 Leaving CHECK_ZERO_WORK_DAYS
per.plsql.psp_paytrn.line1407 Before opening check_payroll_lines_csr
per.plsql.psp_paytrn.line1411 After check_payroll_lines_csr - l_cost_id = 0
per.plsql.psp_paytrn.line1415 check_payroll_lines_csr%NOTFOUND
per.plsql.psp_paytrn.line1423 l_counter = 3874
per.plsql.psp_paytrn.line1427 l_prev_currency_code, g_pay_costs_rec.output_currency_code = LBP,LBP
per.plsql.psp_paytrn.line1618 pass kff =6293
per.plsql.psp_paytrn.line1628 g_non_active_flag = N
per.plsql.psp_paytrn.line1662 -pass 10
per.plsql.psp_paytrn.line1748 -pass 50
per.plsql.psp_paytrn.line1783 -pass 60
per.plsql.psp_paytrn.line3034 Entering CALCULATE_BALANCE_AMOUNT
per.plsql.psp_paytrn.line3052 Leaving CALCULATE_BALANCE_AMOUNT
per.plsql.psp_paytrn.line2119 Process failed here
per.plsql.psp_paytrn.line2120 -exception 20- sqlerrm = ORA-06502: PL/SQL: numeric or value error: number precision too large   <<<
fnd.plsql.fnd_file.PUT_LINE sid:64338917: The program failed with the following error :
fnd.plsql.fnd_file.PUT_LINE sid:64338917: Program error : Server Side API failed and did not return an error message. Please contact your support representative.
fnd.src.process.fdpwrt.fdpwrt.log_write **Ends**

Cause

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