Discrete Job Pick List Report (Doc ID 1618083.1)

Last updated on APRIL 03, 2025

Applies to:

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

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