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.

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

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