Gaurav Kumar - 2006-03-20

Hi,

When I try to run Order Receipt and Issue for any MO, I get the following error:

===========> DB.executeUpdate: Update=INSERT INTO MPC_Cost_Collector_Trl (AD_Lan
guage,MPC_Cost_Collector_ID, C_DocType_ID, IsTranslated,AD_Client_ID,AD_Org_ID,C
reated,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.MPC_Cost_Collector_ID
, t.C_DocType_ID, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated
,t.UpdatedBy FROM AD_Language l, MPC_Cost_Collector t WHERE l.IsActive='Y' AND l
.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.MPC_Cost_Collector_ID=10304
55 AND NOT EXISTS (SELECT * FROM MPC_Cost_Collector_Trl tt WHERE tt.AD_Language=
l.AD_Language AND tt.MPC_Cost_Collector_ID=t.MPC_Cost_Collector_ID) [null] [11]
java.sql.SQLException: ORA-00942: table or view does not exist
; State=42000; ErrorCode=942
        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:157)
        at org.compiere.util.DB.executeUpdate(DB.java:691)
        at org.compiere.util.DB.executeUpdate(DB.java:657)
        at org.compiere.model.PO.insertTranslations(PO.java:2257)
        at org.compiere.model.PO.saveFinish(PO.java:1562)
        at org.compiere.model.PO.saveNew(PO.java:2000)
        at org.compiere.model.PO.save(PO.java:1545)
        at org.compiere.mfg.form.VOrderReceiptIssue.createCollector(VOrderReceip
tIssue.java:1539)
        at org.compiere.mfg.form.VOrderReceiptIssue.cmd_process(VOrderReceiptIss
ue.java:1420)
        at org.compiere.mfg.form.VOrderReceiptIssue.actionPerformed(VOrderReceip
tIssue.java:957)

===========> DB.saveError: DBExecuteError - ORA-00942: table or view does not ex
ist
[11]
-----------> Msg.getMsg: NOT found: Close Document [11]
-----------> Msg.getMsg: NOT found: IsDelivery [11]

It seems like that it is trying to update some table, which is not able to update. Can anyone suggest a solution to the problem.

Thanks in advance
Gaurav