R12: OIE: Error When Updating an Accommodation Policy Schedule "JBO-27122 ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 1524539.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Expense Entry

After applying <patch 15976294>, when attempting to update one Accommodation Policy Schedule
the following error occurs.

ERROR
-----------------------
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ApPolLinesEO.POLICY_LINE_ID, ApPolLinesEO.SCHEDULE_PERIOD_ID, ApPolLinesEO.POLICY_ID, ApPolLinesEO.ROLE_ID, ApPolLinesEO.LOCATION_ID, ApPolLinesEO.CURRENCY_CODE, ApPolLinesEO.RATE, ApPolLinesEO.MEAL_LIMIT, ApPolLinesEO.TOLERANCE, ApPolLinesEO.TICKET_CLASS_DOMESTIC, ApPolLinesEO.TICKET_CLASS_INTERNATIONAL, ApPolLinesEO.VEHICLE_CATEGORY, ApPolLinesEO.VEHICLE_TYPE, ApPolLinesEO.FUEL_TYPE, ApPolLinesEO.RANGE_LOW, ApPolLinesEO.RANGE_HIGH, ApPolLinesEO.CALCULATION_METHOD, ApPolLinesEO.BREAKFAST_DEDUCTION, ApPolLinesEO.LUNCH_DEDUCTION, ApPolLinesEO.DINNER_DEDUCTION, ApPolLinesEO.ACCOMMODATION_ADJUSTMENT, ApPolLinesEO.MEALS_DEDUCTION, ApPolLinesEO.STATUS, ApPolLinesEO.PARENT_LINE_ID, ApPolLinesEO.CREATION_DATE, ApPolLinesEO.CREATED_BY, ApPolLinesEO.LAST_UPDATE_LOGIN, ApPolLinesEO.LAST_UPDATE_DATE, ApPolLinesEO.LAST_UPDATED_BY, AP_WEB_POLICY_UTILS.get_role(POLICY_ID,POLICY_LINE_ID,ROLE_ID) AS ROLE_DISPLAY, AP_WEB_POLICY_UTILS.get_location(LOCATION_ID) AS LOCATION_DISPLAY,
...
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 7805

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Internet Expenses Setup > Policy > Accommodation > click on Update Details for one policy (only occurs for one policy)



Changes

 Applied <patch 15976294>

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