VIEW ORDER PAGE EXCEPTION ERROR JBO-27122 ERROR AND ORA-00918 IN PM DASHBOARD. (Doc ID 2159665.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

On Release 12.1.3 version, Purchase Order Issues

When attempting to view a Purchase Order tied to a Requisition the following error occurs.

ERROR:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM
(SELECT
  POL.PO_HEADER_ID,POL.PO_LINE_ID,POL.LINE_NUM,
  MSI.CONCATENATED_SEGMENTS ITEM_NUM,
  POL.VENDOR_PRODUCT_NUM,POL.ITEM_DESCRIPTION,
  MUM.UNIT_OF_MEASURE_TL UNIT_MEAS_LOOKUP_CODE,
  POL.QUANTITY,
  nvl(POL.UNIT_PRICE,POL.AMOUNT) UNIT_PRICE,
DECODE(POL.matching_basis,'AMOUNT',POL.AMOUNT,POL.QUANTITY*POL.UNIT_PRICE) TOTAL,
  POH.SEGMENT1 PO_NUM,POH.CURRENCY_CODE,
.
..
etc..

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined


STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Sign on to Application
2. Select Responsibility: iProcurement
3. Navigation: iProcurement Home Page ->> Select: "Requisitions" Tab
4. Requisitions ->> Click: "Search" button ->> Search by: Last Name: "ABCDE" - Click: "GO"
5. Returns All  Requisitions ->> Select Any Requisition, with an Order attached
6. Select Requisition # 1234567 ->> Then Click: "1234567" Order Number ->>
7. Receive Error: Exception Details.
  oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
  Statement: SELECT * FROM
(SELECT
  POL.PO_HEADER_ID,POL.PO_LINE_ID,POL.LINE_NUM,
  MSI.CONCATENATED_SEGMENTS ITEM_NUM,
  POL.VENDOR_PRODUCT_NUM,POL.ITEM_DESCRIPTION,
  MUM.UNIT_OF_MEASURE_TL UNIT_MEAS_LOOKUP_CODE,
  POL.QUANTITY,
  nvl(POL.UNIT_PRICE,POL.AMOUNT) UNIT_PRICE,
  DECODE(POL.matching_basis,'AMOUNT',POL.AMOUNT,POL.QUANTITY*POL.UNIT_PRICE) TOTAL,
  POH.SEGMENT1 PO_NUM,POH.CURRENCY_CODE,
.
..
etc..

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot view Purchase Orders tied to Requisitions without 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