Error: "Selected View Has Never Been Published" When Using Data View and Error: "ORA-00918: column ambiguously defined" When Attempting To Republish the Same Data View
(Doc ID 2926930.1)
Last updated on FEBRUARY 13, 2023
Applies to:
Primavera Unifier Cloud Service - Version 21.12.12.0 and laterPrimavera Unifier - Version 21.12.12.0 and later
Information in this document applies to any platform.
Symptoms
When attempting to use a Unifier Data View the top error in "Error" section below is displayed. When setting the Data View to "Draft" and then attempting to set it back to Published, the second error in "Error" section below is displayed. There have been no changes to the Data Views in many months or longer. There was a recent Unifier patch applied and that was the only known change.
ERROR
-----------------------
When selecting Data View > Data: "Alert Selected view has never been published."
When trying to republish the Data View: "Alert ORA-00918: column ambiguously defined"
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Log into Unifier.
- Navigate to Company Workspace > Data Structure Setup > Data Views > Find and Open a Data View > Click "Data".
- This error is displayed in the Unifier UI: "Alert Selected view has never been published."
- Set the Data View status back to "Draft" and then try to Publish it.\
- his error is displayed in the Unifier UI: "Alert ORA-00918: column ambiguously defined".
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |