My Oracle Support Banner

R11i: OIE: Creating Expense Reports After Enabling Expense Allocations Errors With oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during (Doc ID 336455.1)

Last updated on FEBRUARY 13, 2019

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

When attempting to create expense reports after enabling Expense Allocations, the following error occurs:


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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.