Patch 21537535 Fails on fndeidgraphs.ldt and fndeidsandboxes.ldt With ORA-00942: Table or View Does Not Exist and .lct Could Not Be Opened for Reading (Doc ID 2048527.1)

Last updated on SEPTEMBER 03, 2015

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

Patch 21537535 fails on fndeidgraphs.ldt and fndeidsandboxes.ldt with ORA-00942: table or view does not exist and .lct could not be opened for reading

 

ERROR
-----------------------

  FAILED: file fndeidgraphs.ldt on worker 2.
  FAILED: file fndeidsandboxes.ldt on worker 3.

adwork02.log
Log file: ...path.../US_fndeidgraphs_ldt.log
Error calling FNDLOAD function.

Uploading from staging tables
  Error during uploading. ORA-06550: line 162, column 38:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 162, column 4:
PL/SQL: SQL Statement ignored
ORA-06550: line 166, column 2:
PLS-00201: identifier 'FND_EID_GRAPH_PKG.UPDATE_ROW' must be declared
ORA-06550: line 166, column 2:

 

adwork003.log
Log file: ...path.../US_fndeidsandboxes_ldt.log
Error calling FNDLOAD function.

The file ...$FND_TOP path.../patch/115/import/fndeidsandboxes.lct could not be opened for reading

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Apply Patch 21537535:R12.ICX.B
2.  Review the patch log and see the errors on fndeidgraphs.ldt and fndeidsandboxes.ldt

 

Cause

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 hundreds of Community platforms