Getting Error "ORA-01417: a table may be outer joined to at most one other table " In Building the View "PV_PERF_SR_VW" when Applying PUMs from PUM#31 to PUM#34
(Doc ID 2635486.1)
Last updated on FEBRUARY 04, 2020
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Getting error : "ORA-01417: a table may be outer joined to at most one other table" on View: "PV_PERF_SR_VW" when packaging all the updates from PUM#34 including Patches from PUM#31 till PUM#34 then running the Create views step.
The issue can be reproduced at will with the following steps:
1. Package all patches from PUM#31 to PUM#34
2. Apply them to target environment
3. Run the Create Views as part of the change package.
4. Getting Error ORA-01417: a table may be outer joined to at most one other table for view :PV_PERF_SR_VW
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