INLOIP Shipments Interface Import/ Simulation Err Ora-20001 Conversion Not Defined (Doc ID 1299346.1)

Last updated on OCTOBER 17, 2015

Applies to:

Oracle Landed Cost Management - Version 12.1.2 and later
Information in this document applies to any platform.
Checked for relevance on 04-Jan-2015

Symptoms



When attempting to run Shipments Interface Import, it errors with:

  INL.PLSQL.INL_INTERFACE_PVT.Import_LCMShipments >> User-Defined Exception

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


Also:

When attempting to create Simulation - using 'Simulate' button
the following error occurs.


ORA-20001: Conversion is not defined for PKC10092 from CS-Case to LB-Pounds. ORA-06512: at "APPS.INL_LANDEDCOST_PVT", line 561 in Package INL_LANDEDCOST_PVT Procedure Manage_Proportion

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