New Zealand Payroll Error After Rup10 Upgrade pay_balance_types at location 582 with the error text ORA-01403: no data found
(Doc ID 2386708.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle HRMS (New Zealand) - Version 12.1.3 and laterInformation in this document applies to any platform.

Symptoms

On : 12.1.3 version R12.HR_PF.B.Delta.10, under NewZealand Payroll

When attempting to run Payroll / Quickpay,the following error occurs.

ERROR-----------------------APP-PAY-51118: Error was encountered when processing assignment 0001038HR_6881_HRPROC_ORA_ERRSQLERRMC ORA-01403: no data found

SQL_NO 582TABLE_NAME pay_balance_typesAPP-PAY-06881: Error ORA-01403: no data found has occurred in table pay_balance_types at location 582

Cause: an oracle error has occurred. The failure was reported on table pay_balance_types at location 582 with the error text ORA-01403: no data found. Action: Please contact your support representative.

STEPS-----------------------The issue can be reproduced at will with the following steps:1. Add a new Business Group under New Zealand2. Run Payroll / Quickpay