EBS to APEX ORA-20002: 3402: No valid session exists for this user.

BILL Carlisle
BILL Carlisle used Ask the Experts™
on
Hi,
      I am getting a ORA-20002: 3402: No valid session exists for this user. Please establish a new session through the login page
      when going from EBS to APEX in a setup that works in 4 other installations.
      Same DDL, same APP, same EBS function, menu, user, resp
      Going crazy!

it is happening at the call to Wfa_sec.Getsession()
      
      Any ideas?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Looks like this user had the same issue a few years ago:

http://www.orafaq.com/forum/t/62769/2/

The solution was to restart the server
BILL CarlisleAPEX Developer

Author

Commented:
Didn't do it for us..
APEX Developer
Commented:
Patch 12726556
12316083:R12.FND.B
Found second patch 12316083:R12.FND.B was needed by comparing other environments
BILL CarlisleAPEX Developer

Author

Commented:
I found the solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial