Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020689Openbravo ERP03. Procurement managementpublic2012-06-06 14:102012-06-06 19:36
ReporterSandrahuguet 
Assigned Tomirurita 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020689: No items to show in Pick/Edit lines
DescriptionNo items to show in Pick/Edit lines in oracle when you've entered a purchase order and a good receipt.
Steps To ReproduceIn live.builds.openbravo.com in Oracle
-Go to Purchase Order and create:
  - Organizacion: F&B US, Inc.
  - Business Partner: Be Soft Drinker, Inc.
  - Warehouse: US West coast
  - Create line:
    - Product: Energy Drink
    - Ordered Quantity: 100
  -Book
-Go to Goods Receipt
  - Organizacion: F&B US, Inc.
  - Business Partner: Be Soft Drinker, Inc.
  - Warehouse: US West coast
  -Click in create lines from and select the order
  -Complete
Go to Return to vendor
  - Organizacion: F&B US, Inc.
  - Business Partner: Be Soft Drinker, Inc.
  - Warehouse: US West coast
   -Click in Pick/Edit lines and notice that no items to show
 
   
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-06-06 14:10SandrahuguetNew Issue
2012-06-06 14:10SandrahuguetAssigned To => mirurita
2012-06-06 14:10SandrahuguetWeb browser => Google Chrome
2012-06-06 14:10SandrahuguetModules => Core
2012-06-06 14:10SandrahuguetOBNetwork customer => No
2012-06-06 15:37SandrahuguetWeb browserGoogle Chrome => Google Chrome
2012-06-06 15:37SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3529#r3529
2012-06-06 18:18hgbotCheckin
2012-06-06 18:18hgbotNote Added: 0049660
2012-06-06 18:18hgbotStatusnew => resolved
2012-06-06 18:18hgbotResolutionopen => fixed
2012-06-06 18:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ccf2ac5489d8cec6d5ede8517e3238074105a1d1 [^]
2012-06-06 19:36dmiguelezStatusresolved => closed
2012-06-06 19:36dmiguelezFixed in Version => pi

Notes
(0049660)
hgbot   
2012-06-06 18:18   
Repository: erp/devel/pi
Changeset: ccf2ac5489d8cec6d5ede8517e3238074105a1d1
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Wed Jun 06 18:18:15 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ccf2ac5489d8cec6d5ede8517e3238074105a1d1 [^]

Fixes issue 20689: No items to show in Pick/Edit lines.
In Oracle COALESCE is replaced by NVL. NVL it is trying to do a type conversion
and the select is not returning any record (adding a to_char it works).
The order or comparation has been changed to prevent type comparation problems

---
M src-db/database/sourcedata/AD_TAB.xml
---