Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022691Openbravo ERP03. Procurement managementpublic2012-12-27 18:542013-01-03 13:12
Reportersureshbabu 
Assigned Tomirurita 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tonaiaramartinez
OBNetwork customerNo
Web browserGoogle Chrome
ModulesOpenbravo 3.0
Support ticket
Regression levelProduction - QA Approved
Regression date2012-12-12
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/cd6ca6343835 [^]
Triggers an Emergency PackYes
Summary0022691: [Reg] Not able to complete Return to Vendor Shipment document in Oracle context
DescriptionIn PI oracle context, user not able to complete "Return to Vendor shipment" document after selecting the Return to vendor details using Pick/Edit lines option.

Steps To ReproduceLogin as Openbravo/openbravo

Change the role to QA Testing Admin

1)Create and complete purchase order using below details.
BP: Vendor A
product: Raw Material A (RMA)
Qty: 11.2
Attribute: 1234

2) Then create a goods receipt using the above created purchase order details using create lines from option

BP: Vendor A
Product: Raw material A(RMA)
Qty: 11.2
Attribute: 1234


3) Then create "Return to Vendor" document using below details
Click Ctrl + I to insert new record

Then select BP: Vendor A

Click "Pick/Edit Lines" button
In Pick/Edit lines tab, select the above created Goods shipment line item
And enter Return: 5.6

Then click Done button

Then click Book button to book the "Return to Vendor" document


4) Then Navigate to Return to vendor Shipment document and click Ctrl + I to insert new record

BP: Vendor A
Then click "Pick/Edit lines" button
In the "Pick/Edit lines" tab, select the above created Return to vendor document details and enter shipment field as 2.6

Then click Done button

Then click complete button to complete the "Return to Vendor shipment" document


Defect: Right now system throws error message as
 
Error:ORA-01403: no data found

Note: The same functionality is working fine in Postgres context
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Not able to complete Return to vendor shipment document in Oracle context.png (97,536) 2012-12-27 18:54
https://issues.openbravo.com/file_download.php?file_id=5867&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-12-27 18:54sureshbabuNew Issue
2012-12-27 18:54sureshbabuAssigned To => dmiguelez
2012-12-27 18:54sureshbabuFile Added: Not able to complete Return to vendor shipment document in Oracle context.png
2012-12-27 18:54sureshbabuWeb browser => Google Chrome
2012-12-27 18:54sureshbabuModules => Openbravo 3.0
2012-12-27 18:54sureshbabuOBNetwork customer => No
2012-12-27 18:54sureshbabuTriggers an Emergency Pack => No
2012-12-28 09:43gorkaionWeb browserGoogle Chrome => Google Chrome
2012-12-28 09:43gorkaionRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/cd6ca6343835 [^]
2012-12-28 10:31miruritaWeb browserGoogle Chrome => Google Chrome
2012-12-28 10:31miruritaRegression level => Production - QA Approved
2012-12-28 10:31miruritaRegression date => 2012-12-12
2012-12-28 10:31miruritaAssigned Todmiguelez => mirurita
2012-12-28 10:33hgbotCheckin
2012-12-28 10:33hgbotNote Added: 0055263
2012-12-28 10:33hgbotStatusnew => resolved
2012-12-28 10:33hgbotResolutionopen => fixed
2012-12-28 10:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0bd62a50db371215c10d2694b8b51510be8b326c [^]
2012-12-31 10:01naiaramartinezReview Assigned To => naiaramartinez
2012-12-31 10:01naiaramartinezNote Added: 0055284
2012-12-31 10:01naiaramartinezStatusresolved => closed
2012-12-31 10:22miruritaStatusclosed => new
2012-12-31 10:22miruritaResolutionfixed => open
2012-12-31 10:22miruritaWeb browserGoogle Chrome => Google Chrome
2012-12-31 10:22miruritaTriggers an Emergency PackNo => Yes
2012-12-31 10:22miruritaStatusnew => scheduled
2012-12-31 10:22miruritafix_in_branch => pi
2012-12-31 10:22miruritaStatusscheduled => resolved
2012-12-31 10:22miruritaResolutionopen => fixed
2012-12-31 10:22miruritaStatusresolved => closed
2013-01-03 13:12hudsonbotCheckin
2013-01-03 13:12hudsonbotNote Added: 0055336

Notes
(0055263)
hgbot   
2012-12-28 10:33   
Repository: erp/devel/pi
Changeset: 0bd62a50db371215c10d2694b8b51510be8b326c
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Fri Dec 28 10:33:01 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0bd62a50db371215c10d2694b8b51510be8b326c [^]

Fixes issue 22674. Fixes issue 22691. ORA-01403 in M_Inout_Post

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0055284)
naiaramartinez   
2012-12-31 10:01   
Code Review + testing OK
(0055336)
hudsonbot   
2013-01-03 13:12   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/792728467ed0 [^]

Maturity status: Test