My Oracle Support Banner

Getting Error While Searching PO On New Shipment (Doc ID 2502893.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Landed Cost Management - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.


Landed Cost

When attempting to find purchase order in LCM Workbench under Shipment Lines, the following error occurs.

You have encountered an unexpected error.
Exception details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

1. Navigate to LCM Workbench
2. Click on Create button to create new shipment
3. Entered 3rd Party and 3rd Party site info
4. Clicked on Lines and tried to find purchase order but it gave error. Other search criteria are working fine


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.