Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002448Openbravo ERPZ. Otherspublic2008-01-02 15:032008-06-12 09:43
Reportergorkaion 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
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
Summary0002448: Problem with default dates format
DescriptionIn several database objects are used different dates as a minimum or maximum dates without any mask. If the NLS_DATE_FORMAT defined in the database is different that the used in the object the application throws a Month not valid exception.

See M_INOUT_CHK_RESTRICTIONS_TRG trigger as an example.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0006037)
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=1862189 [^]
(0002913)
gorkaion   
2008-01-02 18:29   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500690
Originator: YES

Fixed all default dates to include a to_date function with the correspondent mask.

The default limit dates for comparisons have been set to January 1, 1900 and December 31, 9999.
(0002914)
psarobe   
2008-06-04 17:03   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500703
Originator: NO

Tested making a random in some objects (procedures, functions, triggers)