FSTP Error: JBO-27122: SQL ERROR ORA-1008 - When Trying To Receive Externally Sourced Parts Requirement Purchase Order (Doc ID 2006656.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Spares Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Spares Logistics

When attempting to receive a PO which has been created in Parts Requirement the following error occurs.

ERROR
You have encountered an unexpected error. Please contact the System Administrator for assistance.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(select flv.MEANING DOC_TYPE,
flv.LOOKUP_CODE DOC_TYPE_CODE,
ph.PO_HEADER_ID HEADER_ID ,
ph.SEGMENT1 DOCUMENT_NUMBER,
'VENDOR' SOURCE_TYPE_CODE,
'VENDOR' RECEIPT_SOURCE_CODE,
PH.VENDOR_ID ,
PH.VENDOR_SITE_ID ,
PLL.SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID,
PLL.SHIPMENT_NUM PO_SHIPMENT_NUM,
ph.PO_HEADER_ID PO_HEADER_ID,
ph.PO_HEADER_ID RCV_SHIPMENT_HEADER_ID,
ph.SEGMENT1 RCV_SHIPMENT_NUMBER,
NULL RECEIPT_NUMBER,
NULL BILL_OF_LADING ,
NULL PACKING_SLIP,
TO_DATE(NULL) SHIPPED_DATE ,
NULL FREIGHT_CARRIER_CODE, NVL(PLL.PROMISED_DATE,PLL.NEED_BY_DATE)
..
and trunc(nvl(cil.EFFECTIVE_DATE_END,sysdate)) >= trunc(sysdate)
and cil.resource_id = :1
and cil.Resource_type = :2) QRSLT WHERE (RCV_SHIPMENT_HEADER_ID = :1)

..
java.sql.SQLException: ORA-01008: not all variables bound

 
STEPS
1. create a requisition with the destination as the default subinventory of the Field service Technician.
2. Aprove the requisition.
3. Create a Purchase Order from the requisition and approve it.
4. Open Field Service Technician Portal
5. Click on receive shipments.
6. Observe Purchase Order created is listed.
7. Click on receive shipments.
8. In the receiving page selct the order and apply.
Get the above mentioned exception.

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