R12: OIE: "Unexpected Error" Thrown When Users Click the Next button on the Expense Allocations Page After Entering Project Info (Doc ID 1500936.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
Create Expense Report
Project Accounting
Task LOV
Checked for relevancy 2/11/2016
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

Symptoms

Project view is occasionally failing with the following Unexpected Error when data is entered into the OIE product:



Steps to Recreate
-------------------
1) Enter a new expense report in the OIE related "iExpense" responsibility for a Project enabled employee.
2) Enter required data on the General Information page, then select Next
3) Enter a Cash receipt (example, expense type "Auto Rental Gas" for 10.00 USD, date: 31-Jul-2012.
4) Select the Details icon and enter any required fields, then Return button
5) On the Expense Allocations page for the expense type, attempt to enter the following information (example):
Project: 163314 Task: 00108VC Project Expenditure Organization: 01473
6) Select Next button, Unexpected Error occurs.
7) Select error detail and see the error is actually with the PA view 'PA_TASKS_EXPEND_V':

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT *
T.TASK_NAME TASK_NAME,
T.TASK_ID TASK_ID,
T.PROJECT_NUMBER PROJECT_NUMBER,
T.PROJECT_ID PROJECT_ID,
T.START_DATE TASK_START_DATE,
T.COMPLETION_DATE TASK_COMPLETION_DATE,
AP_WEB_FND_LOOKUPS_PKG.getYesNoMeaning(T.CHARGEABLE_FLAG) ALLOW_CHARGES
FROM PA_TASKS_EXPEND_V T
WHERE T.CHARGEABLE_FLAG = 'Y') QRSLT WHERE (( PROJECT_ID = :1 AND UPPER(TASK_NUMBER) like UPPER(:2) AND (TASK_NUMBER like :3 OR TASK_
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
...
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
...

Expected Behavior
---------------------------
The PA view 'PA_TASKS_EXPEND_V should always return the same result when the same data is entered.

Changes

 

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