Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010179Openbravo ERPA. Platformpublic2009-08-04 14:202009-08-19 00:00
iperdomo 
gorkaion 
immediatemajoralways
closedfixed 
202.6.28-gentoo-r5
pi 
pi 
Core
No
0010179: Complete Order (Sales/Invoices) don't work after the change to hook up some PL code
The 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

* 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
No tags attached.
Issue History
2009-08-04 14:20iperdomoNew Issue
2009-08-04 14:20iperdomoAssigned To => gorkaion
2009-08-04 14:23psarobeAssigned Togorkaion => rafaroda
2009-08-04 14:23psarobeStatusnew => scheduled
2009-08-04 14:24iperdomoSummaryComplete 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:50rafarodaAssigned Torafaroda => gorkaion
2009-08-04 17:26hgbotCheckin
2009-08-04 17:26hgbotNote Added: 0018827
2009-08-04 17:26hgbotStatusscheduled => resolved
2009-08-04 17:26hgbotResolutionopen => fixed
2009-08-04 17:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/857a6367f2e8322f9d293981e9d67ca7cab6e726 [^]
2009-08-18 10:16plujanStatusresolved => closed
2009-08-19 00:00anonymoussf_bug_id0 => 2839897

Notes
(0018827)
hgbot   
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
---