R11i: OIE: Create a New Expense Report Errors With "You Have Encountered An Unexpected Error...Fun_kff_view_func_pkg" (Doc ID 300673.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Internet Expenses - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
JBO-27122
FUN_KFF_VIEW_FUNC_PKG.derive_format_attributes
You have encountered an unexpected error. Please contact the System Administrator for assistance.

Symptoms

When attempting to create a new expense report, you encounter the error:

Error Page:
You have encountered an unexpected error.  Please contact the System Administrator for assistance.

The error stack shows (excerpt only):

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 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java: 888) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java: 862)

Changes

Application of OIE.J patchset or OIE.K#2 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