My Oracle Support Banner

“System could not..” 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 APRIL 01, 2019

Applies to:

Primavera Unifier - Version to [Release 16.2]
Primavera Unifier Cloud Service - Version to [Release 16.2]
Information in this document applies to any platform.


On Unifier : Version 16.2

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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.