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

Last updated on FEBRUARY 02, 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.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

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

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




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


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