Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000443Openbravo ERP04. Warehouse managementpublic2008-05-26 18:172009-03-18 11:02
cromero 
cromero 
immediatecriticalalways
closedfixed 
202.40alpha
2.35MP4 
2.35MP52.35MP5 
No
Core
No
0000443: It is not possible to process an inventory
When you try to process and inventory, an error occurs because the M_INVENTORY_TRG trigger is not enable.

Error Oracle is:
ORA-04098: trigger 'TAD_BRANCH_R23X.M_INVENTORY_TRG' is invalid and failed re-validation ORA-06512: at "TAD_BRANCH_R23X.M_INVENTORY_POST", line 246 ORA-04098: trigger 'TAD_BRANCH_R23X.M_INVENTORY_TRG' is invalid and failed re-validation

Error in PostgreSQL is:
ERROR: column "v_datenull" does not exist
* Go to Warehouse Management || Transactions || Physical Inventory || Header
* Create an Inventory
* Click in "Process inventory count"
No tags attached.
Issue History
2008-05-26 18:17cromeroNew Issue
2008-05-26 18:17cromeroAssigned To => cromero
2008-05-26 18:17cromeroOBNetwork customer => N
2008-05-26 18:17cromeroStatusnew => scheduled
2008-05-26 18:18cromeroOBNetwork customerN =>
2008-05-26 18:22svnbotCheckin
2008-05-26 18:22svnbotNote Added: 0000342
2008-05-26 18:22svnbotStatusscheduled => resolved
2008-05-26 18:22svnbotResolutionopen => fixed
2008-05-27 09:41psarobeStatusresolved => new
2008-05-27 09:41psarobeResolutionfixed => open
2008-05-27 09:41psarobeSeveritymajor => critical
2008-05-27 09:41psarobeStatusnew => scheduled
2008-05-27 09:43psarobeStatusscheduled => resolved
2008-05-27 09:43psarobesvn_revision => 4561
2008-05-27 09:43psarobeResolutionopen => fixed
2008-05-30 11:21cromeroTarget Version2.35 MP4 => 2.35 MP5
2008-05-30 15:56plujanStatusresolved => closed
2008-05-30 15:56plujanFixed in Version => 2.35 MP5
2009-03-18 11:02anonymoussf_bug_id0 => 2691315

Notes
(0000342)
svnbot   
2008-05-26 18:22   
Repository: openbravo
Revision: 4561
Author: cromeroherrero
Date: 2008-05-26 18:22:32 +0200 (Mon, 26 May 2008)

Fixed bug 0000443 It is not possible to process an inventory.
This errors came from the backport of bug 261, when variable v_datenull was not declared.

---
U branches/r2.3x/database/model/triggers/M_INVENTORY_TRG.xml
---

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