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:

Symptoms

=== 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.


STEPS
-----------------------
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
-----------------------
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

BUSINESS IMPACT
-----------------------
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.

Cause

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