End Date Element Link, Errors: ORA-01403: No Data Found and ORA-06512: at "APPS_PAY_ELEMENT_LINKS_PKG"

(Doc ID 748268.1)

Last updated on FEBRUARY 27, 2017

Applies to:

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


Problem Statement:

When attempting to delete an element link the following error occurs:

ORA-01403: no data found
ORA-06512: at "APPS_HR_ENTRY_API", line 549
ORA-06512: at "APPS_HR_ENTRY_API", line 8465
ORA-06512: at "APPS_PAY_ELEMENT_LINKS_PKG", line 161
ORA-06512: at "APPS_PAY_ELEMENT_LINKS_PKG", line 926
FRM-40735: ON-DELETE trigger raised unhandled exception ORA-01403.


Already worked through data cleanup in the following note, but additional orphaned rows still remained.

<Document 267064.1> - Deleting an Existing Element Link, Receive Error: FRM-40735: ON-DELETE trigger raised unhandled exception ORA-01403 No Data Found 

Please work through the data cleanup in <Document 267064.1> before proceeding through this document


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