Audit Trail Update Tables Errors with ORA-24344 Success with Compilation Error on PER_ALL_PEOPLE_F_AIP and PER_PAY_PROPOSALS_AIP (Doc ID 1551403.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Relevancy checked - 17-Mar-2015

Symptoms

When running "AuditTrail Update Tables" fails on PER_ALL_PEOPLE_F_AIP and PER_PAY_PROPOSALS_AIP
get following error in log file:

----->Create Standard Triggers
CREATE OR REPLACE PROCEDURE
PER_ALL_PEOPLE_F_AIP(A0 IN DATE,A1 IN DATE,A2 IN NUMBER,JB IN NUMBER,JC IN VARCHAR2,JD IN VARCHAR2,JF IN VARCHAR2,JG IN VARCHAR2,
JH IN VARCHAR2,JJ IN VARCHAR2,E0 IN DATE,E1 IN DATE,E2 IN NUMBER,RB IN NUMBER,RC IN VARCHAR2,RD IN VARCHAR2,RF IN VARCHAR2,RG IN VARCHAR2,
RH IN VARCHAR2,RJ IN VARCHAR2 )
AS
ROWKEY number;
NXT number;
CMT number;
NUSER varchar2(100);
nls_date_fmt VARCHAR2(40);
BEGIN
select value into nls_date_fmt from v$NLS_PARAMETERS where parameter='NLS_DATE_FORMAT';
execute IMMEDIATE 'alter session set nls_date_format="MM/DD/YYYY HH24:MI:SS"';
NXT:=FND_AUDIT_SEQ_PKG.NXT;
CMT:=FND_AUDIT_SEQ_PKG.CMT;
ROWKEY:=(TO_NUMBER(TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'))*100000 +MOD(NXT,100000)) * 100000 + USERENV('SESSIONID');
NUSER:=FND_AUDIT_SEQ_PKG.USER_NAME;
INSERT INTO PER_ALL_PEOPLE_F_A
VALUES(SYSDATE,'I',NUSER,NULL,USERENV('SESSIONID'),NXT,CMT,ROWKEY,E0,E1,E2,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
execute IMMEDIATE 'alter session set nls_date_format="'||nls_date_fmt||'"';

END PER_ALL_PEOPLE_F_AIP;

Fatal error in fdasql, quitting...
ORA-24344: success with compilation error
Fatal error in fdactr, quitting...

----->Create Standard Triggers
CREATE OR REPLACE PROCEDURE
PER_PAY_PROPOSALS_AIP(A0 IN NUMBER,JB IN NUMBER,JC IN VARCHAR2,JD IN VARCHAR2,JF IN NUMBER,E0 IN NUMBER,RB IN NUMBER,RC IN VARCHAR2,RD IN VARCHAR2,RF IN NUMBER )
AS
ROWKEY number;
NXT number;
CMT number;
NUSER varchar2(100);
nls_date_fmt VARCHAR2(40);
BEGIN
select value into nls_date_fmt from v$NLS_PARAMETERS where parameter='NLS_DATE_FORMAT';
execute IMMEDIATE 'alter session set nls_date_format="MM/DD/YYYY HH24:MI:SS"';
NXT:=FND_AUDIT_SEQ_PKG.NXT;
CMT:=FND_AUDIT_SEQ_PKG.CMT;
ROWKEY:=(TO_NUMBER(TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'))*100000 +MOD(NXT,100000)) * 100000 + USERENV('SESSIONID');
NUSER:=FND_AUDIT_SEQ_PKG.USER_NAME;
INSERT INTO PER_PAY_PROPOSALS_A
VALUES(SYSDATE,'I',NUSER,NULL,USERENV('SESSIONID'),NXT,CMT,ROWKEY,E0,NULL,NULL,NULL,NULL);
execute IMMEDIATE 'alter session set nls_date_format="'||nls_date_fmt||'"';

END PER_PAY_PROPOSALS_AIP;

Fatal error in fdasql, quitting...
ORA-24344: success with compilation error
Fatal error in fdactr, quitting...
Fatal error in fdactr, quitting...
commit

 


STEPS TO REPRODUCE
----------------------------------
1. Responsibility : system administrator
2. Navigation: concurrent requests
3. Run "AuditTrail Update Tables"


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