My Oracle Support Banner

Discrete Job Pick List Report (Doc ID 1618083.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Discrete Job Pick List Report completes in error, with the following error details:

ORA-01719: outer join operator (+) not allowed in operand of OR or IN
SELECT DECODE ( : P_SORT_BY , 9 , 'X' , WE . WIP_ENTITY_NAME ) Job , DECODE ( : P_SORT_BY , 9 , 'X' , WE . DESCRIPTION ) Job_Desc , DECODE ( : P_SORT_BY , 9 , 'X' , ML1 . MEANING ) Status , DECODE ( : P_SORT_BY , 9 , 'X' ,  (MSI.SEGMENT1||'\n'||MSI.S
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: outer join operator (+) not allowed in operand of OR or IN
SELECT DECODE ( : P_SORT_BY , 9 , 'X' , WE . WIP_ENTITY_NAME ) Job , DECODE ( : P_SORT_BY , 9 , 'X' , WE . DESCRIPTION ) Job_Desc , DECODE ( : P_SORT_BY , 9 , 'X' , ML1 . MEANING ) Status , DECODE ( : P_SORT_BY , 9 , 'X' ,  (MSI.SEGMENT1||'\n'||MSI.S




STEPS

The issue can be reproduced at will with the following steps:
1. Run Discrete Job Pick List Report




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


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