Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001112Openbravo ERPZ. Otherspublic2007-04-09 18:492008-07-04 15:38
Reporterroklenardic 
Assigned Todalsasua 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
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
Summary0001112: A_ASSET_POST PL has spanish months
DescriptionIf you look at the code of A_ASSET_POST PL, you can see that it has spanish months hardcoded inside.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003536 closed dalsasua A_ASSET_POST PL has spanish months. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-04 15:38plujanStatusresolved => closed
2008-07-04 15:38plujanFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0004701)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1697043 [^]
(0000959)
iciordia   
2007-10-04 13:33   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1455356
Originator: NO

This bug has been tested and we couldn't reproduce it.

Note that the only supported version of the application is the one in subversion. So it is possible that this was a bug in a previous version that is already fixed.
(0000960)
roklenardic   
2007-12-03 06:24   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1626799
Originator: YES

I have checked the latest subversion OB and the stored procedure A_ASSET_POST still has spanish months hardcoded inside (see line 178:
            v_FIRST_DAY_DATE:=TO_DATE('01-ENE-' || TO_CHAR(v_AMORTIZATIONSTARTDATE, 'YYYY')) ;

That being said, this only works when the database language is set to SPANISH in XmlPool.xml or Openbravo.properties in the new version

<dbSessionConfig>ALTER SESSION SET NLS_LANGUAGE='SPANISH' NLS_DATE_FORMAT='DD-MM-YYYY' NLS_NUMERIC_CHARACTERS='.,'</dbSessionConfig>
(0000961)
iciordia   
2007-12-04 10:56   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1455356
Originator: NO

You are right. The bug has been reopened. Thanks!
(0000962)
dalsasua   
2007-12-04 16:51   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1924288
Originator: NO

Changed spanish strings (ENE & DIC) to numeric values (01 & 12).

File modified: database/model/functions/a_asset_post.xml