Discrete Job Pick List Report

(Doc ID 1618083.1)

Last updated on JULY 14, 2017

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




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms