0015446: DataGrid.getColumnTotals fails in Financial Account->Reconciliation tab

Description

Hovering with mouse over a numeric column in this tab fails on oracle giving sql-exception:

Example:

204913 [http-8080-5] ERROR org.openbravo.erpCommon.utility.ExecuteQuery - SQL error in query: SELECT SUM(APRM_Reconciliation_v.Payment_No) AS TOTAL
FROM APRM_Reconciliation_v
left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID

WHERE (APRM_Reconciliation_v.Aprm_Reconciliation_V_ID, APRM_Reconciliation_v.FIN_Reconciliation_ID) IN (SELECT Aprm_Reconciliation_V_ID, FIN_Reconciliation_ID
FROM APRM_Reconciliation_v
left join (SELECT FIN_Reconciliation_ID, DocumentNo, Statementdate FROM FIN_Reconciliation) td0 on APRM_Reconciliation_v.FIN_Reconciliation_ID = td0.FIN_Reconciliation_ID

WHERE APRM_Reconciliation_v.AD_Client_ID IN ('0','1000000')
AND APRM_Reconciliation_v.AD_Org_ID IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000008','1000009','1000007')
AND APRM_Reconciliation_v.FIN_Financial_Account_ID = ?
AND APRM_Reconciliation_v.Aprm_Reconciliation_V_ID IN ('FF8081812CEAF7A5012CEAFA3B330053')
)
Exception:java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

javax.servlet.ServletException: @CODE=918@ORA-00918: column ambiguously defined

    at org.openbravo.erpCommon.utility.ExecuteQuery.select(ExecuteQuery.java:314)
    at org.openbravo.erpCommon.utility.DataGrid.getColumnTotals(DataGrid.java:471)
    at org.openbravo.erpCommon.utility.DataGrid.doPost(DataGrid.java:99)

Steps To Reproduce

Go to: Financial Account
Tab: Reconciliation
Go to grid view
Move over a numeric column like: REconciled Items

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0015217

3.0RC4

closed

alostale

Moving forward / back arrows not working in Reconciliation tab

Notes
(0042272) dmitry_mezentsev (viewer) 2011-10-28 17:27	What I can see is that at the moment it is not failing in the Reconciliations tab in OB3. It is true that this Tab was redesigned. So for the user issue does not exist but maybe still there is sth to do in the Platfrom. Then please report another issue. Thanks.

Issue History
Date Modified	Username	Field	Change
2010-12-15 18:08	shuehner	New Issue
2010-12-15 18:08	shuehner	Assigned To	=> alostale
2010-12-15 18:08	shuehner	Modules	=> Core
2010-12-15 18:08	shuehner	OBNetwork customer	=> No
2010-12-15 18:12	shuehner	Relationship added	related to 0015217
2010-12-20 08:46	alostale	Status	new => scheduled
2011-10-28 17:27	dmitry_mezentsev	Note Added: 0042272
2011-10-28 17:27	dmitry_mezentsev	Status	scheduled => closed
2011-10-28 17:27	dmitry_mezentsev	Resolution	open => out of date
2011-10-28 17:27	dmitry_mezentsev	Fixed in Version	=> pi