Openbravo Issue Tracking System - Openbravo ERP
a3196480 813916 [TP-Processor6] INFO org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=join_0,role=null,tableName=M_Product,tableAlias=product1_,origin=M_ProductionPlan materialmg0_,columns={materialmg0_.M_Product_ID ,className=Product}}] [select e.id from MaterialMgmtProductionPlan as e left join fetch e.product as join_0 where ( ( e.production.id = :alias_0 ) ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '856478800DB049E98ED9FE51693D5B7F', '38C91465BE5A449EBBCCC5DCF33B165F', 'DC206C91AA6A4897B44DA897936E0EC3', '9B0149B3D28549C0B5F91D339E8AE730', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43', '0', '12CA582AB0D1455D9D323481E25C795A', '7BABA5FF80494CAFA54DEBD22EC46F01', 'A217575E2A9E4631A413D48109163D93', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')order by join_0.name,e.id]
Go to product and create:
Product p11
-Organization: F&B US, Inc.
-Name:p11
-stocked=Y
-bill of materials:N
-tab price: price list: general sales, net unit price=5, net list price=5
Product p12
-Organization: F&B US, Inc.
-Name:p12
-stocked=Y
-bill of materials:N
-tab price: price list: general sales, net unit price=6, net list price=6
Product p1
-Organization: F&B US, Inc.
-Name:p1
-stocked=N
-bill of materials:y
-tab price: price list: general sales, net unit price=0, net list price=0
-tab Bill of matenials
-bom product:p11, active:yes
-bom product:p12, active:no
-Click Verify BOM
Product p2
-Organization: F&B US, Inc.
-Name:p2
-stocked=Y
-bill of materials:N
-tab price: price list: general sales, net unit price=1.5, net list price=1.5
Product p
-Organization: F&B US, Inc.
-Name:p
-stocked=Y
-bill of materials:y
-tab price: price list: general sales, net unit price=0, net list price=0
-tab Bill of matenials
-bom product:p1, active: yes
-bom product:p2, active: yes
-Click Verify BOM
Go to Bill of Materials Production.
Create a new record:
"Organization": F&B US
"Name": BoMPT
Move to Production Plan tab and create a new record:
"Product": p
"Production Quantity": 10
"Storage Bin": WC-1-0-0
Click on "Create/Process Production" and OK
Error.png (84,560) 2012-06-21 17:33https://issues.openbravo.com/file_download.php?file_id=5320&type=bug