AUDIT REPORT ERRORS WITH ORA-02290: CHECK CONSTRAINT HR_AUDIT_TRANSACTION_TYPE_CHK

(Doc ID 2106187.1)

Last updated on FEBRUARY 12, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, in all instances,

When attempting to run the Audit Report, the following error occurs.

ERROR
-----------------------
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp002:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-02290: check constraint (HR.HR_AUDIT_TRANSACTION_TYPE_CHK) violated
ORA-06512: at "APPS.PY_AUDIT_REP_PKG", line 1397


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run the Audit report using parameters:

TABLE='PAY_CA_EMP_FED_TAX_INFO_F'
initialise='R'
p_start_date='2015/12/07 00:00:00'
p_end_date='2015/12/09 00:00:00'

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Currently in System Integration Testing, and the Audit Report issue would be a show stopper to closing the SIT and moving to UAT.

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