Error " java.sql.SQLSyntaxErrorException: ORA-00904: 'bpID_BP STATUS': invalid identifier" on BP Record After Importing a Configuration Package
Last updated on JANUARY 17, 2018
Applies to:Primavera Unifier - Version 184.108.40.206 to 220.127.116.11 [Release 16.2]
Primavera Unifier Cloud Service - Version 18.104.22.168 to 22.214.171.124 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms