My Oracle Support Banner

Oracle Diagnostic エラー: Receivableの診断を実行中に ORA-00942 エラーが発生 (Doc ID 1668119.1)

Last updated on FEBRUARY 01, 2018

適用範囲:

Oracle Receivables - バージョン 12.0.1 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

11.5.10.2 から 12.0.1にアップグレード後、ReceivablesのTransaction Diagnosticが以下のエラーで失敗します。:

EXCEPTION - ORA-00942: table or view does not exist caught in 'ARTransactionInfo.runSupportTest'
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3327)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3372)
at oracle.apps.ar.diag.ARTransactionInfo.existsAXEvent115(ARTransactionInfo.java:570)
at oracle.apps.ar.diag.ARTransactionInfo.runSupportTest(ARTransactionInfo.java:340)
at oracle.apps.jtf.regress.qatool.base.DiagBase.runTest(DiagBase.java:364)
at oracle.apps.jtf.regress.qatool.RunTestThread.run(RunTestThread.java:153)


このエラーはReceivableの他のDiagnostic Test 例えばReceipts Diagnostics を実行中では以下のように現れます。

EXCEPTION - ORA-00942: table or view does not exist caught in 'ARReceiptInfo.runSupportTest'

変更点

 

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


本書の内容
現象
変更点
原因
解決策
参照情報

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.