My Oracle Support Banner

Custom Flow Pattern errors with: TABLE_NAME PAY_CONSOLIDATION_SETS AFDICT_APP_PREFIX-PAY-1635870: A system error ORA-01403: no data found occurred in table PAY_CONSOLIDATION_SETS at location 1518. Contact your help desk. (Doc ID 2516474.1)

Last updated on OCTOBER 06, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, Global Payroll

Created a custom flow pattern from the checklist with a sequence that the payroll is processed after the retro pay. When we run the process the Retro pay is successful but the payroll process ends with an error.
The following error occurs:

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 1518
TABLE_NAME PAY_CONSOLIDATION_SETS
AFDICT_APP_PREFIX-PAY-1635870: A system error ORA-01403: no data found
occurred in table PAY_CONSOLIDATION_SETS at location 1518. Contact your help desk.
CONC-REQ RETURNED NO MESG

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. have created a custom flow pattern from the checklist with a sequence that the payroll is processed after the retro pay;
2. run the process the Retro pay is successful but the payroll process ends with an error without processing any employee.

How are we supposed to create a flow pattern as such so that we can prevent the users from missing out on processing the retro pay ?

Details:
Is the error faced even when Payroll is executed as a stand alone flow or under a QuickPay ?
The error faced in the Payroll Calculation, the flow pattern used here is a custom flow pattern.
No we do not have issue if we process independently.

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.