Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0002515
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementminoralways2008-01-16 11:392008-07-08 18:28
ReporteregoitzView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionfixedFixed in Version2.40beta
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002515: Error saving a purchase order when diferents date ordered

DescriptionSteps:
Procurement Managament>Transactions>Purchase order

Enviroment:
v2.35
windows xp
firefox 2.0
oracle xe 10

Description:

When you try to save a purchase order that has a order date on the headear different than the order date in the lines, you get an error. You can see it on the image attached.

It ocurrs because when you save the purchase, the C_ORDER_TRG trigger is executed because you are updating c_order table.

Then this triger update the c_orderline table, so the C_ORDERLINE_TRG2 trigger is executed.

In this trigger there is a select from c_order table but it can't be done (this is what causes the error) because the c_order table is blocked,because it is the table that has launched the trigger.



TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0003623 closedrafaroda Error saving a purchase order when diferents dat 

-  Notes
(0003031)
psarobe (viewer)
2008-01-21 19:38
edited on: 2008-06-12 09:24

 Logged In: YES
user_id=1500703
Originator: NO

The problem is in this part of the code:

IF UPDATING THEN
  IF ((:NEW.DateOrdered != :OLD.DateOrdered)
     OR (COALESCE(:NEW.PriceActual,0) != COALESCE(:OLD.PriceActual,0))
     OR (COALESCE(:NEW.PriceList,0) != COALESCE(:OLD.PriceList,0))
     OR (COALESCE(:NEW.M_Product_ID,0) != COALESCE(:OLD.M_Product_ID,0))
  OR (COALESCE(:NEW.QtyOrdered,0) != COALESCE(:OLD.QtyOrdered,0)))
 THEN
  DELETE FROM C_ORDERLINE_OFFER
  WHERE C_OrderLine_ID = :NEW.C_OrderLine_ID;
   v_Insert := TRUE;
 END IF;
 END IF;

 IF INSERTING OR v_Insert THEN
   SELECT C_BPartner_ID, PricePrecision, M_PriceList_ID
     INTO v_BPartner_ID, v_Precision, v_PriceList_ID
     FROM C_ORDER o,
          C_CURRENCY c
    WHERE C_Order_ID = :NEW.C_Order_ID
      AND o.C_Currency_ID = c.C_Currency_ID;
(0003032)
rafaroda (viewer)
2008-02-08 16:54
edited on: 2008-06-12 09:24

 Logged In: YES
user_id=1892190
Originator: NO

Steps to reproduce:
1. Create a new Purchase Order (Procurement Management > Transactions >
Purchase Order). Save.
2. Create a new line (Procurement Management > Transactions > Purchase
Order > Lines). Save.
3. Go back to Purchase Order.
4. Change Order Date. Save.
5. Change Order Reference (or Description or Service Point) and try to
save.
(0003033)
rafaroda (viewer)
2008-02-22 11:38
edited on: 2008-06-12 09:24

 Logged In: YES
user_id=1892190
Originator: NO

Deleted lines in C_ORDER_TRG that updated C_ORDERLINE_TRG2.
(0006104)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:43

 This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1872661 [^]

- Issue History
Date Modified Username Field Change
2008-07-08 18:28 plujan Status resolved => closed
2008-07-08 18:28 plujan Fixed in Version 2.40alpha-r2 => 2.40beta

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker