Adding Responsibility Fails With ORA-01685: max extents reached (Doc ID 2042667.1)

Last updated on DECEMBER 09, 2015

Applies to:

Oracle Applications 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

 

Changes

 None

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