My Oracle Support Banner

Snapshot Comparisions Is Not Showing Any Data. (Doc ID 2322502.1)

Last updated on MAY 21, 2018

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, Other Issues not covered by existing components

When attempting to run the Snapshot,
the following error occurs.

Building SELECT statement
Processing table RA_CUST_TRX_TYPES_ALL (544)
get_column Error ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from ASIPROD1_ERP_LINK1
Error: Populate Snapshot Selects routine failed. ORA-06503: PL/SQL: Function ret
urned without value
Statement Running: Processing Columns

The issue can be reproduced at will with the following steps:
1. Navigate to the CCG Workbench
2. Select any of the Snapshot
3. Schedule the snapshot

The issue has the following business impact:
Due to this issue, users cannot able to run the snapshot successfully.


To view full details, 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 a vibrant support community of peers and Oracle experts.