Errors : Landed Cost Adjustments Import Process eBS R12

To run : Landed Cost Adjustments Import Process

Error : 

01. ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Action :

Check data by SQL: 

select * from PON_PRICE_ELEMENT_TYPES_TL where length(name) > 25;

select price_element_code from PON_PRICE_ELEMENT_TYPES where PRICE_ELEMENT_TYPE_ID in
(select PRICE_ELEMENT_TYPE_ID from PON_PRICE_ELEMENT_TYPES_TL where length(name) > 25); 

if exists then follow the solution:

Solution :

Please run the following script on the TEST instance:

update PON_PRICE_ELEMENT_TYPES_TL set name = substr(name, 0, 30) where length(name) > 30;
commit;

After this verify the outcome of the update using the following query:

select * from PON_PRICE_ELEMENT_TYPES_TL where length(name) > 30;

After this run the Landed Cost Adjustments Import Process request and see if it still completes in error.

Error :
02. Input parameters Legal entity / Id PFL_LE/23275 Cost component class ID null for Charge type component The line was not processed Rcv Ttransaction ID: 817450 Ship Num: 0000020015020210 Ship Line Num: 1 Item ID: 9781 Organization ID: 263 Adjustment Num: 0

Action :

Check data by SQL:  

 select PRICE_ELEMENT_TYPE_ID, PRICE_ELEMENT_CODE,  COST_COMPONENT_CLASS_ID,COST_ANALYSIS_CODE  from PON_PRICE_ELEMENT_TYPES t
 where COST_COMPONENT_CLASS_ID is null or COST_ANALYSIS_CODE is null

Find the Last one which you have updated or included or last time you have used in your application.

Solution :

Add cost component class and analyses code on all cost factors that are used for LCM charges.
Navigation Path Purchasing Super User (process Operations) responsibility, Setup – Purchasing – Cost Factors

2. Re-run the Landed Cost Adjustments Import Process