Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2015-01-09 14:342015-02-04 20:34
ReporteraferrazView Statuspublic 
Assigned Toumartirena 
PrioritynormalResolutionfixedFixed in Version3.0PR15Q2
StatusclosedFix in branchFixed in SCM revision71010e80cfed
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0028554: Error is shown when creating a landed cost from a goods receipt in Oracle

DescriptionWhen landed cost is created from Goods Receipt window, an error is shown if Oracle database is being used.
Steps To ReproduceWith QA Testing Admin:

- Create a Purchase Invoice with "Transportation Cost" product
- Create a Goods Receipt
- Move to Landed Cost tab, create new with "Transportation Cost" landed cost type and select previous created invoice in invoice line field.
- Save the landed cost and an error message is shown:
Saving failed. ORA-01403: no data found ORA-06512: at "ERP_PI_ORACLE.M_LC_COST_CHK_TRG", line 32 ORA-04088: error during execution of trigger 'ERP_PI_ORACLE.M_LC_COST_CHK_TRG'
TagsNo tags attached.
Attached Filespng file icon LandedCost.png [^] (164,459 bytes) 2015-01-09 14:34

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
hgbot (developer)
2015-01-14 09:40

Repository: erp/devel/pi
Changeset: 71010e80cfed9d824178ac9a7d75286cbcf933e9
Author: Unai Martirena <unai.martirena <at>>
Date: Wed Jan 14 09:39:32 2015 +0100
URL: [^]

Fixes bug 28554: No error is shown now in oracle creating LC from Goods receipt

The problem was in 'SELECT PROCESSED INTO v_Processed FROM M_LandedCost WHERE M_landedcost_ID=v_M_LandedCost_ID' statement. If no result is given in the select, in postgres no value is inserted in v_Processed but it works, but in oracle it fails. To fix this an check has been added to execute this statement only when v_M_LandedCost_ID is not null.
An if statement has been added in case v_M_LandedCost_ID is null and v_m_Inout_ID is not (Goods Receipt window), to prevent adding, updating or inserting Landed Cost Cost records when the Goods Receipt is processed.
Finally, in case of updating, the restriction of not being able to change landed cost header has been removed. This was causing problems when launching Cost Background for a Goods Receipt with Landed Cost Cost records, because this process creates the Landed Cost Header and assigns to Landed Cost Cost records.

M src-db/database/model/triggers/M_LC_COST_CHK_TRG.xml
Sandrahuguet (developer)
2015-01-19 17:42

Code review + testing OK
hudsonbot (developer)
2015-02-04 20:34

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2015-01-09 14:34 aferraz New Issue
2015-01-09 14:34 aferraz Assigned To => umartirena
2015-01-09 14:34 aferraz File Added: LandedCost.png
2015-01-09 14:34 aferraz Modules => Core
2015-01-09 14:34 aferraz Triggers an Emergency Pack => No
2015-01-14 09:40 hgbot Checkin
2015-01-14 09:40 hgbot Note Added: 0073484
2015-01-14 09:40 hgbot Status new => resolved
2015-01-14 09:40 hgbot Resolution open => fixed
2015-01-14 09:40 hgbot Fixed in SCM revision => [^]
2015-01-19 17:42 Sandrahuguet Review Assigned To => Sandrahuguet
2015-01-19 17:42 Sandrahuguet Note Added: 0073619
2015-01-19 17:42 Sandrahuguet Status resolved => closed
2015-01-19 17:42 Sandrahuguet Fixed in Version => 3.0PR15Q2
2015-02-04 20:34 hudsonbot Checkin
2015-02-04 20:34 hudsonbot Note Added: 0074145

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker