Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010179
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2009-08-04 14:202009-08-19 00:00
ReporteriperdomoView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision857a6367f2e8
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabaseOracleJava version1.6.0_14
OS Version2.6.28-gentoo-r5Database version10.2.0.4.0Ant version1.7.1
Product VersionpiSCM revisionf809d9f25348 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010179: Complete Order (Sales/Invoices) don't work after the change to hook up some PL code

DescriptionThe complete order (sales/invoice) process doesn't work in Oracle. I updated to the latest code in pi and you get an error @ERROR=ORA-01403: no data found

Steps To Reproduce* Update to the latest pi code
* Create a new order (sales/invoice)
* Try to complete
* You'll get an error message: ORA-01403: no data found

---- Example of an execution log with sqldeveloper ----
Updating PInstance - Processing 166034E69E4F4618A5B661927E179C11
AD_UPDATE_PINSTANCE
  Record_ID=C040444FA6D04C3F903A2D320963AC11
DocAction=CO, DocStatus=IP, DocType_ID=1000011, DocTypeTarget_ID=1000011, DocSubTypeSO=
DocSubTypeSO= IsBinding=Y
Reserved Warehouse=1000000, Product=1000006, Attrib=, Qty=0/10
GrandTotal=313.2
To deliver - 2168343091123077877167089387406462101800
ToInvoice - 2168343091123077877167089387406462101800
v_DocSubTypeSO -
NonInventoryDelivery
@ERROR=ORA-01403: no data found
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0018827)
hgbot (developer)
2009-08-04 17:26

Repository: erp/devel/pi
Changeset: 857a6367f2e8322f9d293981e9d67ca7cab6e726
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue Aug 04 17:23:27 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/857a6367f2e8322f9d293981e9d67ca7cab6e726 [^]

Fixed issue 10179.Fixed queries in c_invoice_post and c_order_post.

---
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
---

- Issue History
Date Modified Username Field Change
2009-08-04 14:20 iperdomo New Issue
2009-08-04 14:20 iperdomo Assigned To => gorkaion
2009-08-04 14:20 iperdomo OBNetwork customer => No
2009-08-04 14:23 psarobe Assigned To gorkaion => rafaroda
2009-08-04 14:23 psarobe Status new => scheduled
2009-08-04 14:24 iperdomo Summary Complete Order (Sales/Invoices) don't work after change to hook up some PL code => Complete Order (Sales/Invoices) don't work after the change to hook up some PL code
2009-08-04 14:50 rafaroda Assigned To rafaroda => gorkaion
2009-08-04 17:26 hgbot Checkin
2009-08-04 17:26 hgbot Note Added: 0018827
2009-08-04 17:26 hgbot Status scheduled => resolved
2009-08-04 17:26 hgbot Resolution open => fixed
2009-08-04 17:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/857a6367f2e8322f9d293981e9d67ca7cab6e726 [^]
2009-08-18 10:16 plujan Status resolved => closed
2009-08-19 00:00 anonymous sf_bug_id 0 => 2839897


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker