Expense Allocations Oracle.Apps.Fnd.Framework.Oaexception: Jbo-27122

(Doc ID 336455.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Expenses - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

After enabling Expense Allocations, attempting to create an expense report and  encounter the
following error:

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation. Statement: select seg.application_column_name,
seg.segment_name,
seg.segment_num,
seg.flex_value_set_id,
seg.form_left_prompt,
seg.required_flag,
val.flex_value_set_name,
FUN_KFF_VIEW_FUNC_PKG.derive_format_attributes(
seg.flex_value_set_id, :b0) qualifiers
from fnd_id_flex_segments_vl seg,
fnd_flex_value_sets val,
fnd_application apps
where seg.flex_value_set_id = val.flex_value_set_id
and apps.application_short_name = :b1
and seg.application_id = apps.application_id
and enabled_flag = 'Y'
and display_flag = 'Y'
and id_flex_code = :b2
and id_flex_num = ( select id_flex_num
from fnd_id_flex_structures_vl flex
where flex.application_id = apps.application_id
and id_flex_code = :b3
and id_flex_structure_code = :b4)
order by segment_num

Changes

Upgrade to OIE.J patchset

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