Cannot end date Group, ARP-JTF-210393 ORA-22160: Element at index [1=N)(INSERT_G (Doc ID 2060650.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Common Applications - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Resources Module (JRES)
Unable to end date some parent groups groups after applying Patch 20810284:R12.HZ.B

ERROR
-----------------------
ARP-JTF-210393
ORA-22160: element at index [1] does not exist
(JTF_RS_UNEXP_ERROR=N)(-22160=N)(ORA-22160: ELEMENT AT INDEX [1=N)(INSERT_GRP_DENORM=JTF)

STEPS
-----------------------
CRM Administrator --> Resource Manager --> Maintain Resources --> Groups

End date a group with a parent and child group.

Choose Yes to the following:

"This group contains group member/group roles, and parent/child group hierarchies whose end date exceeds the groups expiration date 31-AUG-2015. Do you want to end date these components also?

  Selecting ‘Yes’ will update all active roles and parent/child group hierarchies with the group’s end date 31-AUG-2015.

  Selecting ‘No’ will revert the group’s end date to the previous value. Please end date these components manually before end dating the group itself.
"

Receive the error above.

Changes

 

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