I have successfull integrated EBS R12 with OBIEE 11g
Two Questions are:
1, I didnot call "CALL APP_SESSION.validate................." Procedure in my repository
because If I call above procedure then I click on TEST it gives me error "Unable to find database connection pool ABC"
besides of this I successfully login EBS and click on BI ANSWER from my responsibility OBIEE_ADMIN , OBIEE login page appears , I again entered EBS credentials and BI home page appears
2, I didnot go directly from EBS to OBIEE home page , it always ask me username and password at OBIEE login page .
Please resolve my both questions , If I didnot used CALL procedure in my repository so what's disadvantage???
Well SasiNagireddy ,
It is not done ! actually when I click on OBIEE ANSWER and OBIEE login page appears when I type anyusername or anypassword , then it login successfully . which is wrong it means CALL APP_SESSION is mandatory to call at repository but when I call this procedure it is showing error "Unable to connect database connection pool"