Monday, December 23, 2019

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.




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.



No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts