LCM shipment page: oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation (Doc ID 1667109.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Landed Cost Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, LCM shipment page

Error Page  
Exception Details 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT DISTINCT LineResultsEO.SHIP_HEADER_ID, LineResultsEO.ORGANIZATION_ID,  LineResultsEO.LOCATION_ID, LineResultsEO.ORG_ID,LineResultsEO.SHIP_TYPE_ID, LineResultsEO.SHIP_TYPE_CODE, LineResultsEO.SHIP_NUM, LineResultsEO.SHIP_DATE, LineResultsEO.SHIP_STATUS_CODE, LineResultsEO.pending_matching_flag AS pending_matching_flag, NVL(LineResultsEO.pending_matching_flag,'N') AS res_pending_matching_flag,MO_GLOBAL.get_ou_name (org_id) operating_unit,DECODE(ship_status_code,'COMPLETED', 'ShipHdrUpdateDisabled', 'ShipHdrUpdateEnabled') AS update_switcher,DECODE(ship_status_code,'COMPLETED', 'ShipHdrDeleteDisabled','ShipHdrDeleteEnabled') AS delete_switcher,LineResultsEO.ship_type_name FROM INL_SHIP_PO_OVERALL_V LineResultsEO WHERE LineResultsEO.simulation_id IS NULL AND   organization_id = :1 AND (src_type_code = :2 OR src_type_code IS NULL) ORDER BY ship_header_id DESC
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)

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