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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015446

Openbravo ERP

A. Platform

public

2010-12-15 18:08

2011-10-28 17:27

Reporter

shuehner

Assigned To

alostale

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

out of date

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Proposed Solution

Additional Information