ERROR: column reference "m_warehouse_id" is ambiguous

[johnbendi]

I get the following warning and severe messages when running libero manufacturing:

Oct 22, 2016 5:33:08 PM org.adempiere.webui.info.InfoWindow prepareTable
SEVERE: Failed to parsed sql. sql=SELECT mrp.PP_MRP_ID, mrp.M_Product_ID AS M_Product_ID, mrp.S_Resource_ID AS S_Resource_ID, pp.M_Warehouse_ID AS M_Warehouse_ID, mrp.DatePromised AS DatePromised, mrp.Qty AS Qty, pp.SafetyStock AS SafetyStock, bomQtyOnHand(p.M_Product_ID,@1113|M_Warehouse_ID@,0) AS QtyOnHand, mrp.typemrp AS TypeMRP, mrp.OrderType AS OrderType, mrp.DocStatus AS DocStatus, mrp.DateStartSchedule AS DateStartSchedule, documentno(mrp.PP_MRP_ID) AS DOCUMENTNO, mrp.DateFinishSchedule AS DateFinishSchedule, mrp.Planner_ID AS Planner_ID, mrp.Priority AS PlannedQty FROM PP_MRP mrp  JOIN M_Product p ON (mrp.M_Product_ID=p.M_Product_ID)   JOIN pp_product_planning pp
ON (pp.m_product_id = mrp.m_product_id  AND mrp.m_warehouse_id = pp.m_warehouse_id) WHERE

Oct 22, 2016 5:33:09 PM org.compiere.util.Msg translate
WARNING: NOT found: 1113|M_Warehouse_ID

Oct 22, 2016 5:33:10 PM org.adempiere.webui.info.InfoWindow testCount
SEVERE: SELECT COUNT(*) FROM ( SELECT mrp.PP_MRP_ID, mrp.M_Product_ID AS M_Product_ID, mrp.S_Resource_ID AS S_Resource_ID, pp.M_Warehouse_ID AS M_Warehouse_ID, mrp.DatePromised AS DatePromised, mrp.Qty AS Qty, pp.SafetyStock AS SafetyStock, bomQtyOnHand(p.M_Product_ID,1113|M_Warehouse_ID,0) AS QtyOnHand, mrp.typemrp AS TypeMRP, mrp.OrderType AS OrderType, mrp.DocStatus AS DocStatus, mrp.DateStartSchedule AS DateStartSchedule, documentno(mrp.PP_MRP_ID) AS DOCUMENTNO, mrp.DateFinishSchedule AS DateFinishSchedule, mrp.Planner_ID AS Planner_ID, mrp.Priority AS PlannedQty FROM PP_MRP mrp  JOIN M_Product p ON (mrp.M_Product_ID=p.M_Product_ID)   JOIN pp_product_planning pp
ON (pp.m_product_id = mrp.m_product_id  AND mrp.m_warehouse_id = pp.m_warehouse_id) WHERE mrp.IsActive='Y' AND mrp.S_Resource_ID = ? AND pp.M_Warehouse_ID = ? AND mrp.AD_Client_ID IN(0,11) AND mrp.AD_Org_ID IN(0,11,12,50000,50002,50001,50004,50006,50005,50007) AND  (mrp.PP_MRP_ID IS NULL OR mrp.PP_MRP_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 53043 AND AD_User_ID <> 101 AND IsActive = 'Y' ))  AND  (p.M_Product_ID IS NULL OR p.M_Product_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 208 AND AD_User_ID <> 101 AND IsActive = 'Y' ))  AND  (pp.PP_Product_Planning_ID IS NULL OR pp.PP_Product_Planning_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 0 AND AD_User_ID <> 101 AND IsActive = 'Y' ))  ) a

org.postgresql.util.PSQLException: ERROR: column reference "m_warehouse_id" is ambiguous
  Position: 268
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:495)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:380)
   at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
   at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128)
   at com.sun.proxy.$Proxy4.executeQuery(Unknown Source)
   at org.adempiere.webui.info.InfoWindow.testCount(InfoWindow.java:1718)
   at org.adempiere.webui.info.InfoWindow.testCount(InfoWindow.java:1682)
   at org.adempiere.webui.panel.InfoPanel.executeQuery(InfoPanel.java:539)
   at org.adempiere.webui.info.InfoWindow.executeQuery(InfoWindow.java:1502)
   at org.adempiere.webui.panel.InfoPanel.onQueryCallback(InfoPanel.java:1999)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2757)
   at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2685)
   at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
   at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1765)
   at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1550)
   at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1260)
   at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:611)
   at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:485)
   at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:494)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
   at org.eclipse.jetty.server.Server.handle(Server.java:499)
   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
   at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
   at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
   at java.lang.Thread.run(Thread.java:745)

And this happens when I click on the requery button within the MRP Info Window:

The value I suspect causing the problem is defined here:

As you can see, there is first of all a failure to parse the SQL then followed by the error from the database about the ambiguous value. 

[Joseph]

YES，I found this column must Mandatory and modify this to RED.