Getting Error While Adding A Work Item To A Collection Strategy (Doc ID 2533264.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Advanced Collections - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Collections Administration

Getting error while adding a Work Item to a Collection Strategy

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation. Statement: select
witemT.name,
witemT.description,
witemT.work_type,
witemT.category_type,
witemT.priority_type,
witemT.optional_yn,
fndlookup.meaning,
witemT.pre_execution_wait,
witemT.post_execution_wait,
witemT.workflow_item_type,
witemT.work_item_temp_id,
lk.meaning meaning1,
witemT.org_id
,nvl(HROU.NAME,'All') opeartingunit_name
from iex_stry_temp_work_items_vl witemT
,fnd_lookups fndlookup
,ieX_lookups_v lk
,HR_OPERATING_UNITS HROU
where
fndlookup.lookup_code =witemT.optional_yn
and fndlookup.lookup_type = 'YES_NO'
and witemT.CATEGORY_TYPE=lk.lookup_code
and lk.lookup_type(+) = 'IEX_STRATEGY_WORK_CATEGORY'
and witemT.enabled_flag = 'Y'
and witemT.ORG_ID = HROU.ORGANIZATION_ID(+)
and (witemT.org_id is null or witemT.org_id=:1)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)