Adding Responsibility Fails With ORA-01685: max extents reached
(Doc ID 2042667.1)
Last updated on DECEMBER 05, 2019
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1]Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Symptoms
Using the Oracle Applications Release 12.1.3, on the 'Security:User > Define' form, adding A Responsibility Fails with ORA-01685 error:
ORA-20002 WF_INVAL_USER_ROLE encountered during execution
of Rule function WF_ROLE_HIERARCHY.Cascade_RF for event
oracle.apps.fnd.wf.ds.userRole.created with key:
PER:60491 FND_RESP:52709|2457219:52008
has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT
ORA-01685: Max extents (505) reached in index APPLSYS.WF_USER_ROLE_ASSIGNMENTS_N1 partition FND_RESP
of Rule function WF_ROLE_HIERARCHY.Cascade_RF for event
oracle.apps.fnd.wf.ds.userRole.created with key:
PER:60491 FND_RESP:52709|2457219:52008
has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT
ORA-01685: Max extents (505) reached in index APPLSYS.WF_USER_ROLE_ASSIGNMENTS_N1 partition FND_RESP
Changes
None
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 |