Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037467Openbravo ERP00. Application dictionarypublic2017-12-13 01:462022-02-01 08:05
Reporterrbianchini 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037467: subtab in "Purchasing Plan" with a tableDir FK to header fails
DescriptionWhen adding a child tab in "Purchasing Plan", with a FK to MRP_Run_Purchase set as "link to parent column" with TableDir reference. It is not possible to add/edit records in that new tab.
Steps To Reproduce1. Install attached module which:
  - Adds a new table with a MRP_Run_Purchase_ID column being a FK to MRP_Run_Purchase with TableDir referece
  - Adds a new "Test" tab to "Purchasing Plan" window with that table
2. Open "Purchasing Plan" window
3. Create a record
4. Click on new in Test tab
  -> ERRORS:
     * Parent record is not selected in child one
     * An error can be see in logs:

595dbc4c 330110 [http-bio-8080-exec-1] ERROR org.openbravo.erpCommon.utility.ComboTableData - Error in query SELECT td0.MRP_Run_Purchase_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),'')),'') || ' - ' || COALESCE(TO_CHAR(COALESCE(TO_CHAR(td1.Name),'')),'') || ' - ' || COALESCE(TO_CHAR(COALESCE(TO_CHAR(td2.Name),'')),'') || ' - ' || COALESCE(TO_CHAR((CASE WHEN td_trl4.Name IS NULL THEN COALESCE(TO_CHAR(td3.Name),'') ELSE COALESCE(TO_CHAR(td_trl4.Name),'') END)),'') || ' - ' || COALESCE(TO_CHAR((CASE WHEN td_trl6.Name IS NULL THEN COALESCE(TO_CHAR(td5.Name),'') ELSE COALESCE(TO_CHAR(td_trl6.Name),'') END)),'') || ' - ' || COALESCE(TO_CHAR(COALESCE(TO_CHAR(td7.Name),'')),'')) AS NAME, '' AS DESCRIPTION
FROM MRP_Run_Purchase td0
left join MRP_Planner td1 on td0.MRP_Planner_ID = td1.MRP_Planner_ID
AND td1.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389')
AND td1.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0')
left join C_BPartner td2 on td0.Vendor_ID = td2.Vendor_ID
AND td2.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389')
AND td2.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0')
left join M_Product_Category td3 on td0.M_Product_Category_ID = td3.M_Product_Category_ID
AND td3.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389')
AND td3.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0')
left join M_Product_Category_Trl td_trl4 on td3.M_Product_Category_ID = td_trl4.M_Product_Category_ID AND td_trl4.AD_Language = ?
left join M_Product td5 on td0.M_Product_ID = td5.M_Product_ID
AND td5.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389')
AND td5.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0')
left join M_Product_Trl td_trl6 on td5.M_Product_ID = td_trl6.M_Product_ID AND td_trl6.AD_Language = ?
left join C_BPartner td7 on td0.C_BPartner_ID = td7.C_BPartner_ID
AND td7.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389')
AND td7.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0')
WHERE td0.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389')
AND td0.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0')
AND (td0.isActive = 'Y' OR td0.MRP_Run_Purchase_ID = (?) )
 AND td0.MRP_Run_Purchase_ID=(?) ORDER BY 2, 2, 2, 2, 2, 2
org.postgresql.util.PSQLException: ERROR: column td2.vendor_id does not exist
  Position: 950
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? org.openbravo.plaform.issue37467-0.0.0.obx (9,678) 2017-12-14 10:26
https://issues.openbravo.com/file_download.php?file_id=11365&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-12-13 01:46rbianchiniNew Issue
2017-12-13 01:46rbianchiniAssigned To => platform
2017-12-13 01:46rbianchiniModules => Core
2017-12-13 01:46rbianchiniTriggers an Emergency Pack => No
2017-12-13 09:03PracticsIssue Monitored: Practics
2017-12-14 10:26alostaleFile Added: org.openbravo.plaform.issue37467-0.0.0.obx
2017-12-14 10:30alostaleDescription Updatedbug_revision_view_page.php?rev_id=16443#r16443
2017-12-14 10:30alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16445#r16445
2017-12-14 10:31alostaleStatusnew => acknowledged
2017-12-14 12:19alostaleSummaryAdding adding child tab in "Purchasing Plan" => subtab in "Purchasing Plan" with a tableDir FK to header fails
2022-02-01 08:05alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.