Solved

MRP Batch Job Hit Error

  • 21 September 2020
  • 1 reply
  • 206 views
K
Rank
Userlevel 3
Badge +6

Hi All,

I am using IFS 7.5 and running “Perform Site MRP” batch job.

System hit error as below and not able to proceed to create PR.

Anyone know what should I check?

Thanks.

 

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "IFSAPP.MRP_PROCESS_API", line 3339
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "IFSAPP.MRP_PROCESS_API", line 3004
ORA-20110: PurchaseReqLinePart.NEG_QTY_: The quantity must be greater than 0.

icon

Best answer by kimsiang 23 September 2020, 07:36

View original

1 reply

K
Rank
Userlevel 3
Badge +6

Hi All, I already found the solution.

 

The query in MRP_PROCESS_API has perform rounding on the qty.

original_qty_  => Inventory_Part_API.Get_Calc_Rounded_Qty(
                               :contract,
                               :part_no,
                                supply_rec_.supply_qty)

 

Use below query to find out which Part Number that Supply_Qty might be rounded to zero.

SELECT part_no, supply_qty, required_date
FROM mrp_part_supply_demand_tab
WHERE contract = '[SITE]'
AND round(supply_qty,0) <= 0
AND mrp_source = 'MRPBUY'
order by part_no

 

Then, go to IFS APP → Inventory Part → Acquisition tab.

Check and change the “Qty Calc Rounding” value accordingly so that it wouldn’t be rounded to zero.

 

Thanks.

Reply


Terms & ConditionsCookie settings