
Getting Error While Adding A Work Item To A Collection Strategy
(Doc ID 2533264.1)
Last updated on APRIL 14, 2022
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)
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.