Error 'SQLSyntaxErrorException: ORA-00942: Table or View Does Not Exist' When Navigating to a Business Process Log After Importing a Production Bundle

(Doc ID 2359014.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Primavera Unifier - Version and later
Primavera Unifier Cloud Service - Version and later
Information in this document applies to any platform.


After importing a Production Bundle from a Staging/Development environment into a Production environment, a generic system error is thrown when navigating to a Business Process Log.

The Business Process experiencing the issue is an existing BP in Production. During the bundle creation, a dependent BP design was not included and the Reference Process details are not coming up as a result.

Error seen in the Unifier User Interface:
"The system could not process your request..."

Error seen in the Unifier.log File:
'SQLSyntaxErrorException: ORA-00942: table or view does not exist'


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