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.
Using the Oracle Applications Release 12.1.3, on the 'Security:User > Define' form, adding A Responsibility Fails with ORA-01685 error:
of Rule function WF_ROLE_HIERARCHY.Cascade_RF for event
oracle.apps.fnd.wf.ds.userRole.created with key:
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
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