My Oracle Support Banner

R12: OIE: Unable to Select Expense Location XXX. System Throws Unexpected Error (Doc ID 2981865.1)

Last updated on OCTOBER 22, 2023

Applies to:

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

Symptoms

When attempting to create Expense Report with Expense Type: "Hotel Stay" and Expense Location: XXX. After selecting the Expense Location, immediately the following error occurs.

"You have encountered an unexpected error"

Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to IExpense Responsibility
2. Create a new Expense Report with Expense Type: "Hotel Stay" and Expense Location: XXX
3. Error occur immediately after selecting the Expense Location.
4. Click on Exception details. Following error has occurred. 

Exception Details.
oracle.apps.fnd.framework.OAExceptionoracle.jbo.SQLStmtException: JBO-27122: 
SQL error during statement preparation.  Statement: SELECT * FROM (Select 
POLICY_LINE_ID,
       pl.POLICY_ID,
       CURRENCY_CODE,
       MEAL_LIMIT,
       TICKET_CLASS_DOMESTIC,
       TICKET_CLASS_INTERNATIONAL,
       sp.MIN_DAYS,
       CALCULATION_METHOD,
       sp.start_date,
       rate,
       DECODE(pl.TOLERANCE, null, sp.TOLERANCE, 0, nvl(sp.TOLERANCE, 0), 
pl.TOLERANCE) AS TOLERANCE,
       nvl(rate,0)*(1+nvl(pl.TOLERANCEnvl(sp.TOLERANCE, 0))/100) AS 
RATE_PLUS_TOLERANCE,
       nvl(meal_limit,0)*(1+nvl(pl.TOLERANCEnvl(sp.TOLERANCE, 0))/100) AS 
MEAL_LIMIT_PLUS_TOLERANCE,
DECODE(pl.REIMBURSEMENT_PERCENTAGE, null, sp.REIMBURSEMENT_PERCENTAGE
pl.REIMBURSEMENT_PERCENTAGE) as REIMBURSEMENT_PERCENTAGE,
pl.MAX_RECEIPT_AMT
from AP_POL_LINES pl, AP_POL_SCHEDULE_PERIODS sp
where pl.SCHEDULE_PERIOD_ID = sp.SCHEDULE_PERIOD_ID) QRSLT  WHERE 
POLICY_LINE_ID = ap_web_policy_utils.getPolicyLineId(:1, :2, :3, :4, :5)
## Detail 0 ##
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.GL_CURRENCY_API", line 58
ORA-01403: no data found
ORA-06512: at "APPS.GL_CURRENCY_API", line 39
ORA-06512: at "APPS.GL_CURRENCY_API", line 683
ORA-06512: at "APPS.GL_CURRENCY_API", line 1517
ORA-06512: at line 1
ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 6434
ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 6374

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


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