Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0053530 | Openbravo ERP | 09. Financial management | public | 2023-09-22 14:24 | 2023-11-22 06:15 |
Reporter | malsasua | ||||
Assigned To | jonae | ||||
Priority | high | Severity | major | Reproducibility | always |
Status | new | Resolution | open | ||
Platform | OS | 5 | 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 | No | ||||
Summary | 0053530: Bad performance with query executed in "Add Payment" process | ||||
Description | In a customer with a high volume, the query used in Add Payment process, the response time is high | ||||
Steps To Reproduce | . go to Sales Invoice window . click in "Payment In" button the query takes a long time to execute | ||||
Proposed Solution | In aprm_orderinvoice table: HQL Query: select @selectClause@ from FIN_Payment_ScheduleDetail as psd join psd.businessPartner as bp left outer join psd.orderPaymentSchedule as ops left outer join ops.order as ord @joinClauseOrder@ left outer join ops.fINPaymentPriority as opriority left outer join ops.finPaymentmethod opsfp left outer join psd.invoicePaymentSchedule as ips left outer join ips.invoice as inv @joinClauseInvoice@ left outer join ips.fINPaymentPriority as ipriority left outer join ips.finPaymentmethod as ipsfp left outer join psd.organization as org left outer join org.organizationInformationList as oinfo left outer join psd.paymentDetails as pd left outer join pd.finPayment as fp @joinClause@ where @additional_filters@ and @whereClause@ group by @groupByClause@ @havingClause@ is executed | ||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | ![]() https://issues.openbravo.com/file_download.php?file_id=19017&type=bug | ||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2023-09-22 14:24 | malsasua | New Issue | |||
2023-09-22 14:24 | malsasua | Assigned To | => Triage Omni OMS | ||
2023-09-22 14:24 | malsasua | Modules | => Core | ||
2023-09-22 14:24 | malsasua | Triggers an Emergency Pack | => No | ||
2023-10-04 10:38 | aferraz | Assigned To | Triage Omni OMS => jonae | ||
2023-10-05 09:35 | malsasua | File Added: sql_query.txt | |||
2023-11-22 06:15 | jonae | Note Added: 0157439 | |||
2023-11-22 06:15 | jonae | Type | defect => design defect |
Notes | |||||
|
|||||
|
|