Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002170Openbravo ERP05. Production managementpublic2007-10-26 15:192008-06-12 09:43
ReporterDowid 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.35 
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
Summary0002170: AT235: The Calculate Standard Costs doesn't work in Postgre
DescriptionEnviroment:
OS: Windows XP SP2
DB: Postgre SQL 8.2
Browser: FF2
Openbravo: 2.35
Language: English

Steps:
Go to Production Management -> Transactions -> Calculate Standard Costs
and click on button "Ok"

Error:
function ma_standard_cost_sequence(numeric, numeric, timestamp without time zone, numeric, character varying) does not exist

In the Oracle installations this works ok
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0005759)
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=1820662 [^]
(0002501)
cromero   
2007-10-30 12:49   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1500614
Originator: NO

Fixed.

Postgre translator has been modified in order to make the correct translation for the procedure MA_STANDARD_COST_SEQUENCE.
Firstly, MA_STANDARD_COST_SEQUENCE. doesn't return any message, (that's why it was invoked with PERFORM). But at this moment that it's returning a message, procedure must be invoked in Postgre with a SELECT INTO clause.

Carlos Romero
Openbravo Team
(0002502)
rafaroda   
2007-10-31 11:56   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1892190
Originator: NO

Verification assigned to rafaroda.