My Oracle Support Banner

ORA-01403/FRM-40735/ORA-02292 Errors When Attempting to End Date Payroll (Doc ID 2669993.1)

Last updated on MAY 13, 2020

Applies to:

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

Symptoms

Problem Statement:

When attempting to end date the payroll, following error occurs.

ORA-01403: no data found
FRM-40735: ON-DELETE trigger raised unhandled exception ORA-02292.

 

ORA-02292 error occurs in the following delete statement.

ORA-02292: integrity constraint (HR.PAY_PAYROLL_ACTIONS_FK8) violated - child record found
----- Current SQL Statement for this session (sql_id=0gkbh8ur9vddm) -----
DELETE FROM PER_TIME_PERIODS TPE WHERE TPE.PAYROLL_ID = :B2 AND TPE.END_DATE >= :B1

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Login as HRMS Manager responsiblity
  2.  Go to Payroll form
     (N) Payroll > Description
  3.  Delete the payroll with End Date option
  4.  Error occurs



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.