Removing the customization xmls from Metadata

Remove the offending customization xmls from UI MDS using the delete

Steps to remove the files:

1. log into EM Console as weblogic

2. expand Identity and Access>>OIM

3. right click on oim(11.1.2.0.0) and select Sytem mBean Browser.

4. Initially it is in Configuration mbeans., collapse this and expand Application Defined mbeans

5. expand oracle.mds.lcm>>server:SERVERNAME>>Application=oracle.iam.console.identity.self-service.ear,ApplicationVersion=V2.0>>MDSAppRuntime

6. double click on MDSAppRuntime bean

7. click on Operations tab.

8. click deleteMetadata (with 6 parameters)

9. for docs attribute click the edit.

10. Click Add

11. enter /oracle/iam/ui/organization/pages/mdssys/cust/user/xelsysadm/search-org.jsff.xml

12. Click Ok

13. Click Invoke.

Message should return that it is successful  

Repeat this process for any other user's file with a negative value.

ORA-01436: CONNECT BY loop in user data

1)  Error in Logs: java.sql.SQLException: ORA-01436: CONNECT BY loop in user data

Run the following query to check the cycle:

select parent_key, act_key, level, connect_by_iscycle
from act
connect by NOCYCLE prior act_key=parent_key;

In case that PARENT_KEY is equal with the ACT_KEY of an organization, that data should be corrected.