Oracle BI Discoverer Connection Fails With Error: Unable to connect to Oracle Applications database (afscpgcs) (Doc ID 1549801.1)

Symptoms

Using Discoverer 10g or 11g (Viewer or Plus), when attempting to connect to the Prod EBS 12.1.3 RAC database , you receive the error :

Error
 A connection error.
 - A connection error.
 - Failed to connect to database - Unable to connect to Oracle Applications database (afscpgcs)

The eulapi command run as the EUL owner, works without error. Running eulapi using EBS login e.g. sysadmin, returns the same error.


The Discoverer Connection session trace shows the following error:

PROCEDURE fnd.src.security.afscp.afscpsup: Begin
STATEMENT fnd.src.security.afscp.afscpsup: Username = SYSADMIN
PROCEDURE fnd.src.security.afscp.afscpsup: End: Success
PROCEDURE fnd.src.security.afscp.afscprsp: Begin(respkey = #1/#20420)
PROCEDURE fnd.src.security.afscp.afscprsp: End: Success
PROCEDURE fnd.src.security.afscp.afscpsvr: Begin
PROCEDURE fnd.src.security.afscp.afscpsvr: End: Success
PROCEDURE fnd.src.security.afscp.afscpcon: Begin
STATEMENT fnd.src.security.afscp.afscpcon: Connecting to gwyuid = APPLSYSPUB/PUB@cmprd1
STATEMENT fnd.src.security.afscp.afscpcon: New security pkg: Retrieving encrypted pwd
STATEMENT fnd.src.security.afscp.afscpcon: New security pkg success
STATEMENT fnd.src.security.afscp.afscpcon: Decrypting apps password
STATEMENT fnd.src.security.afscp.afscpcon: Closing gwyuid connection
STATEMENT fnd.src.security.afscp.afscpcon: Opening apps connection
STATEMENT fnd.src.security.afscp.afscpcon: Get responsibility info
STATEMENT fnd.src.security.afscp.afscpcon: user_id = 0, resp_type = I, resp_key = #20420 resp_id = 20420
STATEMENT fnd.src.security.afscp.afscpcon: appl_type = I, appsname = #1, appl_id = 1, secgrp =
STATEMENT fnd.src.security.afscp.afscpcon: Decrypting new oracle pwd for resp
PROCEDURE fnd.src.security.afscp.afscpcon: End: Failure
PROCEDURE fnd.src.security.afscp.afscpfree: Begin
PROCEDURE fnd.src.security.afscp.afscpfree: End

Cause

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