MOAC Responsibility Showing Errors ORA-00060 And ORA-20001
(Doc ID 1164856.1)
Last updated on JANUARY 16, 2024
Applies to:
Oracle Application Object Library - Version 12.0.6 to 12.0.6 [Release 12]Information in this document applies to any platform.
Symptoms
On R12.0.6, when logging to Oracle Applications, and navigating to applet-based form the following error message is displayed:
Oracle error -20001: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON,
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON,
ORA-20001: Oracle error -20001: ORA-20001:SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -2001, N, REASON,
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON,
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE,
ORA-00060: deadlock detected while waiting for resource has been detected in fnd_global.initialize[fnd_init_sql has been detected in fnd_global.initialize[fnd_init_sql].
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON,
ORA-20001: Oracle error -20001: ORA-20001:SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -2001, N, REASON,
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON,
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE,
ORA-00060: deadlock detected while waiting for resource has been detected in fnd_global.initialize[fnd_init_sql has been detected in fnd_global.initialize[fnd_init_sql].
The issue occurs for versions lower than 120.21.12000000.17 of the file AFSCGBLB.pls.
STEPS TO REPRODUCE
====================
1. Set the profile option 'Initialization SQL Statement - Custom' at Responsibility Level to:
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 |