My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.