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

Last updated on SEPTEMBER 29, 2016

Applies to:

Oracle Discoverer - Version 10.1.2.3 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2016***

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

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