P6 primavera thick client(EPPM) cloud connect SSO failing with database version mismatch issue

Question

We are integrating the P6 primavera thick client(EPPM)with Oracle Access Manager (OAM) we have done all the configurations on both OAM and Application side as per the oracle documentation.

The connectivity looks OK, but its giving following error.

     The application and database versions do not match. Click Exit to close the application.
     Primavera P6 Professional R16.1
     Expected database version:  PMDB,1610.0001.0001
     Current database version:  

Though both the expected and current database version is same. Also when I checked here I see in the screenshot it does give current database version value. but in our case its not giving any value in the error message.we are using Primavera P6 version 16R1.

Answer 1

Check the version of Database using following SQL query: select database_version from prefer

if this is different from the expected one then applying patches should sort the issue.