Oracle Recommended Patch 30933719 Fails with JE_IT_ELE_INV_TRX_LINES ORA-00942 (Doc ID 2665531.1)

Last updated on JANUARY 18, 2023

Applies to:

Goal

Oracle Recommended Patch 30933719 fails with JE_IT_ELE_INV_TRX_LINES ORA-00942

-------------------------

  FAILED: file je26757078.sql on worker 1 for product je username JE.
 Deferred: file je26757078.sql on worker 1 for product je username JE. (Deferment number 1 for this job)
 Assigned: file je26757078.sql on worker 1 for product je username JE.
  FAILED: file je26757078.sql on worker 1 for product je username JE.
 Deferred: file je26757078.sql on worker 1 for product je username JE. (Deferment number 2 for this job)
 Assigned: file je26757078.sql on worker 1 for product je username JE.
  FAILED: file je26757078.sql on worker 1 for product je username JE.
Completed: file jlbrspedpreupg1.sql on worker 2 for product jl username JL.
FAILED: file je26757078.sql on worker 1.

--------------------
adwork001.log

sqlplus -s APPS/***** @/u01/app/instancen/apps/apps_st/appl/je/12.0.0/patch/115/sql/je26757078.sql
Connected.
  UPDATE JE_IT_ELE_INV_TRX_LINES
  *
ERROR at line 17:
ORA-06550: line 17, column 25:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 17, column 18:
PL/SQL: SQL Statement ignored
-------------------
f30933719.ldt: BEGIN FND_UMS_BUGFIX_FILE "JE" "patch/115/sql" "je26757078.sql" "120.0.12010000.1"


 

Solution

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