|
|
楼主 |
发表于 2009/10/3 17:27:20
|
显示全部楼层
看了一个前辈的贴子原来我的问题也在这里
将原来的ORACLE10G 改成了OracleXEUniv.exe 后可以了
但是在安装过程中有以下日志 不知道是否正常
是怎么回事 那为大侠能帮忙看下 谢谢了
17:20:55.093 ProgressPanel.publish: Creating views ... [18]
17:20:55.125 ViewCreate.doIt: Creating views for EntityType=D [18]
17:20:55.328 ViewCreate.doIt: Created view RV_C_Invoice [18]
17:20:55.421 ViewCreate.doIt: Created view C_Invoice_v [18]
17:20:55.468 ViewCreate.doIt: Created view RV_OrderMonitorInner [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_InvoiceLine(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, C_Order_ID, SalesRep_ID, C_BPartner_ID, C_BP_Group_ID, DocumentNo, DateInvoiced, DateAcct, IsSOTrx, C_DocType_ID, DocStatus, IsPaid, C_Currency_ID, C_BPartner_Location_ID, AD_User_ID, GrandTotal, TotalLines, EMail, Title, Phone, Fax, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, M_Product_ID, M_Product_Category_ID, C_InvoiceLine_ID, C_OrderLine_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_Tax_ID, C_UOM_ID, QtyInvoiced, QtyEntered, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, PriceList, PriceActual, PriceLimit, PriceEntered, Discount, Margin, MarginAmt, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineOverLimitAmt) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, i.C_Invoice_ID AS C_Invoice_ID, i.C_Order_ID AS C_Order_ID, i.SalesRep_ID AS SalesRep_ID, i.C_BPartner_ID AS C_BPartner_ID, i.C_BP_Group_ID AS C_BP_Group_ID, i.DocumentNo AS DocumentNo, i.DateInvoiced AS DateInvoiced, i.DateAcct AS DateAcct, i.IsSOTrx AS IsSOTrx, i.C_DocType_ID AS C_DocType_ID, i.DocStatus AS DocStatus, i.IsPaid AS IsPaid, i.C_Currency_ID AS C_Currency_ID, i.C_BPartner_Location_ID AS C_BPartner_Location_ID, i.AD_User_ID AS AD_User_ID, ROUND(i.Multiplier*i.GrandTotal,2) AS GrandTotal, ROUND(i.Multiplier*TotalLines,2) AS TotalLines, u.EMail AS EMail, u.Title AS Title, u.Phone AS Phone, u.Fax AS Fax, l.Address1 AS Address1, l.Address2 AS Address2, l.City AS City, l.Postal AS Postal, l.C_Region_ID AS C_Region_ID, l.C_Country_ID AS C_Country_ID, il.M_Product_ID AS M_Product_ID, p.M_Product_Category_ID AS M_Product_Category_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_OrderLine_ID AS C_OrderLine_ID, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID, il.C_Tax_ID AS C_Tax_ID, il.C_UOM_ID AS C_UOM_ID, il.QtyInvoiced*i.Multiplier AS QtyInvoiced, il.QtyEntered*i.Multiplier AS QtyEntered, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(il.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, il.PriceList AS PriceList, il.PriceActual AS PriceActual, il.PriceLimit AS PriceLimit, il.PriceEntered AS PriceEntered, CASE WHEN PriceList=0 THEN 0 ELSE ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE (PriceActual-PriceLimit)*QtyInvoiced END AS MarginAmt, ROUND(i.Multiplier*LineNetAmt,2) AS LineNetAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced,2) AS LineListAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN ROUND(i.Multiplier*LineNetAmt,2) ELSE ROUND(i.Multiplier*PriceLimit*QtyInvoiced,2) END AS LineLimitAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced-LineNetAmt,2) AS LineDiscountAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN 0 ELSE ROUND(i.Multiplier*LineNetAmt-PriceLimit*QtyInvoiced,2) END AS LineOverLimitAmt FROM RV_C_Invoice i INNER JOIN C_InvoiceLine il ON (i.C_Invoice_ID=il.C_Invoice_ID) LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (il.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner_Location bpl ON (i.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN C_Location l ON (l.C_Location_ID = bpl.C_Location_ID) LEFT OUTER JOIN AD_User u ON (i.AD_User_ID = u.AD_User_ID) [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_InvoiceLine(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, C_Order_ID, SalesRep_ID, C_BPartner_ID, C_BP_Group_ID, DocumentNo, DateInvoiced, DateAcct, IsSOTrx, C_DocType_ID, DocStatus, IsPaid, C_Currency_ID, C_BPartner_Location_ID, AD_User_ID, GrandTotal, TotalLines, EMail, Title, Phone, Fax, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, M_Product_ID, M_Product_Category_ID, C_InvoiceLine_ID, C_OrderLine_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_Tax_ID, C_UOM_ID, QtyInvoiced, QtyEntered, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, PriceList, PriceActual, PriceLimit, PriceEntered, Discount, Margin, MarginAmt, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineOverLimitAmt) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, i.C_Invoice_ID AS C_Invoice_ID, i.C_Order_ID AS C_Order_ID, i.SalesRep_ID AS SalesRep_ID, i.C_BPartner_ID AS C_BPartner_ID, i.C_BP_Group_ID AS C_BP_Group_ID, i.DocumentNo AS DocumentNo, i.DateInvoiced AS DateInvoiced, i.DateAcct AS DateAcct, i.IsSOTrx AS IsSOTrx, i.C_DocType_ID AS C_DocType_ID, i.DocStatus AS DocStatus, i.IsPaid AS IsPaid, i.C_Currency_ID AS C_Currency_ID, i.C_BPartner_Location_ID AS C_BPartner_Location_ID, i.AD_User_ID AS AD_User_ID, ROUND(i.Multiplier*i.GrandTotal,2) AS GrandTotal, ROUND(i.Multiplier*TotalLines,2) AS TotalLines, u.EMail AS EMail, u.Title AS Title, u.Phone AS Phone, u.Fax AS Fax, l.Address1 AS Address1, l.Address2 AS Address2, l.City AS City, l.Postal AS Postal, l.C_Region_ID AS C_Region_ID, l.C_Country_ID AS C_Country_ID, il.M_Product_ID AS M_Product_ID, p.M_Product_Category_ID AS M_Product_Category_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_OrderLine_ID AS C_OrderLine_ID, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID, il.C_Tax_ID AS C_Tax_ID, il.C_UOM_ID AS C_UOM_ID, il.QtyInvoiced*i.Multiplier AS QtyInvoiced, il.QtyEntered*i.Multiplier AS QtyEntered, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(il.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, il.PriceList AS PriceList, il.PriceActual AS PriceActual, il.PriceLimit AS PriceLimit, il.PriceEntered AS PriceEntered, CASE WHEN PriceList=0 THEN 0 ELSE ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE (PriceActual-PriceLimit)*QtyInvoiced END AS MarginAmt, ROUND(i.Multiplier*LineNetAmt,2) AS LineNetAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced,2) AS LineListAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN ROUND(i.Multiplier*LineNetAmt,2) ELSE ROUND(i.Multiplier*PriceLimit*QtyInvoiced,2) END AS LineLimitAmt, ROUND(i.Multiplier*PriceList*QtyInvoiced-LineNetAmt,2) AS LineDiscountAmt, CASE WHEN COALESCE(il.PriceLimit,0)=0 THEN 0 ELSE ROUND(i.Multiplier*LineNetAmt-PriceLimit*QtyInvoiced,2) END AS LineOverLimitAmt FROM RV_C_Invoice i INNER JOIN C_InvoiceLine il ON (i.C_Invoice_ID=il.C_Invoice_ID) LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (il.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner_Location bpl ON (i.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN C_Location l ON (l.C_Location_ID = bpl.C_Location_ID) LEFT OUTER JOIN AD_User u ON (i.AD_User_ID = u.AD_User_ID) [18]
17:20:59.000 ViewCreate.doIt: Created view C_Payment_v [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_OrderDetail(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Order_ID, DocStatus, DocAction, C_DocType_ID, IsApproved, IsCreditApproved, SalesRep_ID, Bill_BPartner_ID, Bill_Location_ID, Bill_User_ID, IsDropShip, POReference, C_Currency_ID, IsSOTrx, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID, C_BP_Group_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_OrderLine_ID, DateOrdered, DatePromised, M_Product_ID, M_Warehouse_ID, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, M_Product_Category_ID, C_UOM_ID, QtyEntered, QtyOrdered, QtyReserved, QtyDelivered, QtyInvoiced, PriceActual, PriceEntered, QtyToDeliver, QtyToInvoice, NetAmtToInvoice, QtyLostSales, AmtLostSales, Discount, Margin, MarginAmt, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, IsReturnTrx) AS SELECT l.AD_Client_ID AS AD_Client_ID, l.AD_Org_ID AS AD_Org_ID, l.IsActive AS IsActive, l.Created AS Created, l.CreatedBy AS CreatedBy, l.Updated AS Updated, l.UpdatedBy AS UpdatedBy, o.C_Order_ID AS C_Order_ID, o.DocStatus AS DocStatus, o.DocAction AS DocAction, o.C_DocType_ID AS C_DocType_ID, o.IsApproved AS IsApproved, o.IsCreditApproved AS IsCreditApproved, o.SalesRep_ID AS SalesRep_ID, o.Bill_BPartner_ID AS Bill_BPartner_ID, o.Bill_Location_ID AS Bill_Location_ID, o.Bill_User_ID AS Bill_User_ID, o.IsDropShip AS IsDropShip, o.POReference AS POReference, o.C_Currency_ID AS C_Currency_ID, o.IsSOTrx AS IsSOTrx, l.C_BPartner_ID AS C_BPartner_ID, l.C_BPartner_Location_ID AS C_BPartner_Location_ID, o.AD_User_ID AS AD_User_ID, bp.C_BP_Group_ID AS C_BP_Group_ID, l.C_Campaign_ID AS C_Campaign_ID, l.C_Project_ID AS C_Project_ID, l.C_Activity_ID AS C_Activity_ID, l.C_ProjectPhase_ID AS C_ProjectPhase_ID, l.C_ProjectTask_ID AS C_ProjectTask_ID, l.C_OrderLine_ID AS C_OrderLine_ID, l.DateOrdered AS DateOrdered, l.DatePromised AS DatePromised, l.M_Product_ID AS M_Product_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(l.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, p.M_Product_Category_ID AS M_Product_Category_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QtyEntered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QtyOrdered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QtyReserved, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QtyDelivered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QtyInvoiced, l.PriceActual AS PriceActual, l.PriceEntered AS PriceEntered, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QtyToDeliver, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QtyToInvoice, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NetAmtToInvoice, l.QtyLostSales AS QtyLostSales, l.QtyLostSales*l.PriceActual AS AmtLostSales, CASE WHEN PriceList=0 THEN 0 ELSE ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE (CASE WHEN o.IsReturnTrx='Y' THEN (PriceActual-PriceLimit)*QtyDelivered*-1 ELSE (PriceActual-PriceLimit)*QtyDelivered END) END AS MarginAmt, loc.Address1 AS Address1, loc.Address2 AS Address2, loc.City AS City, loc.Postal AS Postal, loc.C_Region_ID AS C_Region_ID, loc.C_Country_ID AS C_Country_ID, o.IsReturnTrx AS IsReturnTrx FROM C_Order o INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN C_Location loc ON (loc.C_Location_ID = bpl.C_Location_ID) INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_OrderDetail(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Order_ID, DocStatus, DocAction, C_DocType_ID, IsApproved, IsCreditApproved, SalesRep_ID, Bill_BPartner_ID, Bill_Location_ID, Bill_User_ID, IsDropShip, POReference, C_Currency_ID, IsSOTrx, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID, C_BP_Group_ID, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID, C_OrderLine_ID, DateOrdered, DatePromised, M_Product_ID, M_Warehouse_ID, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, M_Product_Category_ID, C_UOM_ID, QtyEntered, QtyOrdered, QtyReserved, QtyDelivered, QtyInvoiced, PriceActual, PriceEntered, QtyToDeliver, QtyToInvoice, NetAmtToInvoice, QtyLostSales, AmtLostSales, Discount, Margin, MarginAmt, Address1, Address2, City, Postal, C_Region_ID, C_Country_ID, IsReturnTrx) AS SELECT l.AD_Client_ID AS AD_Client_ID, l.AD_Org_ID AS AD_Org_ID, l.IsActive AS IsActive, l.Created AS Created, l.CreatedBy AS CreatedBy, l.Updated AS Updated, l.UpdatedBy AS UpdatedBy, o.C_Order_ID AS C_Order_ID, o.DocStatus AS DocStatus, o.DocAction AS DocAction, o.C_DocType_ID AS C_DocType_ID, o.IsApproved AS IsApproved, o.IsCreditApproved AS IsCreditApproved, o.SalesRep_ID AS SalesRep_ID, o.Bill_BPartner_ID AS Bill_BPartner_ID, o.Bill_Location_ID AS Bill_Location_ID, o.Bill_User_ID AS Bill_User_ID, o.IsDropShip AS IsDropShip, o.POReference AS POReference, o.C_Currency_ID AS C_Currency_ID, o.IsSOTrx AS IsSOTrx, l.C_BPartner_ID AS C_BPartner_ID, l.C_BPartner_Location_ID AS C_BPartner_Location_ID, o.AD_User_ID AS AD_User_ID, bp.C_BP_Group_ID AS C_BP_Group_ID, l.C_Campaign_ID AS C_Campaign_ID, l.C_Project_ID AS C_Project_ID, l.C_Activity_ID AS C_Activity_ID, l.C_ProjectPhase_ID AS C_ProjectPhase_ID, l.C_ProjectTask_ID AS C_ProjectTask_ID, l.C_OrderLine_ID AS C_OrderLine_ID, l.DateOrdered AS DateOrdered, l.DatePromised AS DatePromised, l.M_Product_ID AS M_Product_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(l.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, p.M_Product_Category_ID AS M_Product_Category_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QtyEntered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QtyOrdered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QtyReserved, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QtyDelivered, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QtyInvoiced, l.PriceActual AS PriceActual, l.PriceEntered AS PriceEntered, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QtyToDeliver, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QtyToInvoice, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NetAmtToInvoice, l.QtyLostSales AS QtyLostSales, l.QtyLostSales*l.PriceActual AS AmtLostSales, CASE WHEN PriceList=0 THEN 0 ELSE ROUND((PriceList-PriceActual)/PriceList*100,2) END AS Discount, CASE WHEN PriceLimit=0 THEN 0 ELSE ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS Margin, CASE WHEN PriceLimit=0 THEN 0 ELSE (CASE WHEN o.IsReturnTrx='Y' THEN (PriceActual-PriceLimit)*QtyDelivered*-1 ELSE (PriceActual-PriceLimit)*QtyDelivered END) END AS MarginAmt, loc.Address1 AS Address1, loc.Address2 AS Address2, loc.City AS City, loc.Postal AS Postal, loc.C_Region_ID AS C_Region_ID, loc.C_Country_ID AS C_Country_ID, o.IsReturnTrx AS IsReturnTrx FROM C_Order o INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN C_Location loc ON (loc.C_Location_ID = bpl.C_Location_ID) INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) [18]
17:21:02.718 ViewCreate.doIt: Created view RV_M_Transaction_Sum [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_Day(AD_Client_ID, AD_Org_ID, SalesRep_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, IsSOTrx) AS SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, SalesRep_ID AS SalesRep_ID, firstOf(DateInvoiced,'DD') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine GROUP BY AD_Client_ID, AD_Org_ID, SalesRep_ID, firstOf(DateInvoiced,'DD'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_Day(AD_Client_ID, AD_Org_ID, SalesRep_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, IsSOTrx) AS SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, SalesRep_ID AS SalesRep_ID, firstOf(DateInvoiced,'DD') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine GROUP BY AD_Client_ID, AD_Org_ID, SalesRep_ID, firstOf(DateInvoiced,'DD'), IsSOTrx [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_Month(AD_Client_ID, AD_Org_ID, SalesRep_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, IsSOTrx) AS SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, SalesRep_ID AS SalesRep_ID, firstOf(DateInvoiced,'MM') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine GROUP BY AD_Client_ID, AD_Org_ID, SalesRep_ID, firstOf(DateInvoiced, 'MM'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_Month(AD_Client_ID, AD_Org_ID, SalesRep_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, IsSOTrx) AS SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, SalesRep_ID AS SalesRep_ID, firstOf(DateInvoiced,'MM') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine GROUP BY AD_Client_ID, AD_Org_ID, SalesRep_ID, firstOf(DateInvoiced, 'MM'), IsSOTrx [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_ProdMonth(AD_Client_ID, AD_Org_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'MM') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced,'MM'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_ProdMonth(AD_Client_ID, AD_Org_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'MM') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced,'MM'), IsSOTrx [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_ProdWeek(AD_Client_ID, AD_Org_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'DY') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced,'DY'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_ProdWeek(AD_Client_ID, AD_Org_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'DY') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced,'DY'), IsSOTrx [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_VendorMonth(AD_Client_ID, AD_Org_ID, C_BPartner_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, po.C_BPartner_ID AS C_BPartner_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'MM') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced FROM RV_C_InvoiceLine il INNER JOIN M_Product_PO po ON (il.M_Product_ID=po.M_Product_ID) WHERE il.IsSOTrx='Y' GROUP BY il.AD_Client_ID, il.AD_Org_ID, po.C_BPartner_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced, 'MM') [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_VendorMonth(AD_Client_ID, AD_Org_ID, C_BPartner_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, po.C_BPartner_ID AS C_BPartner_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'MM') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced FROM RV_C_InvoiceLine il INNER JOIN M_Product_PO po ON (il.M_Product_ID=po.M_Product_ID) WHERE il.IsSOTrx='Y' GROUP BY il.AD_Client_ID, il.AD_Org_ID, po.C_BPartner_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced, 'MM') [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_Week(AD_Client_ID, AD_Org_ID, SalesRep_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, IsSOTrx) AS SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, SalesRep_ID AS SalesRep_ID, firstOf(DateInvoiced,'DY') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine GROUP BY AD_Client_ID, AD_Org_ID, SalesRep_ID, firstOf(DateInvoiced, 'DY'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_Week(AD_Client_ID, AD_Org_ID, SalesRep_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, IsSOTrx) AS SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, SalesRep_ID AS SalesRep_ID, firstOf(DateInvoiced,'DY') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine GROUP BY AD_Client_ID, AD_Org_ID, SalesRep_ID, firstOf(DateInvoiced, 'DY'), IsSOTrx [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_CustomerProdQtr(AD_Client_ID, AD_Org_ID, C_BPartner_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.C_BPartner_ID AS C_BPartner_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'Q') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.C_BPartner_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced, 'Q'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_CustomerProdQtr(AD_Client_ID, AD_Org_ID, C_BPartner_ID, M_Product_Category_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.C_BPartner_ID AS C_BPartner_ID, il.M_Product_Category_ID AS M_Product_Category_ID, firstOf(il.DateInvoiced,'Q') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.C_BPartner_ID, il.M_Product_Category_ID, firstOf(il.DateInvoiced, 'Q'), IsSOTrx [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_CustomerVendQtr(AD_Client_ID, AD_Org_ID, C_BPartner_ID, Vendor_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.C_BPartner_ID AS C_BPartner_ID, po.C_BPartner_ID AS Vendor_ID, firstOf(il.DateInvoiced,'Q') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced FROM RV_C_InvoiceLine il INNER JOIN M_Product_PO po ON (il.M_Product_ID=po.M_Product_ID) WHERE il.IsSOTrx='Y' GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.C_BPartner_ID, po.C_BPartner_ID, firstOf(il.DateInvoiced, 'Q') [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_CustomerVendQtr(AD_Client_ID, AD_Org_ID, C_BPartner_ID, Vendor_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.C_BPartner_ID AS C_BPartner_ID, po.C_BPartner_ID AS Vendor_ID, firstOf(il.DateInvoiced,'Q') AS DateInvoiced, SUM(LineNetAmt) AS LineNetAmt, SUM(LineListAmt) AS LineListAmt, SUM(LineLimitAmt) AS LineLimitAmt, SUM(LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced FROM RV_C_InvoiceLine il INNER JOIN M_Product_PO po ON (il.M_Product_ID=po.M_Product_ID) WHERE il.IsSOTrx='Y' GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.C_BPartner_ID, po.C_BPartner_ID, firstOf(il.DateInvoiced, 'Q') [18]
17:21:15.718 ViewCreate.doIt: Created view RV_OpenItem [18]
17:21:15.765 ViewCreate.doIt: Created view RV_M_Transaction [18]
17:21:15.812 ViewCreate.doIt: Created view RV_C_RfQ_UnAnswered [18]
17:21:15.890 ViewCreate.doIt: Created view RV_C_RfQResponse [18]
17:21:15.953 ViewCreate.doIt: Created view RV_M_Requisition [18]
17:21:16.000 ViewCreate.doIt: Created view RV_Asset_SumMonth [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_RfQResponseLine_v(C_RfQResponse_ID, C_RfQResponseLine_ID, C_RfQLine_ID, C_RfQResponseLineQty_ID, C_RfQLineQty_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, Line, M_Product_ID, M_AttributeSetInstance_ID, Name, Description, DocumentNote, UPC, SKU, ProductValue, Help, DateWorkStart, DeliveryDays, C_UOM_ID, UOMSymbol, BenchmarkPrice, Qty, Price, Discount) AS SELECT rrl.C_RfQResponse_ID AS C_RfQResponse_ID, rrl.C_RfQResponseLine_ID AS C_RfQResponseLine_ID, rrl.C_RfQLine_ID AS C_RfQLine_ID, rq.C_RfQResponseLineQty_ID AS C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID AS C_RfQLineQty_ID, rrl.AD_Client_ID AS AD_Client_ID, rrl.AD_Org_ID AS AD_Org_ID, rrl.IsActive AS IsActive, rrl.Created AS Created, rrl.CreatedBy AS CreatedBy, rrl.Updated AS Updated, rrl.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, rl.Line AS Line, rl.M_Product_ID AS M_Product_ID, rl.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, COALESCE(p.Name|| COALESCE(productAttribute(rl.M_AttributeSetInstance_ID),N''),rl.Description) AS Name, CASE WHEN p.Name IS NOT NULL THEN rl.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, rl.Help AS Help, rl.DateWorkStart AS DateWorkStart, rl.DeliveryDays AS DeliveryDays, q.C_UOM_ID AS C_UOM_ID, uom.UOMSymbol AS UOMSymbol, q.BenchmarkPrice AS BenchmarkPrice, q.Qty AS Qty, rq.Price AS Price, rq.Discount AS Discount FROM C_RfQResponseLineQty rq INNER JOIN C_RfQLineQty q ON (rq.C_RfQLineQty_ID=q.C_RfQLineQty_ID) INNER JOIN C_UOM uom ON (q.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_RfQResponseLine rrl ON (rq.C_RfQResponseLine_ID=rrl.C_RfQResponseLine_ID) INNER JOIN C_RfQLine rl ON (rrl.C_RfQLine_ID=rl.C_RfQLine_ID) LEFT OUTER JOIN M_Product p ON (rl.M_Product_ID=p.M_Product_ID) WHERE rq.IsActive='Y' AND q.IsActive='Y' AND rrl.IsActive='Y' AND rl.IsActive='Y' [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_RfQResponseLine_v(C_RfQResponse_ID, C_RfQResponseLine_ID, C_RfQLine_ID, C_RfQResponseLineQty_ID, C_RfQLineQty_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, Line, M_Product_ID, M_AttributeSetInstance_ID, Name, Description, DocumentNote, UPC, SKU, ProductValue, Help, DateWorkStart, DeliveryDays, C_UOM_ID, UOMSymbol, BenchmarkPrice, Qty, Price, Discount) AS SELECT rrl.C_RfQResponse_ID AS C_RfQResponse_ID, rrl.C_RfQResponseLine_ID AS C_RfQResponseLine_ID, rrl.C_RfQLine_ID AS C_RfQLine_ID, rq.C_RfQResponseLineQty_ID AS C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID AS C_RfQLineQty_ID, rrl.AD_Client_ID AS AD_Client_ID, rrl.AD_Org_ID AS AD_Org_ID, rrl.IsActive AS IsActive, rrl.Created AS Created, rrl.CreatedBy AS CreatedBy, rrl.Updated AS Updated, rrl.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, rl.Line AS Line, rl.M_Product_ID AS M_Product_ID, rl.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, COALESCE(p.Name|| COALESCE(productAttribute(rl.M_AttributeSetInstance_ID),N''),rl.Description) AS Name, CASE WHEN p.Name IS NOT NULL THEN rl.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, rl.Help AS Help, rl.DateWorkStart AS DateWorkStart, rl.DeliveryDays AS DeliveryDays, q.C_UOM_ID AS C_UOM_ID, uom.UOMSymbol AS UOMSymbol, q.BenchmarkPrice AS BenchmarkPrice, q.Qty AS Qty, rq.Price AS Price, rq.Discount AS Discount FROM C_RfQResponseLineQty rq INNER JOIN C_RfQLineQty q ON (rq.C_RfQLineQty_ID=q.C_RfQLineQty_ID) INNER JOIN C_UOM uom ON (q.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_RfQResponseLine rrl ON (rq.C_RfQResponseLine_ID=rrl.C_RfQResponseLine_ID) INNER JOIN C_RfQLine rl ON (rrl.C_RfQLine_ID=rl.C_RfQLine_ID) LEFT OUTER JOIN M_Product p ON (rl.M_Product_ID=p.M_Product_ID) WHERE rq.IsActive='Y' AND q.IsActive='Y' AND rrl.IsActive='Y' AND rl.IsActive='Y' [18]
17:21:18.250 ViewCreate.doIt: Created view C_RfQResponse_v [18]
17:21:18.296 ViewCreate.doIt: Created view C_RfQResponseLineQty_v [18]
17:21:18.343 ViewCreate.doIt: Created view RV_InOutConfirm [18]
17:21:18.390 ViewCreate.doIt: Created view RV_InOutLineConfirm [18]
17:21:18.453 ViewCreate.doIt: Created view M_InOut_LineConfirm_v [18]
17:21:18.515 ViewCreate.doIt: Created view M_InOutConfirm_v [18]
17:21:18.562 ViewCreate.doIt: Created view RV_Allocation [18]
17:21:18.625 ViewCreate.doIt: Created view RV_PrintFormatDetail [18]
17:21:18.734 ViewCreate.doIt: Created view C_Dunning_Header_v [18]
17:21:18.812 ViewCreate.doIt: Created view C_Dunning_Line_v [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_InOutDetails(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, M_InOut_ID, IsSOTrx, DocumentNo, DocAction, DocStatus, Posted, Processed, C_DocType_ID, Description, C_Order_ID, DateOrdered, MovementType, MovementDate, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID, SalesRep_ID, M_Warehouse_ID, POReference, DeliveryRule, FreightCostRule, FreightAmt, DeliveryViaRule, M_Shipper_ID, PriorityRule, DatePrinted, NoPackages, PickDate, ShipDate, TrackingNo, AD_OrgTrx_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, DateReceived, IsApproved, IsInDispute, M_InOutLine_ID, Line, LineDescription, C_OrderLine_ID, M_Locator_ID, M_Product_ID, C_UOM_ID, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, MovementQty, QtyEntered, IsDescription, ConfirmedQty, PickedQty, ScrappedQty, TargetQty, LocatorValue, X, Y, Z, IsReturnTrx) AS SELECT h.AD_Client_ID AS AD_Client_ID, h.AD_Org_ID AS AD_Org_ID, l.IsActive AS IsActive, l.Created AS Created, l.CreatedBy AS CreatedBy, l.Updated AS Updated, l.UpdatedBy AS UpdatedBy, h.M_InOut_ID AS M_InOut_ID, h.IsSOTrx AS IsSOTrx, h.DocumentNo AS DocumentNo, h.DocAction AS DocAction, h.DocStatus AS DocStatus, h.Posted AS Posted, h.Processed AS Processed, h.C_DocType_ID AS C_DocType_ID, h.Description AS Description, h.C_Order_ID AS C_Order_ID, h.DateOrdered AS DateOrdered, h.MovementType AS MovementType, h.MovementDate AS MovementDate, h.DateAcct AS DateAcct, h.C_BPartner_ID AS C_BPartner_ID, h.C_BPartner_Location_ID AS C_BPartner_Location_ID, h.AD_User_ID AS AD_User_ID, h.SalesRep_ID AS SalesRep_ID, h.M_Warehouse_ID AS M_Warehouse_ID, h.POReference AS POReference, h.DeliveryRule AS DeliveryRule, h.FreightCostRule AS FreightCostRule, h.FreightAmt AS FreightAmt, h.DeliveryViaRule AS DeliveryViaRule, h.M_Shipper_ID AS M_Shipper_ID, h.PriorityRule AS PriorityRule, h.DatePrinted AS DatePrinted, h.NoPackages AS NoPackages, h.PickDate AS PickDate, h.ShipDate AS ShipDate, h.TrackingNo AS TrackingNo, h.AD_OrgTrx_ID AS AD_OrgTrx_ID, h.C_Project_ID AS C_Project_ID, h.C_Campaign_ID AS C_Campaign_ID, h.C_Activity_ID AS C_Activity_ID, h.User1_ID AS User1_ID, h.User2_ID AS User2_ID, h.DateReceived AS DateReceived, h.IsApproved AS IsApproved, h.IsInDispute AS IsInDispute, l.M_InOutLine_ID AS M_InOutLine_ID, l.Line AS Line, l.Description AS LineDescription, l.C_OrderLine_ID AS C_OrderLine_ID, l.M_Locator_ID AS M_Locator_ID, l.M_Product_ID AS M_Product_ID, l.C_UOM_ID AS C_UOM_ID, l.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(l.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, CASE WHEN h.IsReturnTrx='Y' THEN l.MovementQty*-1 ELSE l.MovementQty END AS MovementQty, CASE WHEN h.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QtyEntered, l.IsDescription AS IsDescription, CASE WHEN h.IsReturnTrx='Y' THEN l.ConfirmedQty*-1 ELSE l.ConfirmedQty END AS ConfirmedQty, CASE WHEN h.IsReturnTrx='Y' THEN l.PickedQty*-1 ELSE l.PickedQty END AS PickedQty, CASE WHEN h.IsReturnTrx='Y' THEN l.ScrappedQty*-1 ELSE l.ScrappedQty END AS ScrappedQty, CASE WHEN h.IsReturnTrx='Y' THEN l.TargetQty*-1 ELSE l.TargetQty END AS TargetQty, loc.Value AS LocatorValue, loc.X AS X, loc.Y AS Y, loc.Z AS Z, h.IsReturnTrx AS IsReturnTrx FROM M_InOut h INNER JOIN M_InOutLine l ON (h.M_InOut_ID=l.M_InOut_ID) LEFT OUTER JOIN M_Locator loc ON (l.M_Locator_ID=loc.M_Locator_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_InOutDetails(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, M_InOut_ID, IsSOTrx, DocumentNo, DocAction, DocStatus, Posted, Processed, C_DocType_ID, Description, C_Order_ID, DateOrdered, MovementType, MovementDate, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID, SalesRep_ID, M_Warehouse_ID, POReference, DeliveryRule, FreightCostRule, FreightAmt, DeliveryViaRule, M_Shipper_ID, PriorityRule, DatePrinted, NoPackages, PickDate, ShipDate, TrackingNo, AD_OrgTrx_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, DateReceived, IsApproved, IsInDispute, M_InOutLine_ID, Line, LineDescription, C_OrderLine_ID, M_Locator_ID, M_Product_ID, C_UOM_ID, M_AttributeSetInstance_ID, ProductAttributeName, M_AttributeSet_ID, M_Lot_ID, GuaranteeDate, Lot, SerNo, MovementQty, QtyEntered, IsDescription, ConfirmedQty, PickedQty, ScrappedQty, TargetQty, LocatorValue, X, Y, Z, IsReturnTrx) AS SELECT h.AD_Client_ID AS AD_Client_ID, h.AD_Org_ID AS AD_Org_ID, l.IsActive AS IsActive, l.Created AS Created, l.CreatedBy AS CreatedBy, l.Updated AS Updated, l.UpdatedBy AS UpdatedBy, h.M_InOut_ID AS M_InOut_ID, h.IsSOTrx AS IsSOTrx, h.DocumentNo AS DocumentNo, h.DocAction AS DocAction, h.DocStatus AS DocStatus, h.Posted AS Posted, h.Processed AS Processed, h.C_DocType_ID AS C_DocType_ID, h.Description AS Description, h.C_Order_ID AS C_Order_ID, h.DateOrdered AS DateOrdered, h.MovementType AS MovementType, h.MovementDate AS MovementDate, h.DateAcct AS DateAcct, h.C_BPartner_ID AS C_BPartner_ID, h.C_BPartner_Location_ID AS C_BPartner_Location_ID, h.AD_User_ID AS AD_User_ID, h.SalesRep_ID AS SalesRep_ID, h.M_Warehouse_ID AS M_Warehouse_ID, h.POReference AS POReference, h.DeliveryRule AS DeliveryRule, h.FreightCostRule AS FreightCostRule, h.FreightAmt AS FreightAmt, h.DeliveryViaRule AS DeliveryViaRule, h.M_Shipper_ID AS M_Shipper_ID, h.PriorityRule AS PriorityRule, h.DatePrinted AS DatePrinted, h.NoPackages AS NoPackages, h.PickDate AS PickDate, h.ShipDate AS ShipDate, h.TrackingNo AS TrackingNo, h.AD_OrgTrx_ID AS AD_OrgTrx_ID, h.C_Project_ID AS C_Project_ID, h.C_Campaign_ID AS C_Campaign_ID, h.C_Activity_ID AS C_Activity_ID, h.User1_ID AS User1_ID, h.User2_ID AS User2_ID, h.DateReceived AS DateReceived, h.IsApproved AS IsApproved, h.IsInDispute AS IsInDispute, l.M_InOutLine_ID AS M_InOutLine_ID, l.Line AS Line, l.Description AS LineDescription, l.C_OrderLine_ID AS C_OrderLine_ID, l.M_Locator_ID AS M_Locator_ID, l.M_Product_ID AS M_Product_ID, l.C_UOM_ID AS C_UOM_ID, l.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, productAttribute(l.M_AttributeSetInstance_ID) AS ProductAttributeName, pasi.M_AttributeSet_ID AS M_AttributeSet_ID, pasi.M_Lot_ID AS M_Lot_ID, pasi.GuaranteeDate AS GuaranteeDate, pasi.Lot AS Lot, pasi.SerNo AS SerNo, CASE WHEN h.IsReturnTrx='Y' THEN l.MovementQty*-1 ELSE l.MovementQty END AS MovementQty, CASE WHEN h.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QtyEntered, l.IsDescription AS IsDescription, CASE WHEN h.IsReturnTrx='Y' THEN l.ConfirmedQty*-1 ELSE l.ConfirmedQty END AS ConfirmedQty, CASE WHEN h.IsReturnTrx='Y' THEN l.PickedQty*-1 ELSE l.PickedQty END AS PickedQty, CASE WHEN h.IsReturnTrx='Y' THEN l.ScrappedQty*-1 ELSE l.ScrappedQty END AS ScrappedQty, CASE WHEN h.IsReturnTrx='Y' THEN l.TargetQty*-1 ELSE l.TargetQty END AS TargetQty, loc.Value AS LocatorValue, loc.X AS X, loc.Y AS Y, loc.Z AS Z, h.IsReturnTrx AS IsReturnTrx FROM M_InOut h INNER JOIN M_InOutLine l ON (h.M_InOut_ID=l.M_InOut_ID) LEFT OUTER JOIN M_Locator loc ON (l.M_Locator_ID=loc.M_Locator_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) [18]
17:21:21.343 ViewCreate.doIt: Created view RV_Payment [18]
17:21:21.421 ViewCreate.doIt: Created view RV_BPartnerOpen [18]
17:21:21.484 ViewCreate.doIt: Created view RV_CommissionRunDetail [18]
17:21:21.546 ViewCreate.doIt: Created view M_Transaction_v [18]
17:21:21.625 ViewCreate.doIt: Created view RV_RequestUpdates [18]
17:21:21.687 ViewCreate.doIt: Created view RV_RequestUpdates_Only [18]
17:21:21.750 ViewCreate.doIt: Created view T_InvoiceGL_v [18]
17:21:21.812 ViewCreate.doIt: Created view RV_Cost [18]
17:21:21.875 ViewCreate.doIt: Created view RV_CostSummary [18]
17:21:21.921 ViewCreate.doIt: Created view RV_CostDetail [18]
17:21:21.984 ViewCreate.doIt: Created view M_InOutLineMA_v [18]
17:21:22.031 ViewCreate.doIt: Created view M_MovementLineMA_v [18]
17:21:22.093 ViewCreate.doIt: Created view RV_Cash_Detail [18]
17:21:22.140 ViewCreate.doIt: Created view RV_Product_Costing [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_Invoice_LineTax_v(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Invoice_ID, C_InvoiceLine_ID, C_Tax_ID, TaxAmt, LineTotalAmt, TaxIndicator, Line, M_Product_ID, QtyInvoiced, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN il.QtyInvoiced<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyInvoiced END AS QtyInvoiced, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyEntered END AS QtyEntered, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(c.Name,p.Name||COALESCE(productAttribute(il.M_AttributeSetInstance_ID),N''),il.Description) AS Name, CASE WHEN COALESCE(c.Name,p.Name) IS NOT NULL THEN il.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 THEN il.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 AND il.QtyEntered<>0 THEN il.PriceList*il.QtyInvoiced/il.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList>il.PriceActual AND il.PriceList<>0 THEN (il.PriceList-il.PriceActual)/il.PriceList*100 END AS Discount, CASE WHEN il.PriceActual<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceActual END AS PriceActual, CASE WHEN il.PriceEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceEntered END AS PriceEntered, CASE WHEN il.LineNetAmt<>0 OR il.M_Product_ID IS NOT NULL THEN il.LineNetAmt END AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_InvoiceLine il INNER JOIN C_UOM uom ON (il.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_ID) LEFT OUTER JOIN C_Tax t ON (il.C_Tax_ID=t.C_Tax_ID) LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN C_Charge c ON (il.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_BPartner_Product pp ON (il.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) LEFT OUTER JOIN S_ResourceAssignment ra ON (il.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, il.QtyInvoiced*b.BOMQty AS QtyInvoiced, il.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, p.Name AS Name, b.Description AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_InvoiceLine il ON (bom.M_Product_ID=il.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=il.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM uom ON (p.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN C_Tax t ON (il.C_Tax_ID=t.C_Tax_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) WHERE b.IsActive = 'Y' UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, il.Line AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, il.Description AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_InvoiceLine il WHERE il.C_UOM_ID IS NULL UNION SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, IsActive AS IsActive, Created AS Created, CreatedBy AS CreatedBy, Updated AS Updated, UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, 999998 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_Invoice UNION SELECT it.AD_Client_ID AS AD_Client_ID, it.AD_Org_ID AS AD_Org_ID, it.IsActive AS IsActive, it.Created AS Created, it.CreatedBy AS CreatedBy, it.Updated AS Updated, it.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, it.C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, it.C_Tax_ID AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, 999999 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceActual, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceEntered, CASE WHEN it.IsTaxIncluded='Y' THEN 0 ELSE it.TaxAmt END AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_InvoiceTax it INNER JOIN C_Tax t ON (it.C_Tax_ID=t.C_Tax_ID) [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_Invoice_LineTax_v(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Invoice_ID, C_InvoiceLine_ID, C_Tax_ID, TaxAmt, LineTotalAmt, TaxIndicator, Line, M_Product_ID, QtyInvoiced, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN il.QtyInvoiced<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyInvoiced END AS QtyInvoiced, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyEntered END AS QtyEntered, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(c.Name,p.Name||COALESCE(productAttribute(il.M_AttributeSetInstance_ID),N''),il.Description) AS Name, CASE WHEN COALESCE(c.Name,p.Name) IS NOT NULL THEN il.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 THEN il.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 AND il.QtyEntered<>0 THEN il.PriceList*il.QtyInvoiced/il.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList>il.PriceActual AND il.PriceList<>0 THEN (il.PriceList-il.PriceActual)/il.PriceList*100 END AS Discount, CASE WHEN il.PriceActual<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceActual END AS PriceActual, CASE WHEN il.PriceEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceEntered END AS PriceEntered, CASE WHEN il.LineNetAmt<>0 OR il.M_Product_ID IS NOT NULL THEN il.LineNetAmt END AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_InvoiceLine il INNER JOIN C_UOM uom ON (il.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_ID) LEFT OUTER JOIN C_Tax t ON (il.C_Tax_ID=t.C_Tax_ID) LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN C_Charge c ON (il.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_BPartner_Product pp ON (il.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) LEFT OUTER JOIN S_ResourceAssignment ra ON (il.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, il.QtyInvoiced*b.BOMQty AS QtyInvoiced, il.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, p.Name AS Name, b.Description AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_InvoiceLine il ON (bom.M_Product_ID=il.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=il.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM uom ON (p.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN C_Tax t ON (il.C_Tax_ID=t.C_Tax_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) WHERE b.IsActive = 'Y' UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, il.Line AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, il.Description AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_InvoiceLine il WHERE il.C_UOM_ID IS NULL UNION SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, IsActive AS IsActive, Created AS Created, CreatedBy AS CreatedBy, Updated AS Updated, UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, 999998 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_Invoice UNION SELECT it.AD_Client_ID AS AD_Client_ID, it.AD_Org_ID AS AD_Org_ID, it.IsActive AS IsActive, it.Created AS Created, it.CreatedBy AS CreatedBy, it.Updated AS Updated, it.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, it.C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, it.C_Tax_ID AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, 999999 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceActual, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceEntered, CASE WHEN it.IsTaxIncluded='Y' THEN 0 ELSE it.TaxAmt END AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_InvoiceTax it INNER JOIN C_Tax t ON (it.C_Tax_ID=t.C_Tax_ID) [18]
17:21:30.968 ViewCreate.doIt: Created view C_Order_Header_v [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_Order_LineTax_v(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Order_ID, C_OrderLine_ID, C_Tax_ID, TaxIndicator, C_BPartner_ID, C_BPartner_Location_ID, BPName, C_Location_ID, Line, M_Product_ID, QtyOrdered, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, ol.C_BPartner_ID AS C_BPartner_ID, ol.C_BPartner_Location_ID AS C_BPartner_Location_ID, bp.Name AS BPName, bpl.C_Location_ID AS C_Location_ID, ol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN ol.QtyOrdered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered END AS QtyOrdered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyEntered END AS QtyEntered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(c.Name,p.Name|| COALESCE(productAttribute(ol.M_AttributeSetInstance_ID),N''),ol.Description) AS Name, CASE WHEN COALESCE(c.Name,p.Name) IS NOT NULL THEN ol.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 THEN ol.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 AND ol.QtyEntered<>0 THEN ol.PriceList*ol.QtyOrdered/ol.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList>ol.PriceActual AND ol.PriceList<>0 THEN (ol.PriceList-ol.PriceActual)/ol.PriceList*100 END AS Discount, CASE WHEN ol.PriceActual<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceActual END AS PriceActual, CASE WHEN ol.PriceEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceEntered END AS PriceEntered, CASE WHEN ol.LineNetAmt<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.LineNetAmt END AS LineNetAmt, p.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_OrderLine ol INNER JOIN C_UOM uom ON (ol.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Order i ON (ol.C_Order_ID=i.C_Order_ID) LEFT OUTER JOIN M_Product p ON (ol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN S_ResourceAssignment ra ON (ol.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN C_Charge c ON (ol.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_BPartner_Product pp ON (ol.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) INNER JOIN C_BPartner bp ON (ol.C_BPartner_ID=bp.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (ol.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID) LEFT OUTER JOIN C_Tax t ON (ol.C_Tax_ID=t.C_Tax_ID) UNION SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, ol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, ol.QtyOrdered*b.BOMQty AS QtyOrdered, ol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, p.Name AS Name, b.Description AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, p.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_OrderLine ol ON (bom.M_Product_ID=ol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=ol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM uom ON (p.C_UOM_ID=uom.C_UOM_ID) AND b.IsActive = 'Y' UNION SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, IsActive AS IsActive, Created AS Created, CreatedBy AS CreatedBy, Updated AS Updated, UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, NULLIF(1,1) AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_Order UNION SELECT ot.AD_Client_ID AS AD_Client_ID, ot.AD_Org_ID AS AD_Org_ID, ot.IsActive AS IsActive, ot.Created AS Created, ot.CreatedBy AS CreatedBy, ot.Updated AS Updated, ot.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, ot.C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, ot.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceActual, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceEntered, CASE WHEN ot.IsTaxIncluded='Y' THEN 0 ELSE ot.TaxAmt END AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_OrderTax ot INNER JOIN C_Tax t ON (ot.C_Tax_ID=t.C_Tax_ID) [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_Order_LineTax_v(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Order_ID, C_OrderLine_ID, C_Tax_ID, TaxIndicator, C_BPartner_ID, C_BPartner_Location_ID, BPName, C_Location_ID, Line, M_Product_ID, QtyOrdered, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, ol.C_BPartner_ID AS C_BPartner_ID, ol.C_BPartner_Location_ID AS C_BPartner_Location_ID, bp.Name AS BPName, bpl.C_Location_ID AS C_Location_ID, ol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN ol.QtyOrdered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered END AS QtyOrdered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyEntered END AS QtyEntered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(c.Name,p.Name|| COALESCE(productAttribute(ol.M_AttributeSetInstance_ID),N''),ol.Description) AS Name, CASE WHEN COALESCE(c.Name,p.Name) IS NOT NULL THEN ol.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 THEN ol.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 AND ol.QtyEntered<>0 THEN ol.PriceList*ol.QtyOrdered/ol.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList>ol.PriceActual AND ol.PriceList<>0 THEN (ol.PriceList-ol.PriceActual)/ol.PriceList*100 END AS Discount, CASE WHEN ol.PriceActual<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceActual END AS PriceActual, CASE WHEN ol.PriceEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceEntered END AS PriceEntered, CASE WHEN ol.LineNetAmt<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.LineNetAmt END AS LineNetAmt, p.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_OrderLine ol INNER JOIN C_UOM uom ON (ol.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Order i ON (ol.C_Order_ID=i.C_Order_ID) LEFT OUTER JOIN M_Product p ON (ol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN S_ResourceAssignment ra ON (ol.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN C_Charge c ON (ol.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_BPartner_Product pp ON (ol.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) INNER JOIN C_BPartner bp ON (ol.C_BPartner_ID=bp.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (ol.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID) LEFT OUTER JOIN C_Tax t ON (ol.C_Tax_ID=t.C_Tax_ID) UNION SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, ol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, ol.QtyOrdered*b.BOMQty AS QtyOrdered, ol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, p.Name AS Name, b.Description AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, p.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_OrderLine ol ON (bom.M_Product_ID=ol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=ol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM uom ON (p.C_UOM_ID=uom.C_UOM_ID) AND b.IsActive = 'Y' UNION SELECT AD_Client_ID AS AD_Client_ID, AD_Org_ID AS AD_Org_ID, IsActive AS IsActive, Created AS Created, CreatedBy AS CreatedBy, Updated AS Updated, UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, NULLIF(1,1) AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_Order UNION SELECT ot.AD_Client_ID AS AD_Client_ID, ot.AD_Org_ID AS AD_Org_ID, ot.IsActive AS IsActive, ot.Created AS Created, ot.CreatedBy AS CreatedBy, ot.Updated AS Updated, ot.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, ot.C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, ot.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceActual, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceEntered, CASE WHEN ot.IsTaxIncluded='Y' THEN 0 ELSE ot.TaxAmt END AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_OrderTax ot INNER JOIN C_Tax t ON (ot.C_Tax_ID=t.C_Tax_ID) [18]
17:21:32.000 ViewCreate.doIt: Created view C_PaySelection_Check_v [18]
17:21:32.031 ViewCreate.doIt: Created view C_PaySelection_Remittance_v [18]
17:21:32.093 ViewCreate.doIt: Created view M_InOut_Header_v [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW M_InOut_Line_v(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, M_InOut_ID, M_InOutLine_ID, Line, M_Product_ID, MovementQty, QtyEntered, UOMSymbol, QtyOrdered, QtyDelivered, QtyBackOrdered, Name, Description, DocumentNote, UPC, SKU, ProductValue, M_Locator_ID, M_Warehouse_ID, X, Y, Z, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.MovementQty END AS MovementQty, CASE WHEN iol.QtyEntered<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.QtyEntered END AS QtyEntered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, ol.QtyOrdered AS QtyOrdered, ol.QtyDelivered AS QtyDelivered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered-ol.QtyDelivered END AS QtyBackOrdered, COALESCE(p.Name|| COALESCE(productAttribute(iol.M_AttributeSetInstance_ID),N''),c.Name,iol.Description) AS Name, CASE WHEN COALESCE(c.Name,p.Name) IS NOT NULL THEN iol.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_InOutLine iol INNER JOIN C_UOM uom ON (iol.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN M_Product p ON (iol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) LEFT OUTER JOIN C_OrderLine ol ON (iol.C_OrderLine_ID=ol.C_OrderLine_ID) LEFT OUTER JOIN C_Charge c ON (iol.C_Charge_ID=c.C_Charge_ID) UNION SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, iol.MovementQty*b.BOMQty AS MovementQty, iol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyDelivered, NULLIF(1,1) AS QtyBackOrdered, p.Name AS Name, b.Description AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN M_InOutLine iol ON (bom.M_Product_ID=iol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=iol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsPickListPrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM uom ON (p.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) WHERE b.IsActive = 'Y' [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW M_InOut_Line_v(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, M_InOut_ID, M_InOutLine_ID, Line, M_Product_ID, MovementQty, QtyEntered, UOMSymbol, QtyOrdered, QtyDelivered, QtyBackOrdered, Name, Description, DocumentNote, UPC, SKU, ProductValue, M_Locator_ID, M_Warehouse_ID, X, Y, Z, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.MovementQty END AS MovementQty, CASE WHEN iol.QtyEntered<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.QtyEntered END AS QtyEntered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, ol.QtyOrdered AS QtyOrdered, ol.QtyDelivered AS QtyDelivered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered-ol.QtyDelivered END AS QtyBackOrdered, COALESCE(p.Name|| COALESCE(productAttribute(iol.M_AttributeSetInstance_ID),N''),c.Name,iol.Description) AS Name, CASE WHEN COALESCE(c.Name,p.Name) IS NOT NULL THEN iol.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_InOutLine iol INNER JOIN C_UOM uom ON (iol.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN M_Product p ON (iol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) LEFT OUTER JOIN C_OrderLine ol ON (iol.C_OrderLine_ID=ol.C_OrderLine_ID) LEFT OUTER JOIN C_Charge c ON (iol.C_Charge_ID=c.C_Charge_ID) UNION SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, CAST('en_US' AS VARCHAR(5)) AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, iol.MovementQty*b.BOMQty AS MovementQty, iol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyDelivered, NULLIF(1,1) AS QtyBackOrdered, p.Name AS Name, b.Description AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, p.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN M_InOutLine iol ON (bom.M_Product_ID=iol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=iol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsPickListPrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM uom ON (p.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) WHERE b.IsActive = 'Y' [18]
17:21:32.843 ViewCreate.doIt: Created view C_Invoice_Header_v [18]
17:21:32.921 ViewCreate.doIt: Created view RV_BPartner [18]
17:21:33.031 ViewCreate.doIt: Created view C_Project_Header_v [18]
17:21:33.078 ViewCreate.doIt: Created view C_Project_Details_v [18]
17:21:33.125 ViewCreate.doIt: Created view RV_ProjectCycle [18]
17:21:33.156 ViewCreate.doIt: Created view RV_Asset_Delivery [18]
17:21:33.187 ViewCreate.doIt: Created view RV_Asset_Customer [18]
17:21:33.234 ViewCreate.doIt: Created view RV_ProjectLineIssue [18]
17:21:33.281 ViewCreate.doIt: Created view RV_Transaction [18]
17:21:33.312 ViewCreate.doIt: Created view RV_Storage [18]
17:21:33.328 ViewCreate.doIt: Created view RV_Click_Unprocessed [18]
17:21:33.359 ViewCreate.doIt: Created view RV_Click_Month [18]
17:21:33.437 ViewCreate.doIt: Created view RV_UnPosted [18]
17:21:33.484 ViewCreate.doIt: Created view RV_WarehousePrice [18]
17:21:33.515 ViewCreate.doIt: Created view RV_C_InvoiceTax [18]
17:21:33.546 ViewCreate.doIt: Created view RV_Fact_Acct_Period [18]
17:21:33.578 ViewCreate.doIt: Created view RV_Fact_Acct_Day [18]
17:21:33.625 ViewCreate.doIt: Created view RV_Fact_Acct [18]
17:21:33.656 ViewCreate.doIt: Created view AD_BView_SubTypes_V [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_SalesDetails_By_BP_V(AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ORDER_ID, DOCSTATUS, DOCACTION, C_DOCTYPE_ID, ISAPPROVED, ISCREDITAPPROVED, SALESREP_ID, BILL_BPARTNER_ID, BILL_LOCATION_ID, BILL_USER_ID, ISDROPSHIP, POREFERENCE, C_CURRENCY_ID, ISSOTRX, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, AD_USER_ID, C_BP_GROUP_ID, C_CAMPAIGN_ID, C_PROJECT_ID, C_ACTIVITY_ID, C_PROJECTPHASE_ID, C_PROJECTTASK_ID, C_ORDERLINE_ID, DATEORDERED, DATEPROMISED, M_PRODUCT_ID, M_WAREHOUSE_ID, M_ATTRIBUTESETINSTANCE_ID, PRODUCTATTRIBUTENAME, M_ATTRIBUTESET_ID, M_LOT_ID, GUARANTEEDATE, LOT, SERNO, M_PRODUCT_CATEGORY_ID, C_UOM_ID, QTYENTERED, QTYORDERED, QTYRESERVED, QTYDELIVERED, QTYINVOICED, PRICEACTUAL, PRICEENTERED, QTYTODELIVER, QTYTOINVOICE, NETAMTTOINVOICE, QTYLOSTSALES, AMTLOSTSALES, DISCOUNT, MARGIN, MARGINAMT, ISRETURNTRX, SO_CREDITLIMIT, SO_CREDITUSED, C_BP_BANKACCOUNT_ID, M_INOUT_ID, PICKDATE, SHIPDATE, DATERECEIVED, M_INOUTLINE_ID, LINE) AS SELECT l.AD_Client_ID AS AD_CLIENT_ID, l.AD_Org_ID AS AD_ORG_ID, l.IsActive AS ISACTIVE, l.Created AS CREATED, l.CreatedBy AS CREATEDBY, l.Updated AS UPDATED, l.UpdatedBy AS UPDATEDBY, o.C_Order_ID AS C_ORDER_ID, o.DocStatus AS DOCSTATUS, o.DocAction AS DOCACTION, o.C_DocType_ID AS C_DOCTYPE_ID, o.IsApproved AS ISAPPROVED, o.IsCreditApproved AS ISCREDITAPPROVED, o.SalesRep_ID AS SALESREP_ID, o.Bill_BPartner_ID AS BILL_BPARTNER_ID, o.Bill_Location_ID AS BILL_LOCATION_ID, o.Bill_User_ID AS BILL_USER_ID, o.IsDropShip AS ISDROPSHIP, o.POReference AS POREFERENCE, o.C_Currency_ID AS C_CURRENCY_ID, o.IsSOTrx AS ISSOTRX, l.C_BPartner_ID AS C_BPARTNER_ID, l.C_BPartner_Location_ID AS C_BPARTNER_LOCATION_ID, o.AD_User_ID AS AD_USER_ID, bp.C_BP_Group_ID AS C_BP_GROUP_ID, l.C_Campaign_ID AS C_CAMPAIGN_ID, l.C_Project_ID AS C_PROJECT_ID, l.C_Activity_ID AS C_ACTIVITY_ID, l.C_ProjectPhase_ID AS C_PROJECTPHASE_ID, l.C_ProjectTask_ID AS C_PROJECTTASK_ID, l.C_OrderLine_ID AS C_ORDERLINE_ID, l.DateOrdered AS DATEORDERED, l.DatePromised AS DATEPROMISED, l.M_Product_ID AS M_PRODUCT_ID, l.M_Warehouse_ID AS M_WAREHOUSE_ID, l.M_AttributeSetInstance_ID AS M_ATTRIBUTESETINSTANCE_ID, productAttribute(l.M_AttributeSetInstance_ID) AS PRODUCTATTRIBUTENAME, pasi.M_AttributeSet_ID AS M_ATTRIBUTESET_ID, pasi.M_Lot_ID AS M_LOT_ID, pasi.GuaranteeDate AS GUARANTEEDATE, pasi.Lot AS LOT, pasi.SerNo AS SERNO, p.M_Product_Category_ID AS M_PRODUCT_CATEGORY_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QTYENTERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QTYORDERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QTYRESERVED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QTYDELIVERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QTYINVOICED, l.PriceActual AS PRICEACTUAL, l.PriceEntered AS PRICEENTERED, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QTYTODELIVER, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QTYTOINVOICE, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NETAMTTOINVOICE, l.QtyLostSales AS QTYLOSTSALES, l.QtyLostSales*l.PriceActual AS AMTLOSTSALES, CASE WHEN PriceList=0 THEN 0 ELSE ROUND((PriceList-PriceActual)/PriceList*100,2) END AS DISCOUNT, CASE WHEN PriceLimit=0 THEN 0 ELSE ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS MARGIN, CASE WHEN PriceLimit=0 THEN 0 ELSE (CASE WHEN o.IsReturnTrx='Y' THEN (PriceActual-PriceLimit)*QtyDelivered*-1 ELSE (PriceActual-PriceLimit)*QtyDelivered END) END AS MARGINAMT, o.IsReturnTrx AS ISRETURNTRX, bp.SO_CreditLimit AS SO_CREDITLIMIT, bp.SO_CreditUsed AS SO_CREDITUSED, bpa.C_BP_BankAccount_ID AS C_BP_BANKACCOUNT_ID, h.M_InOut_ID AS M_INOUT_ID, h.PickDate AS PICKDATE, h.ShipDate AS SHIPDATE, h.DateReceived AS DATERECEIVED, hl.M_InOutLine_ID AS M_INOUTLINE_ID, hl.Line AS LINE FROM C_Order o INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID) INNER JOIN C_BP_BankAccount bpa ON (bp.C_BPartner_ID = bpa.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) LEFT OUTER JOIN M_InOut h ON (o.C_Order_ID = h.C_Order_ID) LEFT OUTER JOIN M_InOutLine hl ON (h.M_InOut_ID=hl.M_InOut_ID) WHERE o.IsSOTrx='Y' [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_SalesDetails_By_BP_V(AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ORDER_ID, DOCSTATUS, DOCACTION, C_DOCTYPE_ID, ISAPPROVED, ISCREDITAPPROVED, SALESREP_ID, BILL_BPARTNER_ID, BILL_LOCATION_ID, BILL_USER_ID, ISDROPSHIP, POREFERENCE, C_CURRENCY_ID, ISSOTRX, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, AD_USER_ID, C_BP_GROUP_ID, C_CAMPAIGN_ID, C_PROJECT_ID, C_ACTIVITY_ID, C_PROJECTPHASE_ID, C_PROJECTTASK_ID, C_ORDERLINE_ID, DATEORDERED, DATEPROMISED, M_PRODUCT_ID, M_WAREHOUSE_ID, M_ATTRIBUTESETINSTANCE_ID, PRODUCTATTRIBUTENAME, M_ATTRIBUTESET_ID, M_LOT_ID, GUARANTEEDATE, LOT, SERNO, M_PRODUCT_CATEGORY_ID, C_UOM_ID, QTYENTERED, QTYORDERED, QTYRESERVED, QTYDELIVERED, QTYINVOICED, PRICEACTUAL, PRICEENTERED, QTYTODELIVER, QTYTOINVOICE, NETAMTTOINVOICE, QTYLOSTSALES, AMTLOSTSALES, DISCOUNT, MARGIN, MARGINAMT, ISRETURNTRX, SO_CREDITLIMIT, SO_CREDITUSED, C_BP_BANKACCOUNT_ID, M_INOUT_ID, PICKDATE, SHIPDATE, DATERECEIVED, M_INOUTLINE_ID, LINE) AS SELECT l.AD_Client_ID AS AD_CLIENT_ID, l.AD_Org_ID AS AD_ORG_ID, l.IsActive AS ISACTIVE, l.Created AS CREATED, l.CreatedBy AS CREATEDBY, l.Updated AS UPDATED, l.UpdatedBy AS UPDATEDBY, o.C_Order_ID AS C_ORDER_ID, o.DocStatus AS DOCSTATUS, o.DocAction AS DOCACTION, o.C_DocType_ID AS C_DOCTYPE_ID, o.IsApproved AS ISAPPROVED, o.IsCreditApproved AS ISCREDITAPPROVED, o.SalesRep_ID AS SALESREP_ID, o.Bill_BPartner_ID AS BILL_BPARTNER_ID, o.Bill_Location_ID AS BILL_LOCATION_ID, o.Bill_User_ID AS BILL_USER_ID, o.IsDropShip AS ISDROPSHIP, o.POReference AS POREFERENCE, o.C_Currency_ID AS C_CURRENCY_ID, o.IsSOTrx AS ISSOTRX, l.C_BPartner_ID AS C_BPARTNER_ID, l.C_BPartner_Location_ID AS C_BPARTNER_LOCATION_ID, o.AD_User_ID AS AD_USER_ID, bp.C_BP_Group_ID AS C_BP_GROUP_ID, l.C_Campaign_ID AS C_CAMPAIGN_ID, l.C_Project_ID AS C_PROJECT_ID, l.C_Activity_ID AS C_ACTIVITY_ID, l.C_ProjectPhase_ID AS C_PROJECTPHASE_ID, l.C_ProjectTask_ID AS C_PROJECTTASK_ID, l.C_OrderLine_ID AS C_ORDERLINE_ID, l.DateOrdered AS DATEORDERED, l.DatePromised AS DATEPROMISED, l.M_Product_ID AS M_PRODUCT_ID, l.M_Warehouse_ID AS M_WAREHOUSE_ID, l.M_AttributeSetInstance_ID AS M_ATTRIBUTESETINSTANCE_ID, productAttribute(l.M_AttributeSetInstance_ID) AS PRODUCTATTRIBUTENAME, pasi.M_AttributeSet_ID AS M_ATTRIBUTESET_ID, pasi.M_Lot_ID AS M_LOT_ID, pasi.GuaranteeDate AS GUARANTEEDATE, pasi.Lot AS LOT, pasi.SerNo AS SERNO, p.M_Product_Category_ID AS M_PRODUCT_CATEGORY_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QTYENTERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QTYORDERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QTYRESERVED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QTYDELIVERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QTYINVOICED, l.PriceActual AS PRICEACTUAL, l.PriceEntered AS PRICEENTERED, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QTYTODELIVER, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QTYTOINVOICE, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NETAMTTOINVOICE, l.QtyLostSales AS QTYLOSTSALES, l.QtyLostSales*l.PriceActual AS AMTLOSTSALES, CASE WHEN PriceList=0 THEN 0 ELSE ROUND((PriceList-PriceActual)/PriceList*100,2) END AS DISCOUNT, CASE WHEN PriceLimit=0 THEN 0 ELSE ROUND((PriceActual-PriceLimit)/PriceLimit*100,2) END AS MARGIN, CASE WHEN PriceLimit=0 THEN 0 ELSE (CASE WHEN o.IsReturnTrx='Y' THEN (PriceActual-PriceLimit)*QtyDelivered*-1 ELSE (PriceActual-PriceLimit)*QtyDelivered END) END AS MARGINAMT, o.IsReturnTrx AS ISRETURNTRX, bp.SO_CreditLimit AS SO_CREDITLIMIT, bp.SO_CreditUsed AS SO_CREDITUSED, bpa.C_BP_BankAccount_ID AS C_BP_BANKACCOUNT_ID, h.M_InOut_ID AS M_INOUT_ID, h.PickDate AS PICKDATE, h.ShipDate AS SHIPDATE, h.DateReceived AS DATERECEIVED, hl.M_InOutLine_ID AS M_INOUTLINE_ID, hl.Line AS LINE FROM C_Order o INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID) INNER JOIN C_BP_BankAccount bpa ON (bp.C_BPartner_ID = bpa.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) LEFT OUTER JOIN M_InOut h ON (o.C_Order_ID = h.C_Order_ID) LEFT OUTER JOIN M_InOutLine hl ON (h.M_InOut_ID=hl.M_InOut_ID) WHERE o.IsSOTrx='Y' [18]
17:21:34.484 ViewCreate.doIt: Created view M_WorkOrder_Header_v [18]
17:21:34.531 ViewCreate.doIt: Created view M_WorkOrder_Component_v [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_SalesDetails_By_Product_V(AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ORDER_ID, DOCSTATUS, DOCACTION, C_DOCTYPE_ID, ISAPPROVED, ISCREDITAPPROVED, SALESREP_ID, BILL_BPARTNER_ID, BILL_LOCATION_ID, BILL_USER_ID, ISDROPSHIP, POREFERENCE, C_CURRENCY_ID, ISSOTRX, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, AD_USER_ID, C_BP_GROUP_ID, C_CAMPAIGN_ID, C_PROJECT_ID, C_ACTIVITY_ID, C_PROJECTPHASE_ID, C_PROJECTTASK_ID, C_ORDERLINE_ID, DATEORDERED, DATEPROMISED, M_PRODUCT_ID, M_WAREHOUSE_ID, M_ATTRIBUTESETINSTANCE_ID, PRODUCTATTRIBUTENAME, M_ATTRIBUTESET_ID, M_LOT_ID, GUARANTEEDATE, LOT, SERNO, M_PRODUCT_CATEGORY_ID, C_UOM_ID, QTYENTERED, QTYORDERED, QTYRESERVED, QTYDELIVERED, QTYINVOICED, PRICEACTUAL, PRICEENTERED, QTYTODELIVER, QTYTOINVOICE, NETAMTTOINVOICE, QTYLOSTSALES, AMTLOSTSALES, DISCOUNT, MARGIN, MARGINAMT, ISRETURNTRX, SO_CREDITLIMIT, SO_CREDITUSED, PRICELIMIT, PRICELIST, PRICESTD) AS SELECT l.AD_Client_ID AS AD_CLIENT_ID, l.AD_Org_ID AS AD_ORG_ID, l.IsActive AS ISACTIVE, l.Created AS CREATED, l.CreatedBy AS CREATEDBY, l.Updated AS UPDATED, l.UpdatedBy AS UPDATEDBY, o.C_Order_ID AS C_ORDER_ID, o.DocStatus AS DOCSTATUS, o.DocAction AS DOCACTION, o.C_DocType_ID AS C_DOCTYPE_ID, o.IsApproved AS ISAPPROVED, o.IsCreditApproved AS ISCREDITAPPROVED, o.SalesRep_ID AS SALESREP_ID, o.Bill_BPartner_ID AS BILL_BPARTNER_ID, o.Bill_Location_ID AS BILL_LOCATION_ID, o.Bill_User_ID AS BILL_USER_ID, o.IsDropShip AS ISDROPSHIP, o.POReference AS POREFERENCE, o.C_Currency_ID AS C_CURRENCY_ID, o.IsSOTrx AS ISSOTRX, l.C_BPartner_ID AS C_BPARTNER_ID, l.C_BPartner_Location_ID AS C_BPARTNER_LOCATION_ID, o.AD_User_ID AS AD_USER_ID, bp.C_BP_Group_ID AS C_BP_GROUP_ID, l.C_Campaign_ID AS C_CAMPAIGN_ID, l.C_Project_ID AS C_PROJECT_ID, l.C_Activity_ID AS C_ACTIVITY_ID, l.C_ProjectPhase_ID AS C_PROJECTPHASE_ID, l.C_ProjectTask_ID AS C_PROJECTTASK_ID, l.C_OrderLine_ID AS C_ORDERLINE_ID, l.DateOrdered AS DATEORDERED, l.DatePromised AS DATEPROMISED, l.M_Product_ID AS M_PRODUCT_ID, l.M_Warehouse_ID AS M_WAREHOUSE_ID, l.M_AttributeSetInstance_ID AS M_ATTRIBUTESETINSTANCE_ID, productAttribute(l.M_AttributeSetInstance_ID) AS PRODUCTATTRIBUTENAME, pasi.M_AttributeSet_ID AS M_ATTRIBUTESET_ID, pasi.M_Lot_ID AS M_LOT_ID, pasi.GuaranteeDate AS GUARANTEEDATE, pasi.Lot AS LOT, pasi.SerNo AS SERNO, p.M_Product_Category_ID AS M_PRODUCT_CATEGORY_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QTYENTERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QTYORDERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QTYRESERVED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QTYDELIVERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QTYINVOICED, l.PriceActual AS PRICEACTUAL, l.PriceEntered AS PRICEENTERED, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QTYTODELIVER, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QTYTOINVOICE, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NETAMTTOINVOICE, l.QtyLostSales AS QTYLOSTSALES, l.QtyLostSales*l.PriceActual AS AMTLOSTSALES, CASE WHEN l.PriceList=0 THEN 0 ELSE ROUND((l.PriceList-l.PriceActual)/l.PriceList*100,2) END AS DISCOUNT, CASE WHEN l.PriceLimit=0 THEN 0 ELSE ROUND((l.PriceActual-l.PriceLimit)/l.PriceLimit*100,2) END AS MARGIN, CASE WHEN l.PriceLimit=0 THEN 0 ELSE (CASE WHEN o.IsReturnTrx='Y' THEN (l.PriceActual-l.PriceLimit)*l.QtyDelivered*-1 ELSE (l.PriceActual-l.PriceLimit)*l.QtyDelivered END) END AS MARGINAMT, o.IsReturnTrx AS ISRETURNTRX, bp.SO_CreditLimit AS SO_CREDITLIMIT, bp.SO_CreditUsed AS SO_CREDITUSED, pp.PriceLimit AS PRICELIMIT, pp.PriceList AS PRICELIST, pp.PriceStd AS PRICESTD FROM C_Order o INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) INNER JOIN M_ProductPrice pp on (p.M_Product_ID = pp.M_Product_ID) WHERE o.IsSOTrx='Y' [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_SalesDetails_By_Product_V(AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ORDER_ID, DOCSTATUS, DOCACTION, C_DOCTYPE_ID, ISAPPROVED, ISCREDITAPPROVED, SALESREP_ID, BILL_BPARTNER_ID, BILL_LOCATION_ID, BILL_USER_ID, ISDROPSHIP, POREFERENCE, C_CURRENCY_ID, ISSOTRX, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, AD_USER_ID, C_BP_GROUP_ID, C_CAMPAIGN_ID, C_PROJECT_ID, C_ACTIVITY_ID, C_PROJECTPHASE_ID, C_PROJECTTASK_ID, C_ORDERLINE_ID, DATEORDERED, DATEPROMISED, M_PRODUCT_ID, M_WAREHOUSE_ID, M_ATTRIBUTESETINSTANCE_ID, PRODUCTATTRIBUTENAME, M_ATTRIBUTESET_ID, M_LOT_ID, GUARANTEEDATE, LOT, SERNO, M_PRODUCT_CATEGORY_ID, C_UOM_ID, QTYENTERED, QTYORDERED, QTYRESERVED, QTYDELIVERED, QTYINVOICED, PRICEACTUAL, PRICEENTERED, QTYTODELIVER, QTYTOINVOICE, NETAMTTOINVOICE, QTYLOSTSALES, AMTLOSTSALES, DISCOUNT, MARGIN, MARGINAMT, ISRETURNTRX, SO_CREDITLIMIT, SO_CREDITUSED, PRICELIMIT, PRICELIST, PRICESTD) AS SELECT l.AD_Client_ID AS AD_CLIENT_ID, l.AD_Org_ID AS AD_ORG_ID, l.IsActive AS ISACTIVE, l.Created AS CREATED, l.CreatedBy AS CREATEDBY, l.Updated AS UPDATED, l.UpdatedBy AS UPDATEDBY, o.C_Order_ID AS C_ORDER_ID, o.DocStatus AS DOCSTATUS, o.DocAction AS DOCACTION, o.C_DocType_ID AS C_DOCTYPE_ID, o.IsApproved AS ISAPPROVED, o.IsCreditApproved AS ISCREDITAPPROVED, o.SalesRep_ID AS SALESREP_ID, o.Bill_BPartner_ID AS BILL_BPARTNER_ID, o.Bill_Location_ID AS BILL_LOCATION_ID, o.Bill_User_ID AS BILL_USER_ID, o.IsDropShip AS ISDROPSHIP, o.POReference AS POREFERENCE, o.C_Currency_ID AS C_CURRENCY_ID, o.IsSOTrx AS ISSOTRX, l.C_BPartner_ID AS C_BPARTNER_ID, l.C_BPartner_Location_ID AS C_BPARTNER_LOCATION_ID, o.AD_User_ID AS AD_USER_ID, bp.C_BP_Group_ID AS C_BP_GROUP_ID, l.C_Campaign_ID AS C_CAMPAIGN_ID, l.C_Project_ID AS C_PROJECT_ID, l.C_Activity_ID AS C_ACTIVITY_ID, l.C_ProjectPhase_ID AS C_PROJECTPHASE_ID, l.C_ProjectTask_ID AS C_PROJECTTASK_ID, l.C_OrderLine_ID AS C_ORDERLINE_ID, l.DateOrdered AS DATEORDERED, l.DatePromised AS DATEPROMISED, l.M_Product_ID AS M_PRODUCT_ID, l.M_Warehouse_ID AS M_WAREHOUSE_ID, l.M_AttributeSetInstance_ID AS M_ATTRIBUTESETINSTANCE_ID, productAttribute(l.M_AttributeSetInstance_ID) AS PRODUCTATTRIBUTENAME, pasi.M_AttributeSet_ID AS M_ATTRIBUTESET_ID, pasi.M_Lot_ID AS M_LOT_ID, pasi.GuaranteeDate AS GUARANTEEDATE, pasi.Lot AS LOT, pasi.SerNo AS SERNO, p.M_Product_Category_ID AS M_PRODUCT_CATEGORY_ID, l.C_UOM_ID AS C_UOM_ID, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyEntered*-1 ELSE l.QtyEntered END AS QTYENTERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyOrdered*-1 ELSE l.QtyOrdered END AS QTYORDERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyReserved*-1 ELSE l.QtyReserved END AS QTYRESERVED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyDelivered*-1 ELSE l.QtyDelivered END AS QTYDELIVERED, CASE WHEN o.IsReturnTrx='Y' THEN l.QtyInvoiced*-1 ELSE l.QtyInvoiced END AS QTYINVOICED, l.PriceActual AS PRICEACTUAL, l.PriceEntered AS PRICEENTERED, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyDelivered)*-1 ELSE l.QtyOrdered-l.QtyDelivered END AS QTYTODELIVER, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*-1 ELSE l.QtyOrdered-l.QtyInvoiced END AS QTYTOINVOICE, CASE WHEN o.IsReturnTrx='Y' THEN (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual*-1 ELSE (l.QtyOrdered-l.QtyInvoiced)*l.PriceActual END AS NETAMTTOINVOICE, l.QtyLostSales AS QTYLOSTSALES, l.QtyLostSales*l.PriceActual AS AMTLOSTSALES, CASE WHEN l.PriceList=0 THEN 0 ELSE ROUND((l.PriceList-l.PriceActual)/l.PriceList*100,2) END AS DISCOUNT, CASE WHEN l.PriceLimit=0 THEN 0 ELSE ROUND((l.PriceActual-l.PriceLimit)/l.PriceLimit*100,2) END AS MARGIN, CASE WHEN l.PriceLimit=0 THEN 0 ELSE (CASE WHEN o.IsReturnTrx='Y' THEN (l.PriceActual-l.PriceLimit)*l.QtyDelivered*-1 ELSE (l.PriceActual-l.PriceLimit)*l.QtyDelivered END) END AS MARGINAMT, o.IsReturnTrx AS ISRETURNTRX, bp.SO_CreditLimit AS SO_CREDITLIMIT, bp.SO_CreditUsed AS SO_CREDITUSED, pp.PriceLimit AS PRICELIMIT, pp.PriceList AS PRICELIST, pp.PriceStd AS PRICESTD FROM C_Order o INNER JOIN C_OrderLine l ON (o.C_Order_ID=l.C_Order_ID) LEFT OUTER JOIN M_AttributeSetInstance pasi ON (l.M_AttributeSetInstance_ID=pasi.M_AttributeSetInstance_ID) INNER JOIN C_BPartner bp ON (bp.C_BPartner_ID = l.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (l.C_BPartner_Location_ID = bpl.C_BPartner_Location_ID) INNER JOIN M_Product p ON (p.M_Product_ID = l.M_Product_ID) INNER JOIN M_ProductPrice pp on (p.M_Product_ID = pp.M_Product_ID) WHERE o.IsSOTrx='Y' [18]
17:21:35.265 ViewCreate.doIt: Created view M_TaskListLine_v [18]
17:21:35.296 ViewCreate.doIt: Created view RV_OrderMonitor [18]
17:21:35.328 ViewCreate.doIt: Created view RV_LocatorVisits [18]
17:21:35.343 ViewCreate.doIt: Created view C_CustomersAndPartners_V [18]
17:21:35.421 ViewCreate.doIt: Created view M_TaskListAddressLabel_V [18]
17:21:35.437 ViewCreate.doIt: Created view AD_Org_all_v [18]
17:21:35.468 ViewCreate.doIt: Created view CP_FK [18]
17:21:35.484 ViewCreate.doIt: Created view RV_Lead_Week [18]
17:21:35.515 ViewCreate.doIt: Created view RV_Lead_Month [18]
17:21:35.546 ViewCreate.doIt: Created view RV_Project_Details [18]
17:21:35.625 ViewCreate.doIt: Created view AD_Field_v [18]
17:21:35.687 ViewCreate.doIt: Created view AD_Field_vt [18]
17:21:35.734 ViewCreate.doIt: Created view AD_Tab_v [18]
17:21:35.781 ViewCreate.doIt: Created view AD_Tab_vt [18]
17:21:35.796 ViewCreate.doIt: Created view AD_User_Roles_v [18]
17:21:35.828 ViewCreate.doIt: Created view AD_Org_v [18]
17:21:35.859 ViewCreate.doIt: Created view AD_Window_v [18]
17:21:35.890 ViewCreate.doIt: Created view AD_Window_vt [18]
17:21:35.984 ViewCreate.doIt: Created view C_Invoice_Header_vt [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_Invoice_LineTax_vt(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Invoice_ID, C_InvoiceLine_ID, C_Tax_ID, TaxAmt, LineTotalAmt, TaxIndicator, Line, M_Product_ID, QtyInvoiced, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN il.QtyInvoiced<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyInvoiced END AS QtyInvoiced, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyEntered END AS QtyEntered, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(COALESCE(ct.Name,c.Name),COALESCE(pt.Name,p.Name)|| COALESCE(productAttribute(il.M_AttributeSetInstance_ID),N''),il.Description) AS Name, CASE WHEN COALESCE(ct.Name,c.Name,pt.Name,p.Name) IS NOT NULL THEN il.Description END AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 THEN il.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 AND il.QtyEntered<>0 THEN il.PriceList*il.QtyInvoiced/il.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList>il.PriceActual AND il.PriceList<>0 THEN (il.PriceList-il.PriceActual)/il.PriceList*100 END AS Discount, CASE WHEN il.PriceActual<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceActual END AS PriceActual, CASE WHEN il.PriceEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceEntered END AS PriceEntered, CASE WHEN il.LineNetAmt<>0 OR il.M_Product_ID IS NOT NULL THEN il.LineNetAmt END AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_InvoiceLine il INNER JOIN C_UOM_Trl uom ON (il.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_ID) LEFT OUTER JOIN C_Tax_Trl t ON (il.C_Tax_ID=t.C_Tax_ID AND uom.AD_Language=t.AD_Language) LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN C_Charge c ON (il.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_BPartner_Product pp ON (il.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) LEFT OUTER JOIN M_Product_Trl pt ON (il.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN C_Charge_Trl ct ON (il.C_Charge_ID=ct.C_Charge_ID AND uom.AD_Language=ct.AD_Language) LEFT OUTER JOIN S_ResourceAssignment ra ON (il.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, il.QtyInvoiced*b.BOMQty AS QtyInvoiced, il.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, COALESCE(pt.Name,p.Name) AS Name, b.Description AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_InvoiceLine il ON (bom.M_Product_ID=il.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=il.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM_Trl uom ON (p.C_UOM_ID=uom.C_UOM_ID) INNER JOIN M_Product_Trl pt ON (b.M_ProductBOM_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN C_Tax t ON (il.C_Tax_ID=t.C_Tax_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) WHERE b.IsActive = 'Y' UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, l.AD_Language AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, il.Line AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, il.Description AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, 0 AS C_ProjectTask_ID FROM C_InvoiceLine il, AD_Language l WHERE il.C_UOM_ID IS NULL AND l.IsBaseLanguage='N' AND l.IsSystemLanguage='Y' UNION SELECT i.AD_Client_ID AS AD_Client_ID, i.AD_Org_ID AS AD_Org_ID, i.IsActive AS IsActive, i.Created AS Created, i.CreatedBy AS CreatedBy, i.Updated AS Updated, i.UpdatedBy AS UpdatedBy, AD_Language AS AD_Language, i.C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, 999998 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, 0 AS C_ProjectTask_ID FROM C_Invoice i, AD_Language l WHERE l.IsBaseLanguage='N' AND l.IsSystemLanguage='Y' UNION SELECT it.AD_Client_ID AS AD_Client_ID, it.AD_Org_ID AS AD_Org_ID, it.IsActive AS IsActive, it.Created AS Created, it.CreatedBy AS CreatedBy, it.Updated AS Updated, it.UpdatedBy AS UpdatedBy, t.AD_Language AS AD_Language, it.C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, it.C_Tax_ID AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, 999999 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceActual, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceEntered, CASE WHEN it.IsTaxIncluded='Y' THEN 0 ELSE it.TaxAmt END AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, 0 AS C_ProjectTask_ID FROM C_InvoiceTax it INNER JOIN C_Tax_Trl t ON (it.C_Tax_ID=t.C_Tax_ID) [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_Invoice_LineTax_vt(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Invoice_ID, C_InvoiceLine_ID, C_Tax_ID, TaxAmt, LineTotalAmt, TaxIndicator, Line, M_Product_ID, QtyInvoiced, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN il.QtyInvoiced<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyInvoiced END AS QtyInvoiced, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.QtyEntered END AS QtyEntered, CASE WHEN il.QtyEntered<>0 OR il.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(COALESCE(ct.Name,c.Name),COALESCE(pt.Name,p.Name)|| COALESCE(productAttribute(il.M_AttributeSetInstance_ID),N''),il.Description) AS Name, CASE WHEN COALESCE(ct.Name,c.Name,pt.Name,p.Name) IS NOT NULL THEN il.Description END AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 THEN il.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList<>0 AND il.QtyEntered<>0 THEN il.PriceList*il.QtyInvoiced/il.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList>il.PriceActual AND il.PriceList<>0 THEN (il.PriceList-il.PriceActual)/il.PriceList*100 END AS Discount, CASE WHEN il.PriceActual<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceActual END AS PriceActual, CASE WHEN il.PriceEntered<>0 OR il.M_Product_ID IS NOT NULL THEN il.PriceEntered END AS PriceEntered, CASE WHEN il.LineNetAmt<>0 OR il.M_Product_ID IS NOT NULL THEN il.LineNetAmt END AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_InvoiceLine il INNER JOIN C_UOM_Trl uom ON (il.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_ID) LEFT OUTER JOIN C_Tax_Trl t ON (il.C_Tax_ID=t.C_Tax_ID AND uom.AD_Language=t.AD_Language) LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN C_Charge c ON (il.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_BPartner_Product pp ON (il.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) LEFT OUTER JOIN M_Product_Trl pt ON (il.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN C_Charge_Trl ct ON (il.C_Charge_ID=ct.C_Charge_ID AND uom.AD_Language=ct.AD_Language) LEFT OUTER JOIN S_ResourceAssignment ra ON (il.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, il.C_Tax_ID AS C_Tax_ID, il.TaxAmt AS TaxAmt, il.LineTotalAmt AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, il.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, il.QtyInvoiced*b.BOMQty AS QtyInvoiced, il.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, COALESCE(pt.Name,p.Name) AS Name, b.Description AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, il.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, il.C_Campaign_ID AS C_Campaign_ID, il.C_Project_ID AS C_Project_ID, il.C_Activity_ID AS C_Activity_ID, il.C_ProjectPhase_ID AS C_ProjectPhase_ID, il.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_InvoiceLine il ON (bom.M_Product_ID=il.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=il.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM_Trl uom ON (p.C_UOM_ID=uom.C_UOM_ID) INNER JOIN M_Product_Trl pt ON (b.M_ProductBOM_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN C_Tax t ON (il.C_Tax_ID=t.C_Tax_ID) LEFT OUTER JOIN M_AttributeSetInstance asi ON (il.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) WHERE b.IsActive = 'Y' UNION SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.IsActive AS IsActive, il.Created AS Created, il.CreatedBy AS CreatedBy, il.Updated AS Updated, il.UpdatedBy AS UpdatedBy, l.AD_Language AS AD_Language, il.C_Invoice_ID AS C_Invoice_ID, il.C_InvoiceLine_ID AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, il.Line AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, il.Description AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, 0 AS C_ProjectTask_ID FROM C_InvoiceLine il, AD_Language l WHERE il.C_UOM_ID IS NULL AND l.IsBaseLanguage='N' AND l.IsSystemLanguage='Y' UNION SELECT i.AD_Client_ID AS AD_Client_ID, i.AD_Org_ID AS AD_Org_ID, i.IsActive AS IsActive, i.Created AS Created, i.CreatedBy AS CreatedBy, i.Updated AS Updated, i.UpdatedBy AS UpdatedBy, AD_Language AS AD_Language, i.C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, NULLIF(1,1) AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, NULL AS TaxIndicator, 999998 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, 0 AS C_ProjectTask_ID FROM C_Invoice i, AD_Language l WHERE l.IsBaseLanguage='N' AND l.IsSystemLanguage='Y' UNION SELECT it.AD_Client_ID AS AD_Client_ID, it.AD_Org_ID AS AD_Org_ID, it.IsActive AS IsActive, it.Created AS Created, it.CreatedBy AS CreatedBy, it.Updated AS Updated, it.UpdatedBy AS UpdatedBy, t.AD_Language AS AD_Language, it.C_Invoice_ID AS C_Invoice_ID, NULLIF(1,1) AS C_InvoiceLine_ID, it.C_Tax_ID AS C_Tax_ID, NULLIF(1,1) AS TaxAmt, NULLIF(1,1) AS LineTotalAmt, t.TaxIndicator AS TaxIndicator, 999999 AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyInvoiced, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceActual, CASE WHEN it.IsTaxIncluded='Y' THEN it.TaxAmt ELSE it.TaxBaseAmt END AS PriceEntered, CASE WHEN it.IsTaxIncluded='Y' THEN 0 ELSE it.TaxAmt END AS LineNetAmt, NULLIF(1,1) AS M_AttributeSetInstance_ID, NULLIF(1,1) AS M_AttributeSet_ID, NULL AS SerNo, NULL AS Lot, NULLIF(1,1) AS M_Lot_ID, NULL AS GuaranteeDate, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, 0 AS C_ProjectTask_ID FROM C_InvoiceTax it INNER JOIN C_Tax_Trl t ON (it.C_Tax_ID=t.C_Tax_ID) [18]
17:21:37.390 ViewCreate.doIt: Created view C_Order_Header_vt [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_Order_LineTax_vt(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Order_ID, C_OrderLine_ID, C_Tax_ID, TaxIndicator, C_BPartner_ID, C_BPartner_Location_ID, BPName, C_Location_ID, Line, M_Product_ID, QtyOrdered, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, ol.C_BPartner_ID AS C_BPartner_ID, ol.C_BPartner_Location_ID AS C_BPartner_Location_ID, bp.Name AS BPName, bpl.C_Location_ID AS C_Location_ID, ol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN ol.QtyOrdered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered END AS QtyOrdered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyEntered END AS QtyEntered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(COALESCE(ct.Name,c.Name),COALESCE(pt.Name,p.Name)|| COALESCE(productAttribute(ol.M_AttributeSetInstance_ID),N''),ol.Description) AS Name, CASE WHEN COALESCE(ct.Name,c.Name,pt.Name,p.Name) IS NOT NULL THEN ol.Description END AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 THEN ol.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 AND ol.QtyEntered<>0 THEN ol.PriceList*ol.QtyOrdered/ol.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList>ol.PriceActual AND ol.PriceList<>0 THEN (ol.PriceList-ol.PriceActual)/ol.PriceList*100 END AS Discount, CASE WHEN ol.PriceActual<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceActual END AS PriceActual, CASE WHEN ol.PriceEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceEntered END AS PriceEntered, CASE WHEN ol.LineNetAmt<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.LineNetAmt END AS LineNetAmt, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_OrderLine ol INNER JOIN C_UOM_Trl uom ON (ol.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Order i ON (ol.C_Order_ID=i.C_Order_ID) LEFT OUTER JOIN M_Product p ON (ol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_Product_Trl pt ON (ol.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN S_ResourceAssignment ra ON (ol.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN C_Charge c ON (ol.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_Charge_Trl ct ON (ol.C_Charge_ID=ct.C_Charge_ID AND uom.AD_Language=ct.AD_Language) LEFT OUTER JOIN C_BPartner_Product pp ON (ol.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) INNER JOIN C_BPartner bp ON (ol.C_BPartner_ID=bp.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (ol.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID) LEFT OUTER JOIN C_Tax_Trl t ON (ol.C_Tax_ID=t.C_Tax_ID AND uom.AD_Language=t.AD_Language) UNION SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, ol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, ol.QtyOrdered*b.BOMQty AS QtyOrdered, ol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, COALESCE(pt.Name,p.Name) AS Name, b.Description AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_OrderLine ol ON (bom.M_Product_ID=ol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=ol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM_Trl uom ON (p.C_UOM_ID=uom.C_UOM_ID) INNER JOIN M_Product_Trl pt ON (b.M_ProductBOM_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) WHERE b.IsActive = 'Y' UNION SELECT o.AD_Client_ID AS AD_Client_ID, o.AD_Org_ID AS AD_Org_ID, o.IsActive AS IsActive, o.Created AS Created, o.CreatedBy AS CreatedBy, o.Updated AS Updated, o.UpdatedBy AS UpdatedBy, l.AD_Language AS AD_Language, o.C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, NULLIF(1,1) AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_Order o, AD_Language l WHERE l.IsBaseLanguage='N' AND l.IsSystemLanguage='Y' UNION SELECT ot.AD_Client_ID AS AD_Client_ID, ot.AD_Org_ID AS AD_Org_ID, ot.IsActive AS IsActive, ot.Created AS Created, ot.CreatedBy AS CreatedBy, ot.Updated AS Updated, ot.UpdatedBy AS UpdatedBy, t.AD_Language AS AD_Language, ot.C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, ot.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceActual, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceEntered, CASE WHEN ot.IsTaxIncluded='Y' THEN 0 ELSE ot.TaxAmt END AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_OrderTax ot INNER JOIN C_Tax_Trl t ON (ot.C_Tax_ID=t.C_Tax_ID) [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_Order_LineTax_vt(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, C_Order_ID, C_OrderLine_ID, C_Tax_ID, TaxIndicator, C_BPartner_ID, C_BPartner_Location_ID, BPName, C_Location_ID, Line, M_Product_ID, QtyOrdered, QtyEntered, UOMSymbol, Name, Description, DocumentNote, UPC, SKU, ProductValue, ResourceDescription, PriceList, PriceEnteredList, Discount, PriceActual, PriceEntered, LineNetAmt, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, ol.C_BPartner_ID AS C_BPartner_ID, ol.C_BPartner_Location_ID AS C_BPartner_Location_ID, bp.Name AS BPName, bpl.C_Location_ID AS C_Location_ID, ol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN ol.QtyOrdered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered END AS QtyOrdered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.QtyEntered END AS QtyEntered, CASE WHEN ol.QtyEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, COALESCE(COALESCE(ct.Name,c.Name),COALESCE(pt.Name,p.Name)|| COALESCE(productAttribute(ol.M_AttributeSetInstance_ID),N''),ol.Description) AS Name, CASE WHEN COALESCE(ct.Name,c.Name,pt.Name,p.Name) IS NOT NULL THEN ol.Description END AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, COALESCE(pp.VendorProductNo,p.Value) AS ProductValue, ra.Description AS ResourceDescription, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 THEN ol.PriceList END AS PriceList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList<>0 AND ol.QtyEntered<>0 THEN ol.PriceList*ol.QtyOrdered/ol.QtyEntered END AS PriceEnteredList, CASE WHEN i.IsDiscountPrinted='Y' AND ol.PriceList>ol.PriceActual AND ol.PriceList<>0 THEN (ol.PriceList-ol.PriceActual)/ol.PriceList*100 END AS Discount, CASE WHEN ol.PriceActual<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceActual END AS PriceActual, CASE WHEN ol.PriceEntered<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.PriceEntered END AS PriceEntered, CASE WHEN ol.LineNetAmt<>0 OR ol.M_Product_ID IS NOT NULL THEN ol.LineNetAmt END AS LineNetAmt, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM C_OrderLine ol INNER JOIN C_UOM_Trl uom ON (ol.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_Order i ON (ol.C_Order_ID=i.C_Order_ID) LEFT OUTER JOIN M_Product p ON (ol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_Product_Trl pt ON (ol.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN S_ResourceAssignment ra ON (ol.S_ResourceAssignment_ID=ra.S_ResourceAssignment_ID) LEFT OUTER JOIN C_Charge c ON (ol.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_Charge_Trl ct ON (ol.C_Charge_ID=ct.C_Charge_ID AND uom.AD_Language=ct.AD_Language) LEFT OUTER JOIN C_BPartner_Product pp ON (ol.M_Product_ID=pp.M_Product_ID AND i.C_BPartner_ID=pp.C_BPartner_ID) INNER JOIN C_BPartner bp ON (ol.C_BPartner_ID=bp.C_BPartner_ID) INNER JOIN C_BPartner_Location bpl ON (ol.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID) LEFT OUTER JOIN C_Tax_Trl t ON (ol.C_Tax_ID=t.C_Tax_ID AND uom.AD_Language=t.AD_Language) UNION SELECT ol.AD_Client_ID AS AD_Client_ID, ol.AD_Org_ID AS AD_Org_ID, ol.IsActive AS IsActive, ol.Created AS Created, ol.CreatedBy AS CreatedBy, ol.Updated AS Updated, ol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, ol.C_Order_ID AS C_Order_ID, ol.C_OrderLine_ID AS C_OrderLine_ID, ol.C_Tax_ID AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, ol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, ol.QtyOrdered*b.BOMQty AS QtyOrdered, ol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, COALESCE(pt.Name,p.Name) AS Name, b.Description AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, ol.C_Campaign_ID AS C_Campaign_ID, ol.C_Project_ID AS C_Project_ID, ol.C_Activity_ID AS C_Activity_ID, ol.C_ProjectPhase_ID AS C_ProjectPhase_ID, ol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN C_OrderLine ol ON (bom.M_Product_ID=ol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=ol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsInvoicePrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM_Trl uom ON (p.C_UOM_ID=uom.C_UOM_ID) INNER JOIN M_Product_Trl pt ON (b.M_ProductBOM_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) WHERE b.IsActive = 'Y' UNION SELECT o.AD_Client_ID AS AD_Client_ID, o.AD_Org_ID AS AD_Org_ID, o.IsActive AS IsActive, o.Created AS Created, o.CreatedBy AS CreatedBy, o.Updated AS Updated, o.UpdatedBy AS UpdatedBy, l.AD_Language AS AD_Language, o.C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, NULLIF(1,1) AS C_Tax_ID, NULL AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, NULL AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, NULLIF(1,1) AS PriceActual, NULLIF(1,1) AS PriceEntered, NULLIF(1,1) AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_Order o, AD_Language l WHERE l.IsBaseLanguage='N' AND l.IsSystemLanguage='Y' UNION SELECT ot.AD_Client_ID AS AD_Client_ID, ot.AD_Org_ID AS AD_Org_ID, ot.IsActive AS IsActive, ot.Created AS Created, ot.CreatedBy AS CreatedBy, ot.Updated AS Updated, ot.UpdatedBy AS UpdatedBy, t.AD_Language AS AD_Language, ot.C_Order_ID AS C_Order_ID, NULLIF(1,1) AS C_OrderLine_ID, ot.C_Tax_ID AS C_Tax_ID, t.TaxIndicator AS TaxIndicator, NULLIF(1,1) AS C_BPartner_ID, NULLIF(1,1) AS C_BPartner_Location_ID, NULL AS BPName, NULLIF(1,1) AS C_Location_ID, NULLIF(1,1) AS Line, NULLIF(1,1) AS M_Product_ID, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyEntered, NULL AS UOMSymbol, t.Name AS Name, NULL AS Description, NULL AS DocumentNote, NULL AS UPC, NULL AS SKU, NULL AS ProductValue, NULL AS ResourceDescription, NULLIF(1,1) AS PriceList, NULLIF(1,1) AS PriceEnteredList, NULLIF(1,1) AS Discount, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceActual, CASE WHEN ot.IsTaxIncluded='Y' THEN ot.TaxAmt ELSE ot.TaxBaseAmt END AS PriceEntered, CASE WHEN ot.IsTaxIncluded='Y' THEN 0 ELSE ot.TaxAmt END AS LineNetAmt, NULL AS ProductDescription, NULL AS ImageURL, NULLIF(1,1) AS C_Campaign_ID, NULLIF(1,1) AS C_Project_ID, NULLIF(1,1) AS C_Activity_ID, NULLIF(1,1) AS C_ProjectPhase_ID, NULLIF(1,1) AS C_ProjectTask_ID FROM C_OrderTax ot INNER JOIN C_Tax_Trl t ON (ot.C_Tax_ID=t.C_Tax_ID) [18]
17:21:38.468 ViewCreate.doIt: Created view C_PaySelection_Check_vt [18]
17:21:38.484 ViewCreate.doIt: Created view C_PaySelection_Remittance_vt [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW M_InOut_Line_vt(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, M_InOut_ID, M_InOutLine_ID, Line, M_Product_ID, MovementQty, QtyEntered, UOMSymbol, QtyOrdered, QtyDelivered, QtyBackOrdered, Name, Description, DocumentNote, UPC, SKU, ProductValue, M_Locator_ID, M_Warehouse_ID, X, Y, Z, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.MovementQty END AS MovementQty, CASE WHEN iol.QtyEntered<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.QtyEntered END AS QtyEntered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, ol.QtyOrdered AS QtyOrdered, ol.QtyDelivered AS QtyDelivered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered-ol.QtyDelivered END AS QtyBackOrdered, COALESCE(COALESCE(pt.Name,p.Name)|| COALESCE(productAttribute(iol.M_AttributeSetInstance_ID),N''),COALESCE(ct.Name,c.Name),iol.Description) AS Name, CASE WHEN COALESCE(pt.Name,p.Name,ct.Name,c.Name) IS NOT NULL THEN iol.Description END AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_InOutLine iol INNER JOIN C_UOM_Trl uom ON (iol.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN M_Product p ON (iol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_Product_Trl pt ON (iol.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) LEFT OUTER JOIN C_OrderLine ol ON (iol.C_OrderLine_ID=ol.C_OrderLine_ID) LEFT OUTER JOIN C_Charge c ON (iol.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_Charge_Trl ct ON (iol.C_Charge_ID=ct.C_Charge_ID AND uom.AD_Language=ct.AD_Language) UNION SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, iol.MovementQty*b.BOMQty AS MovementQty, iol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyDelivered, NULLIF(1,1) AS QtyBackOrdered, COALESCE (pt.Name,p.Name) AS Name, b.Description AS Description, COALESCE (pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN M_InOutLine iol ON (bom.M_Product_ID=iol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=iol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsPickListPrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM_Trl uom ON (p.C_UOM_ID=uom.C_UOM_ID) INNER JOIN M_Product_Trl pt ON (iol.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) WHERE b.IsActive = 'Y' [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW M_InOut_Line_vt(AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, M_InOut_ID, M_InOutLine_ID, Line, M_Product_ID, MovementQty, QtyEntered, UOMSymbol, QtyOrdered, QtyDelivered, QtyBackOrdered, Name, Description, DocumentNote, UPC, SKU, ProductValue, M_Locator_ID, M_Warehouse_ID, X, Y, Z, M_AttributeSetInstance_ID, M_AttributeSet_ID, SerNo, Lot, M_Lot_ID, GuaranteeDate, ProductDescription, ImageURL, C_Campaign_ID, C_Project_ID, C_Activity_ID, C_ProjectPhase_ID, C_ProjectTask_ID) AS SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line AS Line, p.M_Product_ID AS M_Product_ID, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.MovementQty END AS MovementQty, CASE WHEN iol.QtyEntered<>0 OR iol.M_Product_ID IS NOT NULL THEN iol.QtyEntered END AS QtyEntered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN uom.UOMSymbol END AS UOMSymbol, ol.QtyOrdered AS QtyOrdered, ol.QtyDelivered AS QtyDelivered, CASE WHEN iol.MovementQty<>0 OR iol.M_Product_ID IS NOT NULL THEN ol.QtyOrdered-ol.QtyDelivered END AS QtyBackOrdered, COALESCE(COALESCE(pt.Name,p.Name)|| COALESCE(productAttribute(iol.M_AttributeSetInstance_ID),N''),COALESCE(ct.Name,c.Name),iol.Description) AS Name, CASE WHEN COALESCE(pt.Name,p.Name,ct.Name,c.Name) IS NOT NULL THEN iol.Description END AS Description, COALESCE(pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_InOutLine iol INNER JOIN C_UOM_Trl uom ON (iol.C_UOM_ID=uom.C_UOM_ID) LEFT OUTER JOIN M_Product p ON (iol.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_Product_Trl pt ON (iol.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) LEFT OUTER JOIN C_OrderLine ol ON (iol.C_OrderLine_ID=ol.C_OrderLine_ID) LEFT OUTER JOIN C_Charge c ON (iol.C_Charge_ID=c.C_Charge_ID) LEFT OUTER JOIN C_Charge_Trl ct ON (iol.C_Charge_ID=ct.C_Charge_ID AND uom.AD_Language=ct.AD_Language) UNION SELECT iol.AD_Client_ID AS AD_Client_ID, iol.AD_Org_ID AS AD_Org_ID, iol.IsActive AS IsActive, iol.Created AS Created, iol.CreatedBy AS CreatedBy, iol.Updated AS Updated, iol.UpdatedBy AS UpdatedBy, uom.AD_Language AS AD_Language, iol.M_InOut_ID AS M_InOut_ID, iol.M_InOutLine_ID AS M_InOutLine_ID, iol.Line+(b.Line/100) AS Line, p.M_Product_ID AS M_Product_ID, iol.MovementQty*b.BOMQty AS MovementQty, iol.QtyEntered*b.BOMQty AS QtyEntered, uom.UOMSymbol AS UOMSymbol, NULLIF(1,1) AS QtyOrdered, NULLIF(1,1) AS QtyDelivered, NULLIF(1,1) AS QtyBackOrdered, COALESCE (pt.Name,p.Name) AS Name, b.Description AS Description, COALESCE (pt.DocumentNote,p.DocumentNote) AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, iol.M_Locator_ID AS M_Locator_ID, l.M_Warehouse_ID AS M_Warehouse_ID, l.X AS X, l.Y AS Y, l.Z AS Z, iol.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, asi.M_AttributeSet_ID AS M_AttributeSet_ID, asi.SerNo AS SerNo, asi.Lot AS Lot, asi.M_Lot_ID AS M_Lot_ID, asi.GuaranteeDate AS GuaranteeDate, pt.Description AS ProductDescription, p.ImageURL AS ImageURL, iol.C_Campaign_ID AS C_Campaign_ID, iol.C_Project_ID AS C_Project_ID, iol.C_Activity_ID AS C_Activity_ID, iol.C_ProjectPhase_ID AS C_ProjectPhase_ID, iol.C_ProjectTask_ID AS C_ProjectTask_ID FROM M_BOMProduct b INNER JOIN M_BOM bom ON (bom.M_BOM_ID = b.M_BOM_ID and bom.BOMUse = 'A' and bom.BOMType='A' and bom.IsActive='Y') INNER JOIN M_InOutLine iol ON (bom.M_Product_ID=iol.M_Product_ID) INNER JOIN M_Product bp ON (bp.M_Product_ID=iol.M_Product_ID AND bp.IsBOM='Y' AND bp.IsVerified='Y' AND bp.IsPickListPrintDetails='Y') INNER JOIN M_Product p ON (b.M_ProductBOM_ID=p.M_Product_ID) INNER JOIN C_UOM_Trl uom ON (p.C_UOM_ID=uom.C_UOM_ID) INNER JOIN M_Product_Trl pt ON (iol.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language) LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID) WHERE b.IsActive = 'Y' [18]
17:21:39.281 ViewCreate.doIt: Created view C_Project_Header_vt [18]
17:21:39.312 ViewCreate.doIt: Created view C_Project_Details_vt [18]
17:21:39.343 ViewCreate.doIt: Created view C_RfQResponse_vt [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW C_RfQResponseLine_vt(C_RfQResponse_ID, C_RfQResponseLine_ID, C_RfQLine_ID, C_RfQResponseLineQty_ID, C_RfQLineQty_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, Line, M_Product_ID, M_AttributeSetInstance_ID, Name, Description, DocumentNote, UPC, SKU, ProductValue, Help, DateWorkStart, DeliveryDays, C_UOM_ID, UOMSymbol, Qty, Price, Discount) AS SELECT rrl.C_RfQResponse_ID AS C_RfQResponse_ID, rrl.C_RfQResponseLine_ID AS C_RfQResponseLine_ID, rrl.C_RfQLine_ID AS C_RfQLine_ID, rq.C_RfQResponseLineQty_ID AS C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID AS C_RfQLineQty_ID, rrl.AD_Client_ID AS AD_Client_ID, rrl.AD_Org_ID AS AD_Org_ID, rrl.IsActive AS IsActive, rrl.Created AS Created, rrl.CreatedBy AS CreatedBy, rrl.Updated AS Updated, rrl.UpdatedBy AS UpdatedBy, l.AD_Language AS AD_Language, rl.Line AS Line, rl.M_Product_ID AS M_Product_ID, rl.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, COALESCE(p.Name|| COALESCE(productAttribute(rl.M_AttributeSetInstance_ID),N''),rl.Description) AS Name, CASE WHEN p.Name IS NOT NULL THEN rl.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, rl.Help AS Help, rl.DateWorkStart AS DateWorkStart, rl.DeliveryDays AS DeliveryDays, q.C_UOM_ID AS C_UOM_ID, uom.UOMSymbol AS UOMSymbol, q.Qty AS Qty, rq.Price AS Price, rq.Discount AS Discount FROM C_RfQResponseLineQty rq INNER JOIN C_RfQLineQty q ON (rq.C_RfQLineQty_ID=q.C_RfQLineQty_ID) INNER JOIN C_UOM uom ON (q.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_RfQResponseLine rrl ON (rq.C_RfQResponseLine_ID=rrl.C_RfQResponseLine_ID) INNER JOIN C_RfQLine rl ON (rrl.C_RfQLine_ID=rl.C_RfQLine_ID) LEFT OUTER JOIN M_Product p ON (rl.M_Product_ID=p.M_Product_ID) INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y') WHERE rq.IsActive='Y' AND q.IsActive='Y' AND rrl.IsActive='Y' AND rl.IsActive='Y' [null] [18]
java.sql.SQLException: ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
; State=65000; ErrorCode=6575
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-06575: 程序包或函数 PRODUCTATTRIBUTE 处于无效状态
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW C_RfQResponseLine_vt(C_RfQResponse_ID, C_RfQResponseLine_ID, C_RfQLine_ID, C_RfQResponseLineQty_ID, C_RfQLineQty_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Language, Line, M_Product_ID, M_AttributeSetInstance_ID, Name, Description, DocumentNote, UPC, SKU, ProductValue, Help, DateWorkStart, DeliveryDays, C_UOM_ID, UOMSymbol, Qty, Price, Discount) AS SELECT rrl.C_RfQResponse_ID AS C_RfQResponse_ID, rrl.C_RfQResponseLine_ID AS C_RfQResponseLine_ID, rrl.C_RfQLine_ID AS C_RfQLine_ID, rq.C_RfQResponseLineQty_ID AS C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID AS C_RfQLineQty_ID, rrl.AD_Client_ID AS AD_Client_ID, rrl.AD_Org_ID AS AD_Org_ID, rrl.IsActive AS IsActive, rrl.Created AS Created, rrl.CreatedBy AS CreatedBy, rrl.Updated AS Updated, rrl.UpdatedBy AS UpdatedBy, l.AD_Language AS AD_Language, rl.Line AS Line, rl.M_Product_ID AS M_Product_ID, rl.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID, COALESCE(p.Name|| COALESCE(productAttribute(rl.M_AttributeSetInstance_ID),N''),rl.Description) AS Name, CASE WHEN p.Name IS NOT NULL THEN rl.Description END AS Description, p.DocumentNote AS DocumentNote, p.UPC AS UPC, p.SKU AS SKU, p.Value AS ProductValue, rl.Help AS Help, rl.DateWorkStart AS DateWorkStart, rl.DeliveryDays AS DeliveryDays, q.C_UOM_ID AS C_UOM_ID, uom.UOMSymbol AS UOMSymbol, q.Qty AS Qty, rq.Price AS Price, rq.Discount AS Discount FROM C_RfQResponseLineQty rq INNER JOIN C_RfQLineQty q ON (rq.C_RfQLineQty_ID=q.C_RfQLineQty_ID) INNER JOIN C_UOM uom ON (q.C_UOM_ID=uom.C_UOM_ID) INNER JOIN C_RfQResponseLine rrl ON (rq.C_RfQResponseLine_ID=rrl.C_RfQResponseLine_ID) INNER JOIN C_RfQLine rl ON (rrl.C_RfQLine_ID=rl.C_RfQLine_ID) LEFT OUTER JOIN M_Product p ON (rl.M_Product_ID=p.M_Product_ID) INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y') WHERE rq.IsActive='Y' AND q.IsActive='Y' AND rrl.IsActive='Y' AND rl.IsActive='Y' [18]
17:21:39.750 ViewCreate.doIt: Created view C_RfQResponseLineQty_vt [18]
17:21:39.781 ViewCreate.doIt: Created view M_InOutConfirm_vt [18]
17:21:39.828 ViewCreate.doIt: Created view M_InOut_LineConfirm_vt [18]
17:21:39.906 ViewCreate.doIt: Created view C_Dunning_Header_vt [18]
17:21:39.953 ViewCreate.doIt: Created view C_Dunning_Line_vt [18]
17:21:40.015 ViewCreate.doIt: Created view R_Request_v [18]
17:21:40.046 ViewCreate.doIt: Created view C_Invoice_v1 [18]
17:21:40.078 ViewCreate.doIt: Created view C_InvoiceLine_v [18]
17:21:40.109 ViewCreate.doIt: Created view C_Invoice_Candidate_v [18]
17:21:40.140 ViewCreate.doIt: Created view M_InOut_Candidate_v [18]
17:21:40.171 ViewCreate.doIt: Created view GL_JournalLine_Acct_v [18]
17:21:40.187 ViewCreate.doIt: Created view AD_ChangeLog_v [18]
17:21:40.250 ViewCreate.doIt: Created view T_InvoiceGL_vt [18]
17:21:40.265 ViewCreate.doIt: Created view M_InOutLineMA_vt [18]
17:21:40.296 ViewCreate.doIt: Created view M_MovementLineMA_vt [18]
17:21:40.343 ViewCreate.doIt: Created view RV_Access [18]
17:21:40.375 ViewCreate.doIt: Created view RV_ReceiptNotMatched [18]
17:21:40.437 ViewCreate.doIt: Created view M_InOut_Header_vt [18]
17:21:41.718 ViewCreate.doIt: Created view M_ProductLocator_v [18]
17:21:41.765 ViewCreate.doIt: Created view RV_Requests_Public [18]
17:21:41.812 ViewCreate.doIt: Created view RV_RequestUpdates_Public [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_ProductQtr(AD_Client_ID, AD_Org_ID, M_Product_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_ID AS M_Product_ID, firstOf(il.DateInvoiced,'Q') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_ID, firstOf(il.DateInvoiced, 'Q'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_ProductQtr(AD_Client_ID, AD_Org_ID, M_Product_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_ID AS M_Product_ID, firstOf(il.DateInvoiced,'Q') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_ID, firstOf(il.DateInvoiced, 'Q'), IsSOTrx [18]
===========> DB.executeUpdate: CREATE OR REPLACE VIEW RV_C_Invoice_ProductMonth(AD_Client_ID, AD_Org_ID, M_Product_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_ID AS M_Product_ID, firstOf(il.DateInvoiced,'MM') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_ID, firstOf(il.DateInvoiced, 'MM'), IsSOTrx [null] [18]
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; State=42000; ErrorCode=942
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4206)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:9472)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3379)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:222)
at org.compiere.util.DB.executeUpdate(DB.java:870)
at org.compiere.util.DB.executeUpdate(DB.java:773)
at org.compiere.process.ViewCreate.doIt(ViewCreate.java:158)
at com.compiere.migrate.DBImport.e(Unknown Source)
at com.compiere.migrate.DBImport.runImport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
-----------> DB.saveError: DBExecuteError - ORA-00942: 表或视图不存在
[18]
===========> ViewCreate.doIt: CREATE OR REPLACE VIEW RV_C_Invoice_ProductMonth(AD_Client_ID, AD_Org_ID, M_Product_ID, DateInvoiced, LineNetAmt, LineListAmt, LineLimitAmt, LineDiscountAmt, LineDiscount, LineOverLimitAmt, LineOverLimit, QtyInvoiced, IsSOTrx) AS SELECT il.AD_Client_ID AS AD_Client_ID, il.AD_Org_ID AS AD_Org_ID, il.M_Product_ID AS M_Product_ID, firstOf(il.DateInvoiced,'MM') AS DateInvoiced, SUM(il.LineNetAmt) AS LineNetAmt, SUM(il.LineListAmt) AS LineListAmt, SUM(il.LineLimitAmt) AS LineLimitAmt, SUM(il.LineDiscountAmt) AS LineDiscountAmt, CASE WHEN SUM(LineListAmt)=0 THEN 0 ELSE ROUND((SUM(LineListAmt)-SUM(LineNetAmt))/SUM(LineListAmt)*100,2) END AS LineDiscount, SUM(LineOverLimitAmt) AS LineOverLimitAmt, CASE WHEN SUM(LineNetAmt)=0 THEN 0 ELSE 100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,2) END AS LineOverLimit, SUM(QtyInvoiced) AS QtyInvoiced, IsSOTrx AS IsSOTrx FROM RV_C_InvoiceLine il GROUP BY il.AD_Client_ID, il.AD_Org_ID, il.M_Product_ID, firstOf(il.DateInvoiced, 'MM'), IsSOTrx [18]
===========> ProgressPanel.publish: Fail. Error to create views: RV_C_InvoiceLine, RV_OrderDetail, RV_C_Invoice_Day, RV_C_Invoice_Month, RV_C_Invoice_ProdMonth, RV_C_Invoice_ProdWeek, RV_C_Invoice_VendorMonth, RV_C_Invoice_Week, RV_C_Invoice_CustomerProdQtr, RV_C_Invoice_CustomerVendQtr, C_RfQResponseLine_v, RV_InOutDetails, C_Invoice_LineTax_v, C_Order_LineTax_v, M_InOut_Line_v, C_SalesDetails_By_BP_V, C_SalesDetails_By_Product_V, C_Invoice_LineTax_vt, C_Order_LineTax_vt, M_InOut_Line_vt, C_RfQResponseLine_vt, RV_C_Invoice_ProductQtr, RV_C_Invoice_ProductMonth, created view #106 [18]
===========> DBImport.runImport: Unable to import Compiere car: D:\Compiere2\data\cdata.gzip [18]
17:21:46.140 ProgressPanel.publish: ** Finished [18]
17:21:46.187 ProgressPanel.finished: Worker success=true [12]
17:21:46.218 ProgressPanel.enableUI: true [12]
*** 2009-10-03 17:24:52.421 Compiere Log (CLogFile) *** |
|
|Archiver|小黑屋|手机版|壹佰网 ERP100
( 京ICP备19053597号-2 )
IP卡
狗仔卡
发表于 2009/10/3 13:53:33
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
抢沙发
千斤顶
显身卡