Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004789Openbravo ERP09. Financial managementpublic2008-09-01 19:152008-09-04 16:18
ReporterjacoboGiralt 
Assigned Tocromero 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004789: Remittance Cancellation/Return doesn't work with PostgresSQL
DescriptionWhen you cancel a remittance in this window it fails with the following error:

function ad_get_doctype (character varying, character varying, "unknown") does not exist.
Steps To Reproduce1. Create a Remittance
2. Complete it
3. Go to Remittance Cancellation/Return window and select the generated payments
4. Fill the form and click return.
Proposed SolutionIt seems to be the typical issue with oracle/postgres differences. Some to_number() are needed. Not only in the calls to ad_get_doctype but also in the inserts for every numeric column.

The file that should be changed is: org/openbravo/erpCommon/ad_forms/RemittanceCancel_data.xsql
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0004792 closed cromero Remittance Cancellation/Return doesn't work with PostgresSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-01 19:15jacoboGiraltNew Issue
2008-09-01 19:15jacoboGiraltAssigned To => cromero
2008-09-01 19:15jacoboGiraltsf_bug_id0 => 2087206
2008-09-02 08:33cromeroNote Added: 0008839
2008-09-02 08:33cromeroStatusnew => feedback
2008-09-02 09:36jacoboGiraltNote Added: 0008843
2008-09-02 10:28cromeroStatusfeedback => scheduled
2008-09-02 10:28cromerofix_in_branch => trunk
2008-09-02 10:56jacoboGiraltIssue Monitored: jacoboGiralt
2008-09-02 17:01svnbotCheckin
2008-09-02 17:01svnbotNote Added: 0008851
2008-09-02 17:01svnbotStatusscheduled => resolved
2008-09-02 17:01svnbotResolutionopen => fixed
2008-09-02 17:01svnbotsvn_revision => 6742
2008-09-04 16:18psarobeRegression testing => No
2008-09-04 16:18psarobeStatusresolved => closed
2008-09-04 16:18psarobeFixed in Version => 2.40

Notes
(0008839)
cromero   
2008-09-02 08:33   
Could you please specify your working environment?
(0008843)
jacoboGiralt   
2008-09-02 09:36   
I tested it on

OpenbravoERP 2.35mp5
PostgreSQL 8.2
Java 1.5
ant 1.7.0
Linux
(0008851)
svnbot   
2008-09-02 17:01   
Repository: openbravo
Revision: 6742
Author: cromeroherrero
Date: 2008-09-02 17:01:44 +0200 (Tue, 02 Sep 2008)

Fixed bug 4789: Remittance Cancellation/Return doesn't work with PostgresSQL

---
U trunk/src/org/openbravo/erpCommon/ad_forms/RemittanceCancel.java
U trunk/src/org/openbravo/erpCommon/ad_forms/RemittanceCancel_data.xsql
U trunk/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql
U trunk/src/org/openbravo/erpCommon/utility/SequenceIdData.java
U trunk/src/org/openbravo/erpCommon/utility/Sequence_data.xsql
U trunk/src/org/openbravo/erpCommon/utility/Utility.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=6742&sc=1 [^]