Change Tracking Transfer Job Error ORA-01017 ORA-02063 Email Notifications Not received When Someone Makes Changes

(Doc ID 1278126.1)

Last updated on DECEMBER 06, 2016

Applies to:

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


=== ODM Issue Clarification ===

On : 5.5.1 version of CCG, system did not send out the email notifications after making changes in EBS and generated Change Tracker Transfer.

The issue can be reproduced at will with the following steps:
1. Login to CCG.
2. Test email notification successfully from the Home Configuration page on CCG 5.5.1.
3. Make EBS changes and run CT transfer.

Error in CT transfer job log:
Checking for Changes Pending on all the enabled targets
that have at least one object change trackable ...
error while executing SELECT instance_id FROM TICK_TARGET_PARAMETERS@DEV6_AM_AGE
NT_DBLINK ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DEV6_AM_AGENT_DBLINK

The issue has the following business impact:
Due to this issue, users cannot receive email notifications of changes done in EBS used for audit reporting.


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