My Oracle Support Banner

"ORA-00904: "POL"."ORDER_TYPE_LOOKUP_CODE"."PLL"."OUTSOURCED_ASSEMBLY": invalid identifier" Error When User Is Trying To Create ASN (Doc ID 2580996.1)

Last updated on AUGUST 26, 2019

Applies to:

Oracle iSupplier Portal - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When user is trying to create Advance Shipment Notices (ASN), the following error occurs


ERROR
-----------------------
Error Page:
-------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.



Exception Details.
----------------------
Exception Details.  
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT /*  leading (PLL) NO_MERGE( PLL ) USE_NL( PLL POH ) */
    POH.SEGMENT1 PO_NUMBER,
    PRL.RELEASE_NUM RELEASE_NUM,
    DECODE(PRL.PO_RELEASE_ID, NULL, POH.clm_document_number, POH.clm_document_number || '-' || TO_CHAR(PRL.RELEASE_NUM)) DISPLAY_PO_NUMBER,
    POL.LINE_NUM LINE_NUM,
    POL.ITEM_ID ITEM_ID,
    POL.ITEM_REVISION ITEM_REVISION,
    POL.ITEM_DESCRIPTION ITEM_DESCRIPTION,
    POL.VENDOR_PRODUCT_NUM SUPPLIER_ITEM_NUMBER,
    NVL(PLL.PROMISED_DATE, PLL.NEED_BY_DATE) DUE_DATE,
    PLL.RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE,
    PLL.DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED,
    PLL.DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED,
    POL.UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE,
    TO_NUMBER(NULL) SHIPMENT_QUANTITY,
.....

PVS.PAY_ON_CODE PAY_ON_CODE,
    PLL.CONSIGNED_FLAG CONSIGNED_FLAG,
    PLL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID,
    POL.SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER,
    nvl(POH.SHIPPING_CONTROL,'SUPPLIER') TRANSPORTATION_ARRANGED_BY     ,    
    PLC.DISPLAYED_FIELD TAB_Display,
    NVL(MSI.PRIMARY_UNIT_OF_MEASURE,POL.UNIT_MEAS_LOOKUP_CODE),
    PLL.QTY_RCV_EXCEPTION_CODE,
    NVL(POL.LINE_NUM_DISPLAY,POL.LINE_NUM) LINE_NUMBER,
    NVL(PDSH.CLM_FLAG,'N') CLM_FLAG,
    TO_NUMBER(NULL) QUANTITY_SHIPPED,
    DECODE(POL.CLM_UNDEF_FLAG,'Y','Yes','No') UNDEF_STS,
    POL.ORDER_TYPE_LOOKUP_CODE.
    PLL.OUTSOURCED_ASSEMBLY
  FROM
      PO_HEADERS_ALL    POH,
      PO_LINES_ALL    POL,
      PO_LINE_LOCATIONS_ALL     PLL,

......

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "POL"."ORDER_TYPE_LOOKUP_CODE"."PLL"."OUTSOURCED_ASSEMBLY": invalid identifier

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. iSupplier Portal Responsibility ->
2. Shipment Notices ->
3. Create Advance Shipment Notices
4. Error occurs

Changes

 

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