Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo Localizations] Localization Francemajoralways2018-06-04 10:382018-06-07 16:22
Reporterjoniturralde93View Statuspublic 
Assigned To 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Regression introduced in release

0038691: France Professional Localization Pack incompatible with Oracle

DescriptionInstalled module in an Oracle environment and, when rebuilding the system or updating the database, an error is thrown.

Steps To Reproduce- Install France Professional Localization Pack
- Rebuild the system/update database
- Error is thrown
TagsNo tags attached.
Attached Filestxt file icon errorLogFranceLocalization.txt [^] (606,207 bytes) 2018-06-04 12:41

- Relationships Relation Graph ] Dependency Graph ]
caused by feature request 0038705 acknowledgedplatform Openbravo ERP DB Functions returning CLOB type are not supported in Oracle 

-  Notes
psanjuan (manager)
2018-06-06 09:59

Hi Daniel,

As it seems there is an error in Openbavo you can see below in [1]. We do not support functions that retrieve a concrete type (TEXT) in Oracle.

We have found such fucntion in one of your modules: modules/fr.phidias.localization.france.referencedata.masterdata/src-db/database/model/functions/PHMDF_SPELLNUMERICVALUE.xml

Therefore, is there any option to change/modify that function in your code so it can compile in Oracle?

Thanks and regards,


[1] [^]
psanjuan (manager)
2018-06-07 16:22

Sorry Daniel,

let me clarify a bit. Would you please adjust that function so it is possible to compile and make it work?

That will give us the right basis to design the changes we would need to do to fix the issue 38705.

Thanks and regards,

psanjuan (manager)
2018-06-07 16:22

Hi Daniel,

Do you have any news on this?

While researching we have found another issue caused by a component that tries to execute below select: select * from phmdf_recalculate_bank_accno('0')
As far as we know above is select can not be executed that way in Oracle.

Please let me know if the Professional Pack is designed to work on Oracle installations. Can you fix these issues that are related to Oracle?

Let me know if we can support you on this somehow.

- Issue History
Date Modified Username Field Change
2018-06-04 10:38 joniturralde93 New Issue
2018-06-04 11:25 joniturralde93 Description Updated View Revisions
2018-06-04 12:41 joniturralde93 File Added: errorLogFranceLocalization.txt
2018-06-05 17:42 joniturralde93 Description Updated View Revisions
2018-06-06 09:59 psanjuan Note Added: 0104968
2018-06-06 09:59 psanjuan Relationship added caused by 0038705
2018-06-07 16:22 psanjuan Note Added: 0105006
2018-06-07 16:22 psanjuan Note Added: 0105007

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker