My Oracle Support Banner

Change Tracking Transfer Job Error ORA-01017 ORA-02063 Email Notifications Not received When Someone Makes Changes (Doc ID 1278126.1)

Last updated on OCTOBER 10, 2023

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.