My Oracle Support Banner

LCM Generate Charges for Blanket PO Err ORA-01403 INL_SHIPMENT_PVT (Doc ID 1386141.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Landed Cost Management - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to Generate Charges in Landed Cost Management Shipments Workbench for Blanket Purchase Agreements and Consignments, the following error occurs.

This error only for shipments related to PO and Blanket Purchase Agreements and Consignments only.
This works for regular Standard Purchase Order shipments

ERROR
-----------------------

ORA-01403: no data found in Package INL_SHIPMENT_PVT Procedure Check_PoPriceTolerance




STEPS
-----------------------
1. Responsibility: Purchasing Super User\
2. Navigation: Purchase Orders, Purchase Orders
3. Create Blanket Purchase Order Agreement with Operating Unit
4. Create Consign Standard Purchase Order : PO#
5. Responsibility: Landed Cost management
Navigation: Landed Cost management Shipments Workbench
6. Create PO Shipment and add LCM Charges for the shipment
PO#
Shipment#
LCM Charges Lbs

7. Error while creating LCM Charges for this PO Shipment
ORA-01403: no data found in Package INL_SHIPMENT_PVT Procedure Check_PoPriceTolerance

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