Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022674Openbravo ERP03. Procurement managementpublic2012-12-27 06:562013-01-03 13:12
Reportersureshbabu 
Assigned Tomirurita 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS10OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tonaiaramartinez
OBNetwork customer
Web browserGoogle Chrome
ModulesOpenbravo 3.0 Framework
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
Summary0022674: Not able to complete goods receipt when the receipt is generated from Pending Goods Receipt process
DescriptionCreated a Purchase order, then to create goods receipt for the created purchase order moved to "Pending Goods Receipt" window and select the above created purchase order details and click process button.

System throws below error message,

    
Error:
Goods Receipt 10000016: ORA-01403: no data found


Note: Even i moved to Goods receipt window and tried to complete the goods receipt but still not allowing the user to complete the receipt and it throws the below error message

Error:
ORA-01403: no data found
Steps To ReproduceLogin as Openbravo/openbravo
Then change the role as QA Test Admin
Then Navigate to Purchase order window and enter below details
BP: Vendor A
Product: Raw Material A(RMA)
Qty: 11.2
Attribute: 1234

Then complete the order

Then navigate to pending goods receipt window and select the aabove created order details and also enter the

Reception date as current system date and
warehouse as Spain111

And then click Process button.

Defect: System throws below error message
    
Error:
Goods Receipt 10000016: ORA-01403: no data found

Note 1: Even when i moved to Goods receipt window and tried to complete the goods receipt but still not allowing the user to complete the receipt and it throws the below error message

Error:
ORA-01403: no data found

Note 2: In Live builds(postgres context) same functionality is working fine, and issue is only with oracle context
Note 3: The above functionality is working fine in MP17.2
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Not able to complete a goods receipt, if the goods receipt is generated from Pending Goods Receipt Window.png (137,719) 2012-12-27 06:56
https://issues.openbravo.com/file_download.php?file_id=5859&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-12-27 06:56sureshbabuNew Issue
2012-12-27 06:56sureshbabuAssigned To => dmiguelez
2012-12-27 06:56sureshbabuFile Added: Not able to complete a goods receipt, if the goods receipt is generated from Pending Goods Receipt Window.png
2012-12-27 06:56sureshbabuWeb browser => Google Chrome
2012-12-27 06:56sureshbabuModules => Openbravo 3.0 Framework
2012-12-27 06:56sureshbabuTriggers an Emergency Pack => No
2012-12-27 07:03sureshbabuWeb browserGoogle Chrome => Google Chrome
2012-12-27 07:03sureshbabuRegression level => QA functional test
2012-12-27 07:03sureshbabuversion => pi
2012-12-27 07:03sureshbabuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4218#r4218
2012-12-27 07:06sureshbabuWeb browserGoogle Chrome => Google Chrome
2012-12-27 07:06sureshbabuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4219#r4219
2012-12-27 07:17sureshbabuWeb browserGoogle Chrome => Google Chrome
2012-12-27 07:17sureshbabuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4220#r4220
2012-12-28 08:43miruritaWeb browserGoogle Chrome => Google Chrome
2012-12-28 08:43miruritaRegression levelQA functional test => Production - QA Approved
2012-12-28 08:43miruritaRegression date => 2012-12-12
2012-12-28 08:43miruritaRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/cd6ca6343835 [^]
2012-12-28 10:31miruritaAssigned Todmiguelez => mirurita
2012-12-28 10:33hgbotCheckin
2012-12-28 10:33hgbotNote Added: 0055262
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:06naiaramartinezReview Assigned To => naiaramartinez
2012-12-31 10:06naiaramartinezNote Added: 0055285
2012-12-31 10:06naiaramartinezStatusresolved => closed
2012-12-31 10:23miruritaStatusclosed => new
2012-12-31 10:23miruritaResolutionfixed => open
2012-12-31 10:23miruritaWeb browserGoogle Chrome => Google Chrome
2012-12-31 10:23miruritaTriggers an Emergency PackNo => Yes
2012-12-31 10:23miruritaStatusnew => scheduled
2012-12-31 10:23miruritafix_in_branch => pi
2012-12-31 10:23miruritaStatusscheduled => resolved
2012-12-31 10:23miruritaResolutionopen => fixed
2012-12-31 10:23miruritaStatusresolved => closed
2013-01-03 13:12hudsonbotCheckin
2013-01-03 13:12hudsonbotNote Added: 0055335

Notes
(0055262)
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
---
(0055285)
naiaramartinez   
2012-12-31 10:06   
Code Review + Testing OK
(0055335)
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