Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008413Openbravo ERP06. Material requirement planning (MRP)public2009-04-03 10:322009-04-15 12:00
sureshbabu 
rafaroda 
highmajoralways
closedduplicate 
30
2.50beta 
 
Core
No
0008413: System throws error message when the user clicks the process purchasing plan button.
Material Requirement Planning (MRP) || Transactions || Purchasing Plan || Header

Not able to process the Purchasing plan
1) MRP || Setup || Planner: create Planner1

2) MRP || Setup || Planning Method: Pending Purchase Order and Pending Sales Order

3) update product Hammer:
Purchasing tab: minimum order qty=1, Purchasing leadtime= 14 Qty type= multiple, Standard qty=1,

4) Org specific tab: Planning method= as above created, Planner=John Planner, Minimum qty= 500, qty type= multiple, Standard qty=500, Minimum leadtime=7, safety stock=1000

5) PO: BP= Obelix and Scheduled delivery date = two weeks from now, on the line 40 Hammers

6)SO: BP=Red bunny and Scheduled delivery date = Five weeks from now, on the line 350 hammers


7)Enter Purchasing Plan:
Time horizon=60
Safety leadtime=2
Planner=John Planner
Product=Hammer
rest of the filters blank

click 'Process Purchase Plan' button.


Actual result : System throws error message as
"Error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error"

250 final review
duplicate of defect 0008208 closed areefbasha 250 VM: Purchasing Plan: Error when Processing 
jpg Error message - To Technical.JPG (183,866) 2009-04-03 10:32
https://issues.openbravo.com/file_download.php?file_id=1115&type=bug
jpg
Issue History
2009-04-03 10:32sureshbabuNew Issue
2009-04-03 10:32sureshbabuAssigned To => rafaroda
2009-04-03 10:32sureshbabuFile Added: Error message - To Technical.JPG
2009-04-03 10:32sureshbabuRegression testing => No
2009-04-03 10:33sureshbabuTag Attached: 250 final review
2009-04-09 17:34rafarodaRelationship addedduplicate of 0008208
2009-04-09 17:34rafarodaStatusnew => closed
2009-04-09 17:34rafarodaNote Added: 0015311
2009-04-09 17:34rafarodaDuplicate ID0 => 8208
2009-04-09 17:34rafarodaResolutionopen => duplicate
2009-04-15 12:00anonymoussf_bug_id0 => 2764966

Notes
(0015311)
rafaroda   
2009-04-09 17:34   
Hi Suresh,

This issue is duplicated of 0008208 which has been fixed in https://code.openbravo.com/erp/devel/pi/rev/58809e59b61c24205927bc02e528b313c3222309 [^]

Thank you for your feedback.