0014699: Import budget process fails

Description

Process ImportBudget fails with claim from Postgres... incompatible arguments for COALESCE....

Steps To Reproduce

Export buget in Excel, edit it, save to CSV, import file in "Master Data Management || Import Data || Import File Loader || Import File Loader", then open any line in "Master Data Management || Import Data || Import Budget || Import Budget" and click "Import Budget"

Proposed Solution

apply patch to ImportBudget_data.xsql:

571,582c571,582
< WHERE COALESCE(I_BudgetLine.C_ELEMENTVALUE_ID,'1') = COALESCE(bl.C_ELEMENTVALUE_ID,'1')
< AND COALESCE(I_BudgetLine.C_Period_ID,'1') = COALESCE(bl.C_Period_ID,'1')
< AND COALESCE(I_BudgetLine.C_Bpartner_ID,'1') = COALESCE(bl.C_Bpartner_ID,'1')
< AND COALESCE(I_BudgetLine.AD_OrgTrx_ID,'1') = COALESCE(bl.AD_OrgTrx_ID,'1')
< AND COALESCE(I_BudgetLine.C_SalesRegion_ID,'1') = COALESCE(bl.C_SalesRegion_ID,'1')
< AND COALESCE(I_BudgetLine.C_Project_ID,'1') = COALESCE(bl.C_Project_ID,'1')
< AND COALESCE(I_BudgetLine.C_Campaign_ID,'1') = COALESCE(bl.C_Campaign_ID,'1')
< AND COALESCE(I_BudgetLine.C_Activity_ID,'1') = COALESCE(bl.C_Activity_ID,'1')
< AND COALESCE(I_BudgetLine.C_BP_Group_ID,'1') = COALESCE(bl.C_BP_Group_ID,'1')
< AND COALESCE(I_BudgetLine.M_Product_ID,'1') = COALESCE(bl.M_Product_ID,'1')
< AND COALESCE(I_BudgetLine.M_Product_Category_ID,'1') = COALESCE(bl.M_Product_Category_ID,'1')
< AND COALESCE(I_BudgetLine.C_Currency_ID,'1') = COALESCE(bl.C_Currency_ID,'1')
---
> WHERE COALESCE(I_BudgetLine.C_ELEMENTVALUE_ID,-1) = COALESCE(bl.C_ELEMENTVALUE_ID,-1)
> AND COALESCE(I_BudgetLine.C_Period_ID,-1) = COALESCE(bl.C_Period_ID,-1)
> AND COALESCE(I_BudgetLine.C_Bpartner_ID,-1) = COALESCE(bl.C_Bpartner_ID,-1)
> AND COALESCE(I_BudgetLine.AD_OrgTrx_ID,-1) = COALESCE(bl.AD_OrgTrx_ID,-1)
> AND COALESCE(I_BudgetLine.C_SalesRegion_ID,-1) = COALESCE(bl.C_SalesRegion_ID,-1)
> AND COALESCE(I_BudgetLine.C_Project_ID,-1) = COALESCE(bl.C_Project_ID,-1)
> AND COALESCE(I_BudgetLine.C_Campaign_ID,-1) = COALESCE(bl.C_Campaign_ID,-1)
> AND COALESCE(I_BudgetLine.C_Activity_ID,-1) = COALESCE(bl.C_Activity_ID,-1)
> AND COALESCE(I_BudgetLine.C_BP_Group_ID,-1) = COALESCE(bl.C_BP_Group_ID,-1)
> AND COALESCE(I_BudgetLine.M_Product_ID,-1) = COALESCE(bl.M_Product_ID,-1)
> AND COALESCE(I_BudgetLine.M_Product_Category_ID,-1) = COALESCE(bl.M_Product_Category_ID,-1)
> AND COALESCE(I_BudgetLine.C_Currency_ID,-1) = COALESCE(bl.C_Currency_ID,-1)

Tags

No tags attached.

Attached Files

ReportBudgetGenerateExcelXLS.ods [^] (15,669 bytes) 2010-09-24 18:34

ReportBudgetGenerateExcelXLS.csv [^] (2,021 bytes) 2010-09-24 18:35

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0015202

2.50MP25

closed

adrianromero

Import Budget failure

Notes
(0031355) stalker (reporter) 2010-09-24 18:30 edited on: 2010-09-24 18:41	I'm not sure about the value, which I used for replacement ... -1 -> '1' Anyway, import works fine now. PS. Strange thing... It looks like nobody has used "import budget" feature since OB migrated from OIDS to UUIDS.... WOW! :)

Issue History
Date Modified	Username	Field	Change
2010-09-24 18:27	stalker	New Issue
2010-09-24 18:27	stalker	Assigned To	=> dalsasua
2010-09-24 18:30	stalker	Note Added: 0031355
2010-09-24 18:32	stalker	Note Edited: 0031355	View Revisions
2010-09-24 18:34	stalker	File Added: ReportBudgetGenerateExcelXLS.ods
2010-09-24 18:35	stalker	File Added: ReportBudgetGenerateExcelXLS.csv
2010-09-24 18:41	stalker	Note Edited: 0031355	View Revisions
2010-09-27 12:15	Xpand-IT	Issue Monitored: Xpand-IT
2010-11-16 14:24	networkb	Relationship added	related to 0015202
2010-12-21 13:49	adrianromero	Relationship replaced	duplicate of 0015202
2010-12-21 13:49	adrianromero	Status	new => closed
2010-12-21 13:49	adrianromero	Resolution	open => duplicate
2010-12-22 00:00	anonymous	sf_bug_id	0 => 3141452