My Oracle Support Banner

Fusion Global Payroll : Quickpay errors with: AFDICT_APP_PREFIX-PAY-1635870 ORA-01403: no data found occurred in table pay_qualifier_criteria at location 3029 (Doc ID 2446630.1)

Last updated on MAY 21, 2020

Applies to:

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

Symptoms

 On :  11.13.18.05.0 version, UK - United Kingdom Legislation

Alpha Effective Pension Age scheme calculation error  

Hi,

After we created Alpha Effective Pension Age scheme, after we attached this scheme to employee an run calculate payroll, there is error occurred.

ERROR
-----------------------
HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO MOJ047232
AFDICT_APP_PREFIX-PAY-1635156: Error was encountered when processing payroll relationship MOJ047232.
 In  { pyxipmt
message text = Error was encountered when processing payroll relationship MOJ047
232.
message level = F,F
payroll_id text = 300000001261948
source_id text = 114035
line_text = 69, Error was encountered when processing payroll relationship MOJ04
7232.
 Out } pyxipmt
 In  { pylogpop
 Out } pylogpop
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 3029
TABLE_NAME pay_qualifier_criteria
AFDICT_APP_PREFIX-PAY-1635870: A system error ORA-01403: no data found
occurred in table pay_qualifier_criteria at location 3029. Your help desk was notified.
 In  { pyxipmt
message text = A system error ORA-01403: no data found
occurred in table pay_qualifier_criteria at location 3029. Your help desk was n
otified.
message level = F,F
payroll_id text = 300000001261948
source_id text = 114035
line_text = 128, A system error ORA-01403: no data found
occurred in table pay_qualifier_criteria at location 3029. Your help desk was n
otified.
 Out } pyxipmt
 In  { pylogpop
 Out } pylogpop
Out } pylogseh
status error




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Alpha Effective Pension Age scheme
2. Attach element to assignment
3. Process payroll run.

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


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