My Oracle Support Banner

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.

Symptoms

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.
 

ERROR


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


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
Cause
Solution


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