My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


On : 12.1.3 version, Landed Cost Calculation

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


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

The issue can be reproduced at will with the following steps:
1. Responsibility: Purchasing Super User\
2. Navigation: Purchase Orders, Purchase Orders
3. Create Blanket Purchase Order Agreement with Operating Unit FLA LOS ANGELES, BPA (PO) 64003006
4. Create Consign Standard Purchase Order : PO# 64003005
5. Responsibility: Landed Cost management
Navigation: Landed Cost management Shipments Workbench
6. Create PO Shipment and add LCM Charges for the shipment
PO# 64003005
Shipment# 5146 \ 5147
LCM Charges Lbs 0.12

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


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.