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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008008
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminorsometimes2009-03-06 17:422009-06-09 00:00
Reporterneil_smithView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision1ff0231e17e7
ProjectionnoneETAnoneTarget Version
OSWindowsDatabaseAnyJava version1.6.0_12
OS VersionServer 2003Database versionAnt version1.7.1
Product VersionmainSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008008: IBAN code validation problem

DescriptionI have had problems with the IBAN code validation trigger function (c_bankaccountiban_trg).
A DATA_EXCEPTION is thrown while saving the bank account information.




Steps To Reproduce1- Go to Financial Management || Receivables & Payables || Setup || Bank and create a new record:
     1.1- Name=Banque Cantonale Neuchateloise
     1.2- Location=Switzerland
2- Go to Bank Account tab, create a new record:
     2.1- Check Show IBAN
     2.2- IBAN=CH1700766000L35376922
3- I save it -> ERROR: Incorrect IBAN Code (DATA_EXCEPTION in trigger function)
Proposed SolutionA quick fix is to enter a short bank name ('BCN' for me works).

It seems that the exception is thrown while computing the 'Displayed Account' field.
Tags250MP1
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0008737 closedrafaroda OB is out of use for Non-IBAN countries? 
related to defect 00104682.40MP11 closedvmromanos When a correct IBAN is introduced, an error appears 

-  Notes
(0014670)
rafaroda (developer)
2009-03-16 11:52

 David,

Could you please determine whether this is a bug or not?

Thanks.
(0015034)
neil_smith (reporter)
2009-03-27 11:09

 Rafa,

I don't know if I'm supposed to give feedback, I don't know any David...

Anyway, I still feel that it's a bug because I can't create a new bank with a long name and the exception thrown is not clear enough to know what is wrong. Indeed, the IBAN code I entered is correct.
I don't feel that it's a major or critical bug, but some thing should be corrected (either a clearer error message or...)

Regards
Neil.
(0015257)
walle (reporter)
2009-04-07 14:21

 Hi all
I've tried the same thing.

With the following piece of code (now in standard) in the triggerfunction 'c_bankaccountiban_trg' works fine

IF (NEW.IBAN IS NOT NULL) THEN
        SELECT MOD(TO_NUMBER(SUBSTR(NEW.IBAN, 5, LENGTH(NEW.IBAN)-4)||
           ASCII(SUBSTR(UPPER(NEW.IBAN),1,1))-55
           ||ASCII(SUBSTR(UPPER(NEW.IBAN),2,1))-55||
           SUBSTR(NEW.IBAN,3,2)),97) AS DC
           INTO v_IBAN_check
        FROM DUAL;

Rafa, I think this piece of code is needed also in the function 'c_bp_bankaccountiban_trg' otherwise the same error "incorrect Iban Code" is visualized in the business partner - bankaccount mask.

In bankaccount mask you get the error "incorrect IBAN Code" when the name of the bank is to long. for example

"BANK OF SWITZERLAND" --> in this case the IBAN=CH1700766000L35376922 can be saved
"BANK OF SWITZERLAND WITH A LOT OF MONEY" --> in this case you get the error "Incorrect IBAN Code"

Hope this helps
BR, Walter
(0015570)
psarobe (manager)
2009-04-22 17:35

 Reminder sent to: dalsasua

PLease take this one
(0015573)
dalsasua (reporter)
2009-04-22 17:58

 Yes, I detected this behavior some weeks ago. It is a bug. It will be fixed when bug fixing is scheduled again among our team's tasks.

Regards.
(0016303)
hgbot (developer)
2009-05-12 17:24

 Repository: erp/devel/pi
Changeset: 1ff0231e17e7922ed8bc58bde4ff11a7d907b7a2
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue May 12 17:24:12 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1ff0231e17e7922ed8bc58bde4ff11a7d907b7a2 [^]

Fixed bug 8008: IBAN code validation

---
M src-db/database/model/triggers/C_BANKACCOUNTIBAN_TRG.xml
M src-db/database/model/triggers/C_BP_BANKACCOUNTIBAN_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0017097)
sureshbabu (reporter)
2009-06-08 15:08

 Tested working fine

- Issue History
Date Modified Username Field Change
2009-03-06 17:42 neil_smith New Issue
2009-03-06 17:42 neil_smith Assigned To => rafaroda
2009-03-06 17:54 rafaroda Assigned To rafaroda => dalsasua
2009-03-16 11:52 rafaroda Note Added: 0014670
2009-03-16 11:52 rafaroda Status new => feedback
2009-03-27 11:09 neil_smith Note Added: 0015034
2009-04-07 14:21 walle Note Added: 0015257
2009-04-22 17:35 psarobe Note Added: 0015570
2009-04-22 17:58 dalsasua Note Added: 0015573
2009-04-23 12:54 rafaroda Relationship added related to 0008737
2009-04-23 13:13 psarobe Priority normal => urgent
2009-04-23 13:13 psarobe Status feedback => scheduled
2009-04-23 16:04 psarobe Tag Attached: 250MP1
2009-05-11 12:56 vmromanos Assigned To dalsasua => vmromanos
2009-05-12 17:24 hgbot Checkin
2009-05-12 17:24 hgbot Note Added: 0016303
2009-05-12 17:24 hgbot Status scheduled => resolved
2009-05-12 17:24 hgbot Resolution open => fixed
2009-05-12 17:24 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1ff0231e17e7922ed8bc58bde4ff11a7d907b7a2 [^]
2009-06-08 15:08 sureshbabu Status resolved => closed
2009-06-08 15:08 sureshbabu Note Added: 0017097
2009-06-08 15:08 sureshbabu Fixed in Version => pi
2009-06-09 00:00 anonymous sf_bug_id 0 => 2803186
2009-09-04 10:03 rafaroda Relationship added related to 0010468

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker