"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 laterInformation 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 |