ERP POGenReceiptWS 收料抵搞為何掛了!!

[2010/3/5 下午 02:30:14] Ju: org.compiere.process.POGenReceiptWS
[2010/3/5 下午 02:34:59] Ju:

SELECT SUM(NVL(l.MovementQty,0))
FROM M_InOutLine l, M_InOut m
WHERE m.M_InOut_ID=l.M_InOut_ID
AND m.IsActive='Y'
AND m.DocStatus IN ('CO','CL')
AND l.C_OrderLine_ID=1003063
AND 1=1
AND m.IsSOTrx='N'
AND m.IsReturnTrx='N' [722]
-----------> MInOutWSLine.set_Value: Virtual Column - Name [722]
-----------> MInOutWSLine.set_Value: Virtual Column - ProductSize [722]
>
>
>
>
===========> DB.executeUpdate: INSERT INTO M_InOutWSLine (UpdatedBy,CreatedBy,Up
dated,TargetQty,ScrappedQty,QtyUnDelivered,QtyShipmentAvailable,QtyOrdered,QtyEn
tered,QtyDelivered,Processed,PriceEntered,PriceActual,PickedQty,MovementQty,M_Wa
rehouse_ID,M_Locator_ID,M_InOut_ID,M_InOutWSLine_ID,LineNetAmt,Line,IsInvoiced,I
sDescription,IsActive,DateRequired,DatePromised,DateOrdered,Created,ConfirmedQty
,C_UOM_ID,C_Order_ID,C_OrderLine_ID,AD_Org_ID,AD_Client_ID) VALUES (100,100,TO_D
ATE('2010-03-05 14:34:43','YYYY-MM-DD HH24:MI:SS'),0,0,1,1,1,0,0,'N',159,159,0,1
,1000002,0,1001965,1007702,0,10,'N','N','Y',TO_DATE('2010-02-10','YYYY-MM-DD'),T
O_DATE('2010-02-10','YYYY-MM-DD'),TO_DATE('2010-02-10','YYYY-MM-DD'),TO_DATE('20
10-03-05 14:34:43','YYYY-MM-DD HH24:MI:SS'),0,100,1003321,1004493,1000000,100000
0) [SvrProcess_1267770882671] [722]
java.sql.SQLException: ORA-02291: integrity constraint (C302.M_INOUTWSLINE_LOCAT
OR) violated - parent key not found
; State=23000; ErrorCode=2291
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS
tatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1028)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem
ent.java:3753)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate
(OraclePreparedStatement.java:8829)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:2886)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:2960)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement
.java:215)
at org.compiere.util.DB.executeUpdate(DB.java:840)
at org.compiere.util.DB.executeUpdate(DB.java:747)
at org.compiere.framework.PO.saveNewInsertSQL(PO.java:2839)
at org.compiere.framework.PO.saveNew(PO.java:2688)
at org.compiere.framework.PO.save(PO.java:2251)
at org.compiere.process.POGenReceiptWS.createWSLine(POGenReceiptWS.java:323)
at org.compiere.process.POGenReceiptWS.doIt(POGenReceiptWS.java:229)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:91)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:483)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:251)

-----------> DB.saveError: DBExecuteError - ORA-02291: integrity constraint (C302.M_INOUTWSLINE_LOCATOR) violated - parent key not found
[722]
-----------> MInOutWSLine.saveNewInsertSQL: [SvrProcess_1267770882671]Not inserted - M_InOutWSLine [722]
-----------> POGenReceiptWS.startProcess: Could not create Shipment Line=MInOutWSLine[1007702,M_Product_ID=0,QtyEntered=0,MovementQty=1,M_AttributeSetInstance_ID=0] [722]
14:34:43.890 Trx.rollback: **** SvrProcess_1267770882671 [722]
>
>