Requisition Approval Error: JBO-27122: SQL Error During Statement Preparation (Doc ID 1574236.1)

Last updated on AUGUST 02, 2016

Applies to:

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

Symptoms

<p >*Symptoms
<span >Briefly describe the symptoms of the problem. Remember to delete any customer specific information

When attempting to open a requisition for approval, an error occurs.


Error

...
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT
PRL.LINE_NUM,
PRL.REQUISITION_LINE_ID,
PRL.ITEM_DESCRIPTION,
PRL.NEED_BY_DATE,
PRL.UNIT_MEAS_LOOKUP_CODE,
PRL.UNIT_PRICE,
PRL.QUANTITY,
PRL.DELIVER_TO_LOCATION_ID,
HLT.LOCATION_CODE DELIVER_TO_LOCATION,
PRL.QUANTITY * PRL.UNIT_PRICE TOTAL,
PRL.SOURCE_TYPE_CODE,
PH.PO_HEADER_ID HEADER_ID,
...
...
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)

 

If change the POR: Default Currency Conversion Rate Type from "Corporate" to "PEG", the error will not show up (PEG Rate used for iProcurement Currency Conversion).
Changing the Default Currency Rate Type is may not be an option as the profile has not been changed to "PEG" even in 11.5.10.

 

Steps To Reproduce
1. Go to iProcurement.
2. Create a requisition. and submit for approval.
3. Requisition goes to IN PROCESS status.
4. Go to Worklist and try to open the notification.
5. Observe the error.
6. Go to iProcurement > Requisitions > Search for the requisition.
9. Try to open it, see the error.



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