0010161: ma_standard_cost_sequence contains a not existing procedure

Description

ma_standard_cost_sequence fails when it is compiled in Oracle, because m_get_product_price_date is called, but it does not exist.
The real one is get_product_price_date

Steps To Reproduce

Try to compile ma_standard_cost_sequence in Oracle. It fails

Tags

No tags attached.

Attached Files

patch_10089.diff [^] (1,027 bytes) 2009-08-03 13:22 [Show Content] [Hide Content]

diff --git a/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml b/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
--- a/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
+++ b/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
@@ -167,7 +167,7 @@
 
     -- Purchased raw material
     IF (v_No_Cost) THEN
-      SELECT COALESCE(C_CURRENCY_CONVERT(MAX(bl.Price), bl.C_CURRENCY_ID, p_Currency, p_Calcdate, bl.ad_client_id, bl.ad_org_id),M_GET_PRODUCT_PRICE_DATE(MAX(p.AD_CLIENT_ID), MAX(p.M_PRODUCT_ID), p_CalcDate)) INTO v_Cost
+      SELECT COALESCE(C_CURRENCY_CONVERT(MAX(bl.Price), bl.C_CURRENCY_ID, p_Currency, p_Calcdate, bl.ad_client_id, bl.ad_org_id),GET_PRODUCT_PRICE_DATE(MAX(p.AD_CLIENT_ID), MAX(p.M_PRODUCT_ID), p_CalcDate)) INTO v_Cost
       FROM M_Product p LEFT JOIN C_BudgetLine bl ON p.M_Product_ID = bl.M_Product_ID
                                                     AND bl.C_Budget_ID = p_Budget_ID
       WHERE p.M_Product_ID = Cur_UsedProducts.M_Product_ID

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0010089

closed

rafaroda

on 2.40 the pl-function ma_standard_cost_sequence does not compile (call non-existant other pl-function)

Notes
(0018796) rafaroda (viewer) 2009-08-03 13:21	This issue is duplicated of 0010089 Please find its resolution in https://issues.openbravo.com/view.php?id=10089#bugnotes [^] Patch is attached.

Issue History
Date Modified	Username	Field	Change
2009-08-03 13:18	networkb	New Issue
2009-08-03 13:18	networkb	Assigned To	=> rafaroda
2009-08-03 13:18	networkb	OBNetwork customer	=> Yes
2009-08-03 13:21	rafaroda	Relationship added	duplicate of 0010089
2009-08-03 13:21	rafaroda	Status	new => closed
2009-08-03 13:21	rafaroda	Note Added: 0018796
2009-08-03 13:21	rafaroda	Duplicate ID	0 => 10089
2009-08-03 13:21	rafaroda	Resolution	open => duplicate
2009-08-03 13:22	rafaroda	File Added: patch_10089.diff
2009-08-04 00:00	anonymous	sf_bug_id	0 => 2831728