Friday, September 22, 2017

12C RCU failed on Oracle Identity Manager Schema


Error:

Wed Sep 13 14:36:54.103 EDT 2017 ERROR assistants.rcu.backend.task.PrereqTask: oracle.sysman.assistants.rcu.backend.task.PrereqTask::execute: Prereq Evaluation Failed
oracle.sysman.assistants.rcu.backend.validation.PrereqException:
ERROR - RCU-6083 Prerequisite check failed for selected component:
CAUSE - RCU-6083 Prerequisite check failed for selected component.
ACTION - RCU-6083 Refer to the RCU logs for additional details. Make sure that the prerequisite requirements are met.OIM
Refer to RCU log at /tmp/RCU2017-09-13_14-34_472068822/logs/rcu.log for details.
        at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.executePrereqTask(PrereqEvaluator.java:713)
        at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:68)
        at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:346)
        at java.lang.Thread.run(Thread.java:748)

Wed Sep 13 14:36:54.103 EDT 2017 ERROR assistants.rcu.backend.task.ActualTask: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException:
ERROR - RCU-6083 Prerequisite check failed for selected component:
CAUSE - RCU-6083 Prerequisite check failed for selected component.
ACTION - RCU-6083 Refer to the RCU logs for additional details. Make sure that the prerequisite requirements are met.OIM
Refer to RCU log at /tmp/RCU2017-09-13_14-34_472068822/logs/rcu.log for details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Error: Views/Synonyms required for XA transaction support are missing in this Database 12c.
         These views/synonyms are required by the OIM Schema.
  Action: Refer Oracle Database Administrator's Guide to install XA transaction recovery views/synonyms
          using the script xaview.sql. Contact your DBA.
          For Database12c CDB config: execute xaview.sql from PDB SYS user
          For Database12c NON-CDB config: execute xaview.sql from CDB SYS user
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:77)
        at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:346)
        at java.lang.Thread.run(Thread.java:748)

Screenshot:




Solution:

1) Login in "sys as sydba" user from putty

2) Run the below Script 

@/u01/oracle/product/12.1.0.2/db_1/rdbms/admin/xaview.sql


3) Re-run the RCU Again. It will resolve the Issue.

Regards,
Arihant


FMW 12c Has Been Released (OIM,OAM,OID AND OUD)

Oracle Fusion Middleware 12c Release has been released. For more information about the product follow the below Links.


Documentations:

http://docs.oracle.com/middleware/12213/idmsuite/index.html

Binaries/Software Files:

http://www.oracle.com/technetwork/middleware/id-mgmt/downloads/oid-11gr2-2104316.html

Certification Matrix:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html


Regards,
Arihant

Error in invoking target 'all' of make file /lib/ins_asha.mk during IDM 11.1.1.9 installation (RHEL 7.2)


Error in invoking target 'all' of makefile '/app/oracle/middleware/Oracle_IDM2/lib/ins_asha.mk (RHEL 7.2)

To resolve the error please run the command,
$ gcc -o /app/oracle/middleware/Oracle_IDM1/bin/hasocket -L /app/oracle/middleware/Oracle_IDM1/lib -L /app/oracle/middleware/Oracle_IDM1/lib -L /usr/lib64 -L /app/oracle/middleware/Oracle_IDM1/lib/stubs /app/oracle/middleware/Oracle_IDM1/lib/s0hasocket.o /app/oracle/middleware/Oracle_IDM1/lib/libhasocket.so -ldl -L/usr/lib -lirc -lpthread -lrt


It will create the hasocket file, check the file using below command and continue the error

$ cat  /app/oracle/middleware/Oracle_IDM1/bin/hasocket
/app/oracle/middleware/Oracle_IDM1/bin/hasocket: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.32, BuildID[sha1]=e45g6468a872fffc860b831b60120c2bf6cfa1358, not stripped


Regards,
Arihant

Sunday, May 28, 2017

OIM 11G R2 PS3 Lab 13: How to hide tiles in OIM 11g R2 PS3?

1) Login to Identity console and create a sandbox


2) Press Home button then click on customize


3)  Click on Structure, blank space, select the gridcell of the tile you want to hide and click on edit button


4)  Click on show component's drop down arrow and click on expressions


5)  Below is the old condition


6) Replace with below condition

#{oimcontext.currentUser.roles['SYSTEM ADMINISTRATORS'] != null}



7) Click on ok button


6) Select the sandbox which is used for this customization and click on Publish button

7) Click on Yes button



Testing

8) Login with End user



9) End user wont be able to see Provisioning Tasks and Pending Approvals Tiles, Since we hide those tiles. Only Administrator can see that.



Thanks,
Arihant

Tuesday, September 27, 2016

How do you find the Oracle Coherence Product version and apply a new Coherence vresion ?


Applicable versions. - Oracle Coherence - Version 3.5.0 to 12.2.1.1.0 [Release AS10g to 12c]

Steps to find the current coherence version :

Location: MW_HOME/oracle_common/modules/oracle.coherence/coherence.jar

To find the exact Version of Coherence Product and to identify the patch level, you can check the MANIFEST.MF within COHERENCE_HOME/lib/coherence.jar -> META-INF directory. MANIFEST.MF shows the product version and patch level.










Steps to apply a new coherence :

1. Download coherence patch 3.7.1.15 from Note:1405110.1
2. Shutdown all the servers.
3. On the each Server including the admin server, do the following.
a. Unzip the contents of the patch to tmp folder.
b. Backup the jar that exists at the location MW_HOME/oracle_common/modules/oracle.coherence/coherence.jar
c. copy the jar tmp/coherence/lib/coherence.jar to the folder MW_HOME/oracle_common/modules/oracle.coherence
d. Backup the folder $Domain/config and all its nested contents.
4. Start the Admin Server
5. Log into weblogic console
6. Lock configuration
7. Select Deployments and locate the coherence library
8. Select the library and press the Delete button.
9. Release Configuration and apply changes.
10. Lock configuration
11. Select Deployments and press the Install button.
12. Select the coherence jar in the file path. Ensure that the library name is "coherence". Hit the next button till you finish deployments.
13. Save and release the configuration.
14. Stop And Start the Admin Server. Verify the the oam_admin deployment is started.

Steps to recovery on failure to install
1. Stop all servers.
2. Restore the $Domain/config folder.
3. Restore the coherence.jar.
4. Restart

Regards,
Arihant Baid

Sunday, September 25, 2016

Exception When Opening a User view page After Upgrading Oracle Identity Manager from OIM R2 PS1 to OIM R2 PS3

Steps to Reproduce :

1) Upgrade OIM R2 PS1 to OIM R2 PS3
2) Bring up the servers Weblogic, SOA and OIM
3) Login on Identity page and click on any existing user or create any new and click view page
4) On view page you will get "JBO-26000: A Generic exception occurred during loading Customizations"


Enable the below logger.

oracle.jbo logger on trace32

Steps the resolve this issue:


1) Please download oracle.iam.console.identity.self-service.ear_V2.0_metadata.zip from weblogic EM console by using below steps,

a) Login to Weblogic EM console --> Expand "Application Deployments" --> oracle.iam.console.identity.self-service.ear(V2.0) (sever1) --> from right side click on "Application Deployments" drop down --> click on " MDS Configuration" --> Select "Export metadata documents to an archive on the machine where this web browser is running." and click on "Export". You will get file "oracle.iam.console.identity.self-service.ear_V2.0_metadata.zip" locally.

2) Take a backup of above file to some other location locally 

3) Unzip above file, navigate to "\oracle.iam.console.identity.self-service.ear_V2.0_metadata\oracle\iam\ui\manageusers\pages\mdssys\cust\site\site" location 

4) Remove reference tag of "Description" both XML's i.e userdetails.jsff.xml, userdetailsPageDef.xml.xml 

Remove following entries from userdetails.jsff.xml, userdetailsPageDef.xml.xml 

userdetailsPageDef.xml.xml

<mds:insert
parent="userdetailsPageDef(xmlns(mds_ns1=http://xmlns.oracle.com/adfm/uimodel))/mds_ns1:bindings" position="last">
<attributeValues IterBinding="UserVO1Iterator" id="description"
xmlns="http://xmlns.oracle.com/adfm/uimodel">
<AttrNames>
<Item Value="description"/>
</AttrNames>
</attributeValues>
</mds:insert>
.
and the following from user-details.jsff

<mds:insert parent="pfl3" position="last">
<af:panelLabelAndMessage xmlns:af="http://xmlns.oracle.com/adf/faces/rich"
label="#{bindings.description.hints.label}" id="dtrt_dc_9587735860">
<af:outputText xmlns:af="http://xmlns.oracle.com/adf/faces/rich"
value="#{bindings.description.inputValue}"/>
</af:panelLabelAndMessage>
</mds:insert>


5) Zip the file again as like earlier folder structure and naming convention. 

6) Import the ZIP file again to env.

a) Login to Weblogic EM console --> Expand "Application Deployments" --> oracle.iam.console.identity.self-service.ear(V2.0) (sever1) --> from right side click on "Application Deployments" drop down --> click on " MDS Configuration" --> Select "Import metadata documents from an archive on the machine where this web browser is running." --> select new ZIP file and Import to env.

7) After successful import. Please stop all servers including managed servers and remove contents in tmp, cache, stage folders 

8) Restart all the servers 

9) Finally Test and let us know if issue further persistence. 


Thanks,
Arihant Baid




Friday, September 16, 2016

SOA PSA Failed When Upgrading PROD_SOAINFRA schema While Upgrading OIM From R2PS1 To R2PS3

Server Details:

OIM Upgrade from Oracle Identity Manager 11g Release 2 (11.1.2.1.0) to 11g Release 2 (11.1.2.3.0).
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -64bit Producation

Error:

"[2016-09-16T00:16:46.793-04:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 13] [ecid: 0000LSlDRudATOLLuQH7iX1Nqr7V000004,0] Error encountered executing SQL statement  FileName: '/u01/oracle/middleware/Oracle_SOA1/rcu/integration/soainfra//sql/upgrade_soainfra_111161_111170_oracle.tsql' LineNumber: '2278' Script log file: null
[2016-09-16T00:16:46.794-04:00] [SOA] [ERROR] [] [upgrade.SOA.SOA1] [tid: 13] [ecid: 0000LSlDRudATOLLuQH7iX1Nqr7V000004,0] UPGAST-00221: unexpected error uprading schema
[2016-09-16T00:16:46.794-04:00] [SOA] [ERROR] [] [upgrade.SOA.SOA1] [tid: 13] [ecid: 0000LSlDRudATOLLuQH7iX1Nqr7V000004,0] [[
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.onException(JDBCEngine.java:869)
        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:833)
        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:773)
        at oracle.sysman.assistants.common.dbutil.jdbc.OracleDDLStatement.execute(ANSISQLStatementType.java:711)
        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1468)
        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1372)
        at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:971)
        at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:846)
        at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra_one_patchset(SOAINFRAPlugin.java:390)
        at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra(SOAINFRAPlugin.java:331)
        at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade(SOAINFRAPlugin.java:226)
        at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:352)
        at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:294)
        at oracle.ias.update.UpgradeDriver.doUpgrades(UpgradeDriver.java:476)
        at oracle.ias.update.gui.UAUpgradeThread.run(UAUpgradeThread.java:41)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1090)
        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:779)
        at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:794)
        ... 13 more


"
----------------------------------------------------------------------------------------------------------------------

While upgrading the PROD_SOAINFRA schema its failed with above error.

Below steps need to be performed in order to resolve the issue.

1. Restore SOAINFRA from backup (the one taken before the upgrade) --No need to restore the other   schemas

2. Provide the below permission

Permissions:

grant dba to PROD_SOAINFRA;
grant execute on sys.dbms_lob to PROD_SOAINFRA;
CREATE OR REPLACE PUBLIC SYNONYM "SCHEMA_VERSION_REGISTRY" FOR "SYSTEM"."SCHEMA_VERSION_REGISTRY";
GRANT execute on utl_file to PROD_SOAINFRA;
GRANT execute on sys.dbms_lob to PROD_SOAINFRA;
GRANT EXECUTE ON DBMS_LOCK TO PROD_SOAINFRA;
GRANT CREATE JOB TO PROD_SOAINFRA;
GRANT CREATE EXTERNAL JOB TO PROD_SOAINFRA;

grant dba to FMW;
grant execute on DBMSLOB to FMW with grant option;
grant execute on DBMS_OUTPUT to FMW with grant option;
grant execute on DBMS_STATS to FMW with grant option;
grant execute on sys.dbms_aq to FMW with grant option;
grant execute on sys.dbms_aqadm to FMW with grant option;
grant execute on sys.dbms_aqin to FMW with grant option;
grant execute on sys.dbms_aqjms to FMW with grant option;
grant execute on sys.dbms_aqadm to FMW with grant option;
grant execute on sys.dbms_aq to FMW with grant option;
grant execute on utl_file to FMW with grant option;
grant execute on dbms_lock to FMW with grant option;
grant select on sys.V$INSTANCE to iamupgrade with grant option;
grant select on sys.GV$INSTANCE to iamupgrade with grant option;
grant select on sys.V$SESSION to iamupgrade with grant option;
grant select on sys.GV$SESSION to iamupgrade with grant option;
grant select on dba_scheduler_jobs to FMW with grant option;
grant select on dba_scheduler_job_run_details to FMW with grant option;
grant select on dba_scheduler_running_jobs to FMW with grant option;
grant select on dba_aq_agents to FMW with grant option;
grant execute on sys.DBMS_SHARED_POOL to FMW with grant option;
grant select on dba_2pc_pending to FMW with grant option;
grant select on dba_pending_transactions to FMW with grant option;
grant execute on DBMS_FLASHBACK to FMW with grant option;
grant execute on dbms_crypto to FMW with grant option;
grant execute on DBMS_REPUTIL to FMW with grant option;
grant execute on dbms_job to FMW with grant option;
grant select on pending_trans$ to FMW with grant option;
grant select on dba_scheduler_job_classes to FMW with grant option;
grant select on SYS.DBA_DATA_FILES to FMW with grant option;
grant select on SYS.V$ASM_DISKGROUP to FMW with grant option;
grant select on v$xatrans$ to FMW with grant option;
grant execute on sys.dbms_system to FMW with grant option;
grant execute on DBMS_SCHEDULER to FMW with grant option;
grant select on dba_data_files to FMW with grant option;
grant execute on UTL_RAW to FMW with grant option;
grant execute on DBMS_XMLDOM to FMW with grant option;
grant execute on DBMS_APPLICATION_INFO to FMW with grant option;
grant execute on DBMS_UTILITY to FMW with grant option;
grant execute on DBMS_SESSION to FMW with grant option;
grant execute on DBMS_METADATA to FMW with grant option;
grant execute on DBMS_XMLGEN to FMW with grant option;
grant execute on DBMS_DATAPUMP to FMW with grant option;
grant execute on DBMS_MVIEW to FMW with grant option;

3. Run PSA again

Ref: https://docs.oracle.com/middleware/11119/core/PATCH/patch_set_assistant.htm#PATCH678

Thanks,
Arihant








Tuesday, January 19, 2016

RCU-6083:Failed - Check prerequisites requirement for selected component:OIM

Error in Log

2016-01-19 20:02:20.064 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.PrereqTask::execute: Prereq Evaluation Failed
oracle.sysman.assistants.rcu.backend.validation.PrereqException: RCU-6083:Failed - Check prerequisites requirement for selected component:OIM
Please refer to RCU log at /u01/oracle/logdir.2016-01-19_20-00/rcu.log for details.  at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.executePrereqTask(PrereqEvaluator.java:663)
        at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:68)
        at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
        at java.lang.Thread.run(Thread.java:745)

2016-01-19 20:02:20.064 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6083:Failed - Check prerequisites requirement for selected component:OIM
Please refer to RCU log at /u01/oracle/logdir.2016-01-19_20-00/rcu.log for details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Error: Views/Synonyms required for XA transaction support are missing in this Database 12c.
  These views/synonyms are required by the OIM Schema.
  Action: Refer Oracle Database Administrator's Guide to install XA transaction recovery      views/synonyms using the script xaview.sql. Contact your DBA.
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:76)
        at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)

        at java.lang.Thread.run(Thread.java:745)


Solution:

Before running the RCU, connect with sys as sysdba user and run the below to sql's.

@/u01/oracle/product/12.1.0.2/db_1/javavm/install/initxa.sql


@/u01/oracle/product/12.1.0.2/db_1/rdbms/admin/xaview.sql


Restart the Database


Now retry running the RCU.

Thank you
Arihant Jain

Thursday, January 14, 2016

OIM 11g R2 PS3 Database schema Model

OIM 11g R2 PS3 Database schema Model


TABLE_NAME Component Table level COMMENTS in DB
AUD Audit Define the Auditors. 
AUD_JMS Audit Transactional table storing intermediate audit information.
AUDIT_EVENT Lightweight Audit Stores Audit Events.
AUDIT_EVENT_GROUP Lightweight Audit Stores metadata for Audit Event Groups.
AUDIT_EVENT_ENT_TYPE_ACTN Lightweight Audit Stores metadata for entity type and its corresponding audit action.
AUDIT_EVENT_GRP_ENT_TYPE_ACTN Lightweight Audit Stores the relationship between Audit Event Groups and Entity Type Audit actions.
GPA Audit Stores Group Profile audit snapshots and deltas.
UPA Audit Stores User Profile audit snapshots and deltas.
UPA_FIELDS Audit Stores changes only for user profile audit history in denomalized format.
UPA_GRP_MEMBERSHIP Audit Stores groups membership history in denomalized format.
UPA_RESOURCE Audit Stores user profile resource history in denomalized format.
UPA_UD_FORMFIELDS Audit This table would hold the history of changes to the process form data.
UPA_UD_FORMS Audit This table would hold the summary of changes to the process form data.
UPA_USR Audit Stores user profile history in denomalized format.
ARM_AUD Audit
ADMIN_ROLE Authorization OOTB Admin Roles.
ADMIN_ROLE_MEMBERSHIP Authorization Admin-role to user membership in an organization scope.
ENTITY_PUBLICATION Authorization Entity publication to organization.
ROLE_PUBLICATION_VW Authorization View to give additional Role specific details (like role-name etc) for published Role.
APP_INST_PUBLICATION_VW Authorization View to give additional App-instance specific details (like app-instance name etc) for published App-Instance.
ENTITLEMENT_PUBLICATION_VW Authorization View to give additional Entitlements specific details (like entitlement name etc) for published Entitlements.
ADMIN_ROLE_MEMBERSHIP_VW Authorization View to give additional organization specific details (like parent org-id) for published admin role membership.
USER_ARM_ROLES_VW Authorization
ADMIN_ROLE_CAPABILITY Authorization It stores the mapping between the
 Admin_Role to Capability tables
ADMIN_ROLE_RULE_SCOPES Authorization Stores the scope ids over which dynamic admin role membership will be granted when the rule for
an admin role will get evaluated.  It also stores with/without hierarchy flag for each scope.
CAPABILITY Authorization It stores the capabilities for every
action governed by the authorization policies
CATALOG Catalog Unified collection of catalog items.It will store the items of all the entities that will like to make themselves as Catalogable. At
present we have Role, Entitlement and Application Instance as the catalogable entities.
CATALOG_METADATA_DEFINITION Catalog Collection of additional metadata defined on Catalog items.
CATALOG_HIERARCHICAL_ATTR Catalog Stores hierarchical attributes or technical glossary for catalog items.
CPA_CATALOG Catalog Audit table for catalog item.
CPA_CATALOG_FIELDS Catalog Audit table for catalog item, this will contains attribute changes.
EIF Common Services Export Import Files. Each row contains one single file used in export/import operation. For export there is only one file.
EIH Common Services Export Import History. Each row represents one Data Deployment Management session.
EIL Common Services DB Based lock for export operation. Used to make sure only one user can import at a time. This is currently not managed through dataobjects.
EIO Common Services Export Import Objects. Each row represents one object exported/imported.
EIS Common Services Substitutions used during import process.
EMD Common Services Core -- Email Definition Information Table That Holds The Email Template Definitions.
JOB_HISTORY Common Services Historical Data for each Job Run.
LOCALTEMPLATE Common Services Table for Locale specific details for Notification Templates.
NOTIFICATIONLOG Common Services Logging specific to Notifications.
NOTIFICATIONTEMPLATE Common Services Table for Notification Templates.
PTY Common Services Client Properties Table.
QRTZ92_BLOB_TRIGGERS Common Services Quartz table to store Blob Triggers.
QRTZ92_CALENDARS Common Services Quartz table to store Calendars.
QRTZ92_CRON_TRIGGERS Common Services Quartz table to store Cron Triggers.
QRTZ92_FIRED_TRIGGERS Common Services Quartz table to store Fired Triggers.
QRTZ92_JOB_DETAILS Common Services Quartz table to store Job Details.
QRTZ92_JOB_LISTENERS Common Services Quartz table to store Job Listeners.
QRTZ92_LOCKS Common Services Quartz table to store Locks.
QRTZ92_PAUSED_TRIGGER_GRPS Common Services Quartz table to store Paused Trigger Groups.
QRTZ92_SCHEDULER_STATE Common Services Quartz table to store Scheduler State.
QRTZ92_SIMPLE_TRIGGERS Common Services Quartz table to store Simple Triggers.
QRTZ92_TRIGGERS Common Services Quartz table to store Triggers.
QRTZ92_TRIGGER_LISTENERS Common Services Quartz table to store Triggers Listeners.
AAD ID Admin List To Define The Administrators For Each Organization And Their Delegated Admin Privileges.
AAP ID Admin Table for storing Resource - Organization level parameter Values.
ACP ID Admin/Provisioning Acp - Link Table That Holds Reference To Act And Pkg Tables,
 Table That Defines The Objects (Resources) Allowed For A Particular Organization.
ACT ID Admin Defines information about all organizations created in OIM through Xellerate.
GPG ID Admin List to define the (nested)group members of User Group in the 'User Group' form.
MLS_LOCALE ID Admin List of languages used for MLS [Multi Lingual Support] (for role) and MR [Multi Representation] (for user) representation of display names.
MLS_UGP ID Admin Stores entries of MLS display names of roles.
MLS_USR ID Admin Stores entries of MR display names of users.
MV_USER_COLS ID Admin/Recon This table stores the data from USER_TAB_COLUMNS to reduce the data dict. recursive calls for improved performance.
ORG_HIERARCHY ID Admin Holds information about the complete organization Hierarchy.
ORG_USER_MEMBERSHIPS ID Admin Stores the User-Org membership details.
PCQ ID Admin Holds the challenging questions and answers for a user.
POG ID Admin Join table between Policy and User Groups, Specifies the groups to whom an access policy will apply.
PWH ID Admin These 2 tables are not IDAMDIN specific( PWR/PWH) . Same tables are used for password policy info when they are linked to the resource objects.
Purpose-Used to maintain password history.
PWR ID Admin These 2 tables are not IDAMDIN specific( PWR/PWH) . Same tables are used for password policy info when they are linked to the resource objects.
Purpose-Used to store Password Rule Policies
RPW ID Admin Rules To Apply To A Password Policy, Defines The Policy Determination Rules Attached To A Password Policy.
PXD ID Admin Table that holds the list of all Proxies Defined.
RGP ID Admin Rules To Apply To A User Group,
Defines The Auto-group Membership Rules Attached To A Particular Group.
ROLE_CATEGORY ID Admin The table is used to store role categories. A category is similar to a folder that can be used to organize roles displayed in the console. Role categories simplify the administrators browse experience,
allowing for easy navigation to roles of interest.
UGP ID Admin Defines a group of users.
UHD ID Admin User Policy Profile History  Details table.
UPD ID Admin User Policy Profile Details table.
UPH ID Admin User Policy Profile History table.
UPP ID Admin User Policy Profile table.
USG ID Admin This table stores which users are in which groups.
USR ID Admin Stores all information regarding a user.
USR_ATTRIBUTE_RESERVATIONS ID Admin To store User Attributes with their reserved values.
USR_CONFIG_HISTORY ID Admin This table stores the audit data for all the modifications done to User.xml are audited here.
UWP ID Admin Window sequence, nesting in CarrierBase explorer for each user group.
OIM_TMP_MLS_TABLE ID Admin Oracle Global Temporary Table for intermediate processing of User entries of MLS data.
DYN_EVAL_CHANGELOG ID Admin Contains the changelog data for dynamic evaluation since last job run.
LATEST_PLUGINS Platform Stores latest version information for plugins.
OIMHOME_JARS Platform Stores the jars that are uploaded using upload or update jar utility. These jars are primarily used by adapters.
ORCHPROCESS Platform Stores the process instances that are being executed.
PLUGINS Platform Stores plugins that are uploaded using register plugin utility.
PLUGIN_METADATA Platform Stores Metadata associated with  plugins.
PLUGIN_ZIP Platform Stores plugin in zips as serialized blobs.
RESOURCES Platform Stores custom resource bundle information that are uploaded using upload or update resource bundle utilities.
FAILED_TASKS Platform Stores information related to failed JMS messages.
ORCHEVENTS_TMP Platform Available only in an an envoronment upgraded to R2PS3 (not OOTB)
ORCHFAILEDEVENTS_TMP Platform Available only in an an envoronment upgraded to R2PS3 (not OOTB)
ORCH_BENEFICIARIES_TMP Platform Available only in an an envoronment upgraded to R2PS3 (not OOTB)
ADL Provisioning Contains the all of the necessary parameters for an adapter task of type IF, ELSE IF, FOR, WHILE, SET, and VARIABLE tasks. These type of tasks are known as LOGIC TASKS.
ADM Provisioning Data mapping between parameters input/output parameters and source/sink.
ADP Provisioning Defines an adapter created through the Adapter Factory.
ADS Provisioning Database, schema and procedure name selections which define a stored procedure adapter task.
ADT Provisioning Defines a task attached to an adapter.
ADU Provisioning Contains the web service and method chosen for a task of the Adapter Factory.
ADV Provisioning Adapter variable table contains variables that have been created for specific adapters.
APP_INSTANCE Provisioning Application Instance definition information.
ARS Provisioning Contains custom response codes for 'Process Task' Adapters only.
ATP Provisioning Defines input and output parameters for the constructor and method of an adapter task of type JAVA, UTILITY, TAME, REMOTE, and XLAPI.
DAV Provisioning Stores the runtime data mappings for 'Entity' & 'Rule Generator' adapters. The data source being an Xellerate form or child table, or a user defined process form.
DEP Provisioning Dependencies Among Tasks Within A Workflow Process.
DOB Provisioning Data Resource definition consisting of the fully qualified class name of the data object.
DVT Provisioning Defines the one to many relationship between Data Resources and Event Handlers (this includes adapters).
ENT_ASSIGN Provisioning Stores Entitlement Assignments.
ENT_ASSIGN_DELTA Provisioning Intermediate table to store changes to Entitlement Assignments.
ENT_ASSIGN_HIST Provisioning Stores Historical Entitlement Assignment information.
ENT_LIST Provisioning Provisioning level Entitlement catalog.
ESD Provisioning Encrypted columns not within the bounds of the SDK.
EVT Provisioning Defines event handlers by providing a the process and class name. In addition the scheduling time of when the event handler can execute is set to  pre (insert, update, delete)  or post (insert, update, delete).
FUG Provisioning List to define the administrators for each user defined object in the 'Structure Utility' form or for each user defined field in the 'User Defined Field Definition' form.
MAP Provisioning XML MAP SCHEMA INFORMATION.
MAV Provisioning Stores the runtime data mappings for 'Process Task' adapters. The data source being a process form, Location, User, Organization, Process, IT Resource, or Literal data.
MEV Provisioning E-mail notification events.
MIL Provisioning Holds information about tasks of a process.
MSG Provisioning Defines the user groups that have permission to set the status of a process task.
MST Provisioning Task Status And Object Status Information. Holds All The Task Status To Object Status Mappings.
OBA Provisioning OBJECT AUTHORIZER INFORMATION.
OBD Provisioning OBJECT DEPENDENCIES.
OBI Provisioning OBJECT INSTANCE INFORMATION.
OBJ Provisioning Resource Object definition information.
ODF Provisioning HOLDS OBJECT TO PROCESS FORM DATA FLOW MAPPINGS.
ODV Provisioning OBJECT EVENTS/ADAPTERS INFORMATION.
OFFLINE_USER_ATTRIBUTES Provisioning
OIO Provisioning OBJECT INSTANCE REQUEST TARGET ORGANIZATION INFORMATION.
OIU Provisioning OBJECT INSTANCE REQUEST TARGET USER INFORMATION.
OOD Provisioning OBJECT INSTANCE REQUEST TARGET ORGANIZATION DEPENDENCY INFORMATION.
OPS Provisioning
ORC Provisioning This Entity Holds The Detail On Each Order. This Could Be Considered The Items Section Of An Invoice.
 This Entity Is The Instance Of A Particular Process.
ORD Provisioning Holds information that is necessary to complete an order regardless of a process being ordered.
ORF Recon/Provisioning Resource Reconciliation Fields.
ORR Recon/Provisioning OBJECT RECONCILIATION ACTION RULES.
OSH Provisioning Task Instance Assignment History.
OSI Provisioning Holds information about tasks that are created for an order.
OST Provisioning OBJECT STATUS INFORMATION.
OTI Provisioning Holds specific information such as status or scheduled dates about an instance of a task which are in Pending(Provisioning/Approval tasks ) and Rejected (Provisioning tasks) status buckets.
OUD Provisioning Object Instance Request Target User Dependency Information.
 Holds The Dependency Between Different Resource Instances Provisioned To A User.
OUG Provisioning List to define the administrators for each Resource Resource.
PDF Provisioning PACKAGE DATA FLOW TABLE HOLDS THE DATA FLOW RELATIONSHIPS BETWEEN PACKAGES.
PKD Provisioning PACKAGE DEPENDENCY TABLE HOLDS THE DEPENDENCY RELATIONSHIPS BETWEEN CHILD PACKAGES OF A PARENT PACKAGE.
PKG Provisioning Consists of names and system keys of service processs, which consist of a group of services from the TOS table.
 Defines a Process in Xellerate.
PKH Provisioning Package Hierarchy Table Holds The Parent-child Relationships Between Processes.
POC Provisioning Stores values for the child tables of the Object/Process form of a resource being provisioned by an access policy.
POF Provisioning POLICY FIELD TABLE HOLDS THE FIELD VALUE PAIRS THAT CONSTITUTE THE DEFINITION OF A POLICY.
POL Provisioning Policy Table Holds A Policy, Defines An Access Policy In The System.
POP Provisioning Policy Package Join Table Holds The Packages That A Particular Policy Orders For User,
 Defines Which Resources Will Be Provisioned Or Denied For A Particular Access Policy.
PRF Recon/Provisioning Process Reconciliation Field Mappings.
PUG Provisioning List To Define The Administrators And Their Delegated Admin Rights  For Each Process.
QUE Provisioning ADMINISTRATIVE QUEUES DEFINITION
RAV Provisioning Stores the runtime data mappings for 'Pre-populater' adapters. The data source being an Xellerate form or child table, or a user defined form.
RES Provisioning This table is used to stored adapter resources entered by the user.
RGM Provisioning Table for Response Code Generated Milestones.
RGS Provisioning Defines all known registries. These are used by Web Service tasks in an Adapter to communicate with a web service.
RLO Provisioning This table contains directory URLs which are referenced by Adapter Factory jar/class files.
RML Provisioning Rules To Apply To Task, Defines The Task Assignment Rules Attached To A Process Task.
ROP Provisioning Rules To Apply To An Object-process Pair, Defines The Process Determination Rules Attached To A Resource Object.
RPW Provisioning Rules To Apply To A Password Policy, Defines The Policy Determination Rules Attached To A Password Policy.
RSC Provisioning Defines The All The Possible Response Code For A Process Task.
RUE Provisioning Defines The Elements In A Rule Definition.
RUL Provisioning RULE DEFINITIONS.
RVM Provisioning Holds Recovery Milestones.
SCH Provisioning Holds specific information about an instance of a ask such as its status or scheduled dates.
SDC Provisioning Column metadata.
SDH Provisioning Meta-Table Hierarchy.
SDK Provisioning User define data object meta data definition.
SDL Provisioning SDK VERSION LABELS.
SDP Provisioning User defined column properties.
SEL Provisioning Data Object Permissions For Groups On A Specified Dataobject.
SPD Provisioning IT Resource parameter definition
SRE Provisioning Defines Which Pre-populate Rule Generator Will Run For A Field Of User Defined Data Object.
SRS Provisioning IT Resource - IT Resource join.
STA Provisioning Status Codes
SVD Provisioning IT Resource type definition.
SVP Provisioning IT Resource property definition.
SVR Provisioning It Resource Instance Definition.
TOS Provisioning Holds information about a process.
UNM Provisioning  "UnDo Milestone" Feature.
USER_PROVISIONING_ATTRS Provisioning Transactional table that stores Access Policy related provisioning information for Users.
ORF Recon/Provisioning Resource Reconciliation Fields.
ORR Recon/Provisioning OBJECT RECONCILIATION ACTION RULES.
PRF Recon/Provisioning Process Reconciliation Field Mappings.
RA_LDAPROLE Recon To store ldap role reconciliation data.
RA_LDAPROLEHIERARCHY Recon To store ldap hierarchy reconciliation data .
RA_LDAPROLEMEMBERSHIP Recon To store ldap role membership reconciliation data.
RA_LDAPUSER Recon To store ldap user reconciliation data. 
RA_MLS_LDAPROLE Recon To store MLS ldap role reconciliation data.
RA_MLS_LDAPUSER Recon To store MLS ldap user reconciliation data.
RA_XELLERATE_ORG Recon Recon Staging table for resource object Xellerate Organization.
RECON_ACCOUNT_MATCH Recon Reconciliation Event Processes Matched.
RECON_ACCOUNT_OLDSTATE Recon Intemediate Table for storing account specific audit data.
RECON_BATCHES Recon Reconciliation Batches.
RECON_CHILD_MATCH Recon Reconciliation Event Processes Child Table Matches.
RECON_EVENTS Recon Reconciliation Events.
RECON_EVENT_ASSIGNMENT Recon Reconciliation Event Assignments.
RECON_EXCEPTIONS Recon Exceptions found in Target data during Reconciliation.
RECON_HISTORY Recon Reconciliation Event Action History.
RECON_JOBS Recon Reconciliation Jobs.
RECON_ORG_MATCH Recon Reconciliation Event Organizations Matched.
RECON_ROLE_HIERARCHY_MATCH Recon Reconciliation Event Role Hierarchy Matched.
RECON_ROLE_MATCH Recon Reconciliation Event Role Matched.
RECON_ROLE_MEMBER_MATCH Recon Reconciliation Event Role Member Matched.
RECON_TABLES Recon Reconciliation Table Names.
RECON_UGP_OLDSTATE Recon Intemediate Table for storing role specific audit data.
RECON_USER_MATCH Recon Reconciliation Event Users Matched.
RECON_USER_OLDSTATE Recon Intemediate Table for storing User specific audit data.
OIM_TMP_RECON_MLS_TABLE Recon Oracle Global Temporary Table used in  intermediate processing of CHANGELOG event entries of MLS data for Recon Horizontal Tables.
REQUEST Request To Store Request summary information.
REQUEST_APPROVALS Request To store Request Approval instances in a request and their status.
REQUEST_APPROVAL_POLICIES Request Stores approval policy details like policy name, associated approval process, rules etc . Each approval policy is uniquely identified by APPROVAL_POLICY_KEY value, and is generated by sequence object APPROVAL_POLICY_SEQ.
Approval Rule is nested and defined in XML format.
REQUEST_BENEFICIARY Request Stores the ids of benificiaries for agiven request
REQUEST_BENEFICIARY_ENTITIES Request Stores the entities that are part of a beneficiary in a Request.
REQUEST_BENEFICIARY_ENTITYDATA Request Stores the entity data for the entities pertaining to a Beneficiary.
REQUEST_COMMENTS Request This table is deprecated and is no longer used.
REQUEST_ENTITIES Request Stores the entities that are requested in a Request.
REQUEST_ENTITY_ATTR_VALUES Request This table stores values of multi-valued Request entity attributes. Binary values are stored in column REAV_VALUE_BLOB.
REQUEST_ENTITY_DATA Request Stores the entity data for the entities that are requested.
REQUEST_HISTORY Request To store Request History information.
REQUEST_PROFILES Request To store Request Profile summary information.
REQUEST_PROFILE_ENTITIES Request To store entities associated with a Request Profile.
REQUEST_PROFILE_ENTITY_DATA Request To Store data associated with Request Profile entities.
REQUEST_STAGES Request To store possible stages in a Request.
REQUEST_TEMPLATE Request This table is deprecated and is no longer used.
Used to store Request Template related information.
REQUEST_TEMPLATE_ATTRIBUTES Request Stores additional attributes associated with Request.
WF_DEFINITION Request To Store SOA composite registration information.
WF_INSTANCE Request To store the SOA composite instances.
ROLESOD_CONFLICTS SOD To store Role SOD Conflicts.
SIL_ASYNCH_INFO SOD Table contains Entry for each Asynchronous SODCheck.
SIL_PARAMETERS SOD IT Resource Instance names for each SIL System.
SIL_SCO_STY_JOIN SOD Service component implementation for every System Type.
SIL_SERVICE_COMP SOD Lists the various Service Components for completing and SoDCheck.
SIL_SYSTEM SOD Stores the SIL systems supported and required connection parameters.
SIL_SYSTEM_TYPE SOD Stores all the entries of SIL Systems.
SIL_TYPES SOD Types of all SIL category available.
SIL_TYPE_CATEGORY SOD Categories of SIL Types available.
WS_SODCHECK SOD Stores details of Webservice messages sent for SoD Check like Message ID, Callback URL, Request ID from BPEL workflow.
ADF_LOOKUPS UI View to search in look up tables.
ADF_LOOKUP_TYPES UI View to search in look up tables for the appropriate look up type.
CERTDS_ENT_ASGN Certification Decision and snapshot table for entitlement assignments in
entitlement certifications.
CERTDS_USER_ROLE_ASGN Certification Decision and snapshot table for role memberships.
CERTD_ACCT_ENT_ASGN Certification Link table for certification and accounts entitlements .
CERTD_APP_INST Certification Decision table for application instances.
CERTD_ENT_DEFN Certification Decision table for entitlement definitions.
CERTD_POL_ENT_DEFN Certification Decision table for entitlement definitions in policies.
CERTD_ROLE Certification Decision table for roles.
CERTD_ROLE_POLICY Certification Decision table for Role Policies associations.
CERTD_USER Certification Decision table for users.
CERTD_USER_ACCT Certification Decision table for user accounts.
CERTS_ACCOUNT Certification Snapshot table for user accounts.
CERTS_ACCT_ENT_ASGN Certification Snapshot table for entitlement assignments.
CERTS_APP_INST Certification Snapshot table for application instances.
CERTS_CATALOG_UDF Certification Snapshot table for catalog UDF data.
CERTS_ENT_DEFN Certification Snapshot table for entitlement definitions.
CERTS_POLICY Certification Snapshot table for policies.
CERTS_POL_ENT_DEFN Certification Snapshot table for entitlement definitions in policies.
CERTS_ROLE Certification Snapshot table for roles.
CERTD_STATS Certification Stores completion statistics for certifications.
CERTS_USER Certification Snapshot table for users.
CERTS_USR_UDF Certification Snapshot table for user UDF data.
CERT_ACTION_HISTORY Certification Event details for certification action history.
CERT_ACTION_HISTORY_SCOPE Certification Link table defining scope for certification action history events.
CERT_CERTS Certification Certification Instances table.
CERT_CONFIG Certification Certification configuration table.
CERT_DEFN Certification Certification definition table.
CERT_EVT_LSNR Certification Certification event listener definition table.
CERT_EVT_TRIG Certification List of users requiring certification due to triggering of event
listener rules.
CERT_LAST_DECISION Certification Last certification decision for an item. 
CERT_TASK_ACTION Certification Decision table for certification items in a SOA task.
CERT_TASK_INFO Certification Link for a certification instance to a SOA task.
IDA_POLICY_VIOLATION ID Audit Instances of a Policy Violation.
IDA_POLICY_VIOLATION_CAUSE ID Audit Instances of a Policy Violation Cause.
IDA_REMEDIATOR ID Audit Instances of a Policy Violation
Remediator.
IDA_SCAN_DEFN ID Audit Table for storing IDA SCAN
 DEFINITIONS.
IDA_SCAN_RUN ID Audit Instances of running a scan
definition.
IDA_SCAN_RUN_POLICIES ID Audit Table for storing relationship
information between IDA_SCAN_RUN and POLICY.
IDA_SCAN_RUN_POLICY_VIOLATION ID Audit Table for storing relationship
information between IDA_SCAN_RUN and IDA_POLICY_VIOLATION.
IDA_SCAN_RUN_USER ID Audit Table for storing relationship
information between IDA_SCAN_RUN and USER.
IDA_TASK_POLICY_VIOLATION ID Audit Table for storing external
relationship information between SOA TSK and POLICY VIOLATION.
POLICY Policy Engine The table holds the definitions for the policy engine policies.
POLICY_RULE_ASSIGNMENT Policy Engine The table holds the relations between policies and rules.
POLICY_TYPE Policy Engine The table holds the definitions for the policy engine policy types.
RETURN_VALUES Policy Engine The child table holds return value definitions for the policy engine rules.
RULE Policy Engine The table holds the definitions for the policy engine rules.
BULKLOAD_BATCH Bulkload Post Processing Bulkload Post Processing.
BULKLOAD_USR Bulkload Post Processing Bulkload Post Processing.
FAILED_CALLBACKS None Stores association information between callback destinations.
CALLBACK_INVOCATION_RESULT SPML Table to store results of callbacks invoked by OIM. Used to aggregate status for both synchronous and asyncrhronous invocation.
CALLBACK_DESTINATIONS None Stores the list of failed callback destinations to retry .
CALLBACK_PAYLOAD None Stores the Callback notification data to be re-sent.
OIM_RECON_CHANGES_BY_RES_MV Report Materialized View used in the BI Report-
UPGRADE_FEATURE_LIST Upgrade
UPGRADE_FEATURE_STATE Upgrade
UPGRADE_MDS_MERGE Upgrade Table to store upgrade LCM data for Authorization.
OIM_DATAPRG_FAILED_KEYS  OOTB Online Purge Table Logging table to store the entity keys for each module/entity which were failed during scheduled purge run.
OIM_DATAPRG_TASKS_LOGDTLS    OOTB Online Purge Table Logging table to store the details of the OIM Scheduled Task controlled purge runs for the module/entity feature level details.
OIM_DATAPURGE_TASK_LOG       OOTB Online Purge Table Logging table to store the details of the OIM Scheduled Task controlled purge runs,for the deletion of Entity data.
OIM_TMP_TASK_ARCH_TAB       OOTB Task Archival Table Temporary table used by Provisioning Task Archival utility to stage data during the run.
ARCH_REQUEST       OOTB Request Archival Table Archival table for storing archived data from REQUEST table during Request Archival/Purge.
ARCH_REQUEST_APPROVALS        OOTB Request Archival Table Archival table for storing archived data from REQUEST_APPROVALS table during Request Archival/Purge.
ARCH_REQUEST_BE               OOTB Request Archival Table Archival table for storing archived data from REQUEST_BE table during Request Archival/Purge.
ARCH_REQUEST_BED              OOTB Request Archival Table Archival table for storing archived data from REQUEST_BED table during Request Archival/Purge.
ARCH_REQUEST_BENEFICIARY      OOTB Request Archival Table Archival table for storing archived data from REQUEST_BENEFICIARY table during Request Archival/Purge.
ARCH_REQUEST_COMMENTS         OOTB Request Archival Table Archival table for storing archived data from REQUEST_COMMENTS table during Request Archival/Purge.
ARCH_REQUEST_ENTITIES         OOTB Request Archival Table Archival table for storing archived data from REQUEST_ENTITIES table during Request Archival/Purge.
ARCH_REQUEST_ENTITY_DATA      OOTB Request Archival Table Archival table for storing archived data from REQUEST_ENTITY_DATA table during Request Archival/Purge.
ARCH_REQUEST_HISTORY          OOTB Request Archival Table Archival table for storing archived data from REQUEST_HISTORY table during Request Archival/Purge.
ARCH_REQUEST_TA               OOTB Request Archival Table Archival table for storing archived data from REQUEST_TA table during Request Archival/Purge.
ARCH_ROLESOD_CONFLICTS        OOTB Request Archival Table Archival table for storing archived data from ROLESOD_CONFLICTS table during Request Archival/Purge.
ARCH_WF_INSTANCE       OOTB Request Archival Table Archival table for storing archived data from WF_INSTANCE table during Request Archival/Purge.
CIH Connector [OOTB] Holds connector specific installation history information. It also stores Connector Name, Connector Version, Connector XML, etc.
COUN_LOG_TAB Connector [OOTB] Used by the Connector Uninstall utility for storing temporary data.
GCD Connector Framework GCD (Generic Connector Definition) is used by GTC for storing the information about the connectors that are created using GTC.
ATS Deprecated Stores which services or can be ordered by which organizations and which rates apply.
QUG Deprecated ADMINISTRATIVE GROUP MEMBERS.
QUM Deprecated ADMINISTRATIVE QUEUE MEMBERS.
TSA Deprecated STORES INITIALIZATION PARAMS (NAME/VALUE PAIRS) FOR SCHEDULER TASKS.
TSH Deprecated Recording History of Task Execution in Scheduler.
TSK Deprecated SCHEDULER TASK DEFINITION INFORMATION.
REQ Deprecated THIS TABLE HOLDS REQUEST INFORMATION.
RIO Deprecated Request Organizations Resolved Object Instances.
RQA Deprecated REQUEST TARGET ORGANIZATION INFORMATION.
RQC Deprecated REQUEST COMMMENT INFORMATION.
RQD Deprecated Contains self-registration request data for web admin.
RQE Deprecated REQUEST ADMINISTRATIVE QUEUES.
RQH Deprecated REQUEST STATUS HISTORY.
RQO Deprecated REQUEST OBJECT INFORMATION.
RQU Deprecated REQUEST OBJECT TARGET USER INFORMATION.
RQY Deprecated Request Organizations Requiring Resolution.
RQZ Deprecated Request Users Requiring Resolution.
RUG Deprecated List to define the administrators for each Request.
APA Attestation To store Attestation process administrators.
APD Attestation To store Attestation process definition.
APT Attestation To store the Attestation tasks.
ATD Attestation To store Entitlement details for each Attestation task .
ATR Attestation To store Attestation requests.
RAO Attestation Resource audit objectives information.
LKU Lookup Lookup definition entries.
LKV Lookup Lookup values.
WIN Generic Windows table: Windows keys, descriptions, and class names.
XSD Metadata This table holds Xellerate System Data.
UWP Generic Window sequence, nesting in CarrierBase explorer for each user group.


Thank you,
Arihant Jain