App-Fnd-01564: Oracle Error 942 In Afpoload
(Doc ID 727498.1)
Last updated on FEBRUARY 25, 2024
Applies to:
Oracle Concurrent Processing - Version 11.5.0 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
This problem can occur on any platform.
APP-FND-01564, ORA-00942, ORA-06512, afpoload, concurrent, request
Symptoms
After an RDBMS upgrade from 9.2.0.8 to 10.2.0.3, when attempting to run E-Business Suite (EBS) concurrent requests, some requests fail with the following request / manager log file error:
ERROR
APP-FND-01564: ORACLE error 942 in afpoload
Cause: afpoload failed due to ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_CACHE_VERSIONS_PKG", line 17
ORA-06512: at "APPS.FND_PROFILE", line 166
ORA-06512: at "APPS.FND_PROFILE", line 3677
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: declare dummy boolean;begin
fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, dummy);end; and was executed
from the file &ERRFILE.
Shutting down Concurrent Manager : 11-JUL-2008 08:42:31
APP-FND-01564: ORACLE error 942 in afpoload
Cause: afpoload failed due to ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_CACHE_VERSIONS_PKG", line 17
ORA-06512: at "APPS.FND_PROFILE", line 166
ORA-06512: at "APPS.FND_PROFILE", line 3677
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: declare dummy boolean;begin
fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, dummy);end; and was executed
from the file &ERRFILE.
Shutting down Concurrent Manager : 11-JUL-2008 08:42:31
List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCSQ cannot set profile option value for USER_ID.
APP-FND-01564: ORACLE error 942 in afpoload
Cause: afpoload failed due to ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_CACHE_VERSIONS_PKG", line 17
ORA-06512: at "APPS.FND_PROFILE", line 166
ORA-06512: at "APPS.FND_PROFILE", line 3677
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: declare dummy boolean;begin
fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, dummy);end; and was executed
from the file &ERRFILE.
Shutting down Concurrent Manager : 11-JUL-2008 08:42:31
APP-FND-01564: ORACLE error 942 in afpoload
Cause: afpoload failed due to ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_CACHE_VERSIONS_PKG", line 17
ORA-06512: at "APPS.FND_PROFILE", line 166
ORA-06512: at "APPS.FND_PROFILE", line 3677
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: declare dummy boolean;begin
fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, dummy);end; and was executed
from the file &ERRFILE.
Shutting down Concurrent Manager : 11-JUL-2008 08:42:31
List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCSQ cannot set profile option value for USER_ID.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |