Error " java.sql.SQLSyntaxErrorException: ORA-00904: 'bpID_BP STATUS': invalid identifier" on BP Record After Importing a Configuration Package
(Doc ID 2336082.1)
Last updated on JANUARY 17, 2018
Applies to:Primavera Unifier - Version 188.8.131.52 to 184.108.40.206 [Release 16.2]
Primavera Unifier Cloud Service - Version 220.127.116.11 to 18.104.22.168 [Release 16.2]
Information in this document applies to any platform.
After importing a Configuration Package from Staging into Production, a generic system error is displayed when attempting to create a new BP Record or access the SOV from within the Record.
The impacted Business Process has not been modified as part of the Configuration Package.
The following error is seen in the UI:
"The system could not process your request. Logging in again may help in some cases. Contact your System Administrator if you are still having problems"
The following error is seen in the Unifier.log:
java.sql.SQLSyntaxErrorException: ORA-00904: 'bpID_BP STATUS': invalid identifier
The issue can be reproduced at will with the following steps:
1) Log In as Company Administrator.
2) Navigate to a project
3) Open the Business Process Record > Click on the SOV button and the Alert message above is seen.
4) Creating a new BP record also results in the same Alert message.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!