Quickpay Error ORA-01403: no data found occurred in table pay_dir_card_comp_defs_f at location 507 when running payroll process

(Doc ID 2306474.1)

Last updated on MARCH 05, 2018

Applies to:

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

Symptoms

 On : 11.12.1.0.0 version, Global Payroll

 

Unable to run a QuickPay when testing Statutory and Occupations Sick absence processing. Message returned is "A system error ORA-01403: no data found occurred in table pay_dir_card_comp_defs_f at location 507. Your help desk was notified."

ERROR
-----------------------
AFDICT_APP_PREFIX-PAY-1635156: Error was encountered when processing payroll relationship 99-999999.
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found

SQL_NO 507
TABLE_NAME pay_dir_card_comp_defs_f
AFDICT_APP_PREFIX-PAY-1635870: A system error ORA-01403: no data found
occurred in table pay_dir_card_comp_defs_f at location 507. Your help desk was notified.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run a quickpay for an employee currently attached to an Occupational absence

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms