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 
Review Assigned To
Web browser
ModulesCore
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: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