My Oracle Support Banner

R12: OIE: When Click The Create Expense Report Button : You Have Encountered An Unexpected Error - Contact System Administrator (Doc ID 2800449.1)

Last updated on AUGUST 24, 2021

Applies to:

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

Symptoms

On : 12.2.10 version, Expenses

When Click The Create Expense Report Button : You have encountered an unexpected error - contact system administrator

Following error is shown: Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT AP_WEB_DB_CCARD_PKG.GetLocation(merchant_city , merchant_province_state) AS LOCATION,
ApCreditCardTrxnsAll.TRX_ID,
ApCreditCardTrxnsAll.CARD_PROGRAM_ID,
ApCreditCardTrxnsAll.TRANSACTION_DATE,
ApCreditCardTrxnsAll.TRANSACTION_AMOUNT,
ApCreditCardTrxnsAll.BILLED_AMOUNT,
ApCreditCardTrxnsAll.POSTED_CURRENCY_CODE,
ApCreditCardTrxnsAll.BILLED_CURRENCY_CODE,
...........
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
............

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
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.