Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006711Openbravo ERP06. Material requirement planning (MRP)public2008-12-22 12:402009-01-02 08:57
AinhoaPagola 
AinhoaPagola 
normalminoralways
closedfixed 
20Ubuntu 8.4
 
 
Core
No
0006711: UUID issue running Process Purchase Plan
When running Proccess Purchase Plan this error appears in Oracle:
      
Error:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

And this one in PostgreSQL:

function mrp_run_initialize(character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, numeric, timestamp without time zone, unknown) does not exist.
Login as Openbravo Admin.
Go to Material requirement Planning > Purchase Plan.
Create a new Purchase plan.
Create a line for the purchase plan.
Click on Process Purchase Plan.
The parameter p_run in mrp_run_initialize should be varchar instead of number.
comsup_sprint3
Issue History
2008-12-22 12:40AinhoaPagolaNew Issue
2008-12-22 12:40AinhoaPagolaAssigned To => rafaroda
2008-12-22 12:40AinhoaPagolasf_bug_id0 => 2458321
2008-12-22 12:40AinhoaPagolaRegression testing => No
2008-12-22 12:40AinhoaPagolaAssigned Torafaroda => AinhoaPagola
2008-12-22 12:41svnbotCheckin
2008-12-22 12:41svnbotNote Added: 0011646
2008-12-22 12:41svnbotStatusnew => resolved
2008-12-22 12:41svnbotResolutionopen => fixed
2008-12-22 12:41svnbotsvn_revision => 11454
2008-12-23 12:34AinhoaPagolaTag Attached: comsup_sprint3
2009-01-02 08:57krishnaStatusresolved => closed

Notes
(0011646)
svnbot   
2008-12-22 12:41   
Repository: openbravo
Revision: 11454
Author: AinhoaPagola
Date: 2008-12-22 12:41:53 +0100 (Mon, 22 Dec 2008)

Fixes bug 0006711. Process Purchase Plan: uuid issue.

---
U trunk/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11454&sc=1 [^]