iProcurement gives a JBO-27122 error and ORA-00600 arguments [qkeIsExprReferenced1] error when opening iProcurement home page. (Doc ID 1464038.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Symptoms

iProcurement gives a JBO-27122 error and ORA-00600 arguments [qkeIsExprReferenced1] error when opening the iProcurement home page.

Error

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT
pl.requisition_header_id AS HeaderId,
pl.requisition_line_id AS LineId,
pl.item_description AS ItemDescription,
decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity,
decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount,
decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency,
mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning,
po_line_types.purchase_basis AS PurchaseBasis,
po_line_types.order_type_lookup_code AS ValueBasis,
ph.contractor_requisition_flag AS ContractorFlag,
decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered,
decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered,
decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered,
decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered
FROM po_requisition_headers_all ph, po_requisition_lines_all pl,
po_line_types, mtl_units_of_measure_tl
WHERE
ph.requisition_header_id = pl.requisition_header_id
AND nvl(ph.contractor_requisition_flag, 'N') = 'N'
AND nvl(pl.cancel_flag, 'N') = 'N'
AND nvl(pl.closed_code, 'N') <> 'FINALLY CLOSED'
AND nvl(pl.modified_by_agent_flag, 'N') = 'N'
AND pl.line_location_id IS NULL
AND (nvl(ph.transferred_to_oe_flag, 'N') <> 'Y'
  OR pl.source_type_code = 'VENDOR')
AND pl.unit_meas_lookup_code = mtl_units_of_measure_tl.unit_of_measure(+)
AND pl.line_type_id = po_line_types.line_type_id
AND ph.requisition_header_id = :1
AND mtl_units_of_measure_tl.language(+) = :2
UNION ALL
SELECT
pl.requisition_header_id AS HeaderId,
pl.requisition_line_id AS LineId,
pl.item_description AS ItemDescription,
to_number(null) AS Quantity,
( decode(pl.currency_amount, null, pl.amount, pl.currency_amount) +
 nvl((select decode(pl2.currency_amount, null, pl2.amount, pl2.currency_amount)
  from po_requisition_lines_all pl2
  where pl.requisition_header_id = pl2.requisition_header_id
  and pl.requisition_line_id = pl2.LABOR_REQ_LINE_ID), 0)) AS Amount,
pl.currency_code AS Currency,
to_char(null) AS UomMeaning,
to_char(null) AS PurchaseBasis,
to_char(null) AS ValueBasis,
ph.contractor_requisition_flag AS ContractorFlag,
0 AS IsQuantityRendered,
1 AS IsAmountRendered,
1 AS IsCurrencyRendered,
0 AS IsUomRendered
FROM po_requisition_headers_all ph, po_requisition_lines_all pl
WHERE ph.requisition_header_id = pl.requisition_header_id
AND ph.requisition_header_id= :3
AND nvl(ph.contractor_requisition_flag, 'N') <> 'N'
AND nvl(pl.cancel_flag, 'N') = 'N'
AND nvl(pl.closed_code, 'N') <> 'FINALLY CLOSED'
AND nvl(pl.modified_by_agent_flag, 'N') = 'N'
AND pl.line_location_id IS NULL
AND (nvl(ph.transferred_to_oe_flag, 'N') <> 'Y'
  OR pl.source_type_code = 'VENDOR')
AND pl.LABOR_REQ_LINE_ID is NULL
order by LineId desc
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
at oracle.apps.icx.icatalog.shopping.webui.ShoppingCartCO.processRequest(ShoppingCartCO.java:52)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
...
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
## Detail 0 ##
java.sql.SQLException: ORA-00600: internal error code, arguments: [qkeIsExprReferenced1], [], [], [], [], [], [], [], [], [], [], []

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)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
at oracle.apps.icx.por.req.server.ShoppingCartVOImpl.initQuery(ShoppingCartVOImpl.java:22)
at oracle.apps.icx.icatalog.shopping.server.ShoppingAMImpl.setCartContainerComponents(ShoppingAMImpl.java:7951)

 


Steps To Reproduce
1. Login.
2. Navigate to iProcurement home page.
- Get 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