Deploy Change Tracking Error In Creating Triggers ORA-04052 ORA-00604 ORA-12514

(Doc ID 2129770.1)

Last updated on APRIL 22, 2016

Applies to:

Oracle Configuration Controls Governor - Version 5.5.1 and later
Information in this document applies to any platform.


On : 5.5.1 version, Integra Apps

error- Status Message: Error in creating triggers

Re-deployed change tracking definition however still getting the error- Status Message: Error in creating triggers.

Log file attached.

 error- Status Message: Error in creating triggers.


create_triggers routine failed ORA-04052: error occurred when looking up remote
ORA-00604: error occurred at recursive SQL level 2
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Error in creating triggers

The issue can be reproduced at will with the following steps:
1. Login to CCG
2. Deploy Change Tracking job

The issue has the following business impact:
Due to this issue, users cannot run change tracking setup reports.


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