You are not currently signed in to the Oracle BI Server

Error:-

You are not currently signed in to the Oracle BI Server

If you have already signed in, your connection might have timed out, or a communications or server error may have occurred.

To sign in again, click here. If the problem persists, please contact the site's administrator

Raised Oracle SR but Oracle was failed to Solve the ISSUE using below document.

OBIEE 12c : EBS / OBIEE 12c Integration Missing Steps (Doc ID 2141505.1) OBIEE 12c: Integrating OBIEE 12c with Oracle E-Business Suite (EBS) Security (Doc ID 2174747.1)

Solution:-

1) Execute the EBS security(RPD)  query against the EBS database and check the result.
2) Do not include ROLES and USER is same target variable.it will give same error.
3) check the parameters in two files authenticationschemas.xml and instanceconfig.xml. as per oracle doc id 2174747.1.
4) Found issue in  RPD need to correct the initialization using below parameters.

•   Get Oracle EBS Security Context
  
  Query=

SELECT
  FND_GLOBAL.RESP_ID,
  FND_GLOBAL.RESP_APPL_ID,
  FND_GLOBAL.SECURITY_GROUP_ID,
  FND_GLOBAL.RESP_NAME,
  FND_GLOBAL.USER_ID,
  FND_GLOBAL.EMPLOYEE_ID,
  FND_GLOBAL.USER_NAME
FROM DUAL

Required for authentication = checked box –YES

•  Get OBIEE User Group Persmissions

Query=

SELECT RESPONSIBILITY_NAME

FROM FND_RESPONSIBILITY_TL

WHERE RESPONSIBILITY_ID = 'valueof(NQ_SESSION.OLTP_EBS_RESP_ID)'

Variable target  =GROUP

Execution precedence = ORACLE EBS Security Context

Required for authentication = checked box –YES

•  EBS Security Context – ROLES – Row wise

Query=

SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_TL WHERE
RESPONSIBILITY_ID = 'valueof(NQ_SESSION.OLTP_EBS_RESP_ID)'
Variable target = ROLES
 Execution precedence = ORACLE EBS Security Context 

       Required for authentication = checked box –YES

Finally Issue resolved.

Create View ORA-01031: insufficient privileges

*Cause:    An attempt was made to perform a database operation without
           the necessary privileges.
*Action:   Ask your database administrator or designated security
           administrator to grant you the necessary privileges



Solution :

[oracle@~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 5 14:54:07 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> grant CREATE ANY VIEW to XXALU;

Grant succeeded.


SQL> alter user XXALU enable editions;

User altered.


SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@~]$

View "XXTAM"."JOBS" created.