Ram Kancharla's Oracle Fusion Middleware Blog

Thursday 10 May 2018

Unable to connect to Oracle MFT console using weblogic user & MFT source can't be deployed with a schedule- System Error MFT-5809

Issue1: Unable to login to MFT console with Weblogic user

Issue2: Oracle MFT source can't be deployed with a schedule- System Error MFT-5809

Error information:
oracle.as.scheduler.SchedulerUserAssertionException: Failed to authenticate user OracleSystemUserPlease make sure OracleSystemUser is a valid user or check server log to find more authentication details.

After a rigorous investigation, we identified the root cause of the issue. Any user from Default Authentication group can't be logged in without virtualization property in EM.

we found an interesting issue with LDAP configuration on setting up virtualize custom value to true in Identity store after following values.

user.login.attr

sAMAccountName

username.attr

sAMAccountName

As we are using internal weblogic authentication as well as LDAP authentication, we had issues with logging in with weblogic user for MFT console.

All this while we never had a situation that needs us to login and use internal Oraclesystemuser account. Hence we did not concentrate on this.

Now, we found the root cause that if we have 2 different authentication mechanisms, we will need to remove sAMAccountName values and only add virtualize=true.

This had resolved our problem of MFT using ESS scheduler with internal user OracleSystemUser. We are now able to deploy our schedules.

Resolution:

Add the virtualize=true in EM security and change the properties to sufficient.

navigation to change the properties:

Additional error information:

Happy Learning! Keep Sharing!

Friday 27 October 2017

FTP adapter failed to connect SFTP server using password in SOA 12.1.3 with Java7

Issue: FTP adapter failed to connect SFTP server using password in SOA 12.1.3 with Java7.

Description: BPEL composite is reading the file and write into another SFTP server folder path. We have created FTP adapter outbound connection and deployed the composites. When we try to test the SOA composite it is failed to connect to SFTP server using user id and password with SSH error.

FTP adapter Outbound connection details

Host: XX.XX.XX.XX

ListParserKey: UNIX

Password: XXXXXXX

Port: 22

ServerType: unix

username: XXXXXXXX

UseSftp: true

Remaining fields are default

Error log:

BINDING.JCA-12563

Exception occurred when binding was invoked.

Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Put' failed due to: JCA Binding Component connection issue.

JCA Binding Component is unable to create an outbound JCA (CCI) connection.

HRIS_Conn_In_Out:HR_Out [ Put_ptt::Put(opaque) ] : The JCA Binding Component was unable to establish an outbound JCA CCI connection due to the following issue: Error in establishing a session with SSH Server..

Error in establishing a session with SSH Server..

Unable to establish a session with the server.

Please ensure hostname and port specified to login to the server are correct.

The invoked JCA adapter raised a resource exception.

Please examine the above error message carefully to determine a resolution.

remoteFault xmlns="http://schemas.oracle.com/bpel/extension">

-<part name="summary">

Exception occurred when binding was invoked.
Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Put' failed due to: JCA Binding Component connection issue.
JCA Binding Component is unable to create an outbound JCA (CCI) connection.
HRIS_Conn_In_Out:HR_Out [ Put_ptt::Put(opaque) ] : The JCA Binding Component was unable to establish an outbound JCA CCI connection due to the following issue: Error in establishing a session with SSH Server..
Error in establishing a session with SSH Server..
Unable to establish a session with the server.
Please ensure hostname and port specified to login to the server are correct.

Please make sure that the JCA connection factory and any dependent connection factories have been configured with a sufficient limit for max connections. Please also make sure that the physical connection to the backend EIS is available and the backend itself is accepting connections.
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.

</summary>

</part>

-<part name="detail">

Failed to generate DH value [Unknown cause]

</detail>

</part>

-<part name="code">

<code>

null

</code>

</part>

</remoteFault>

We suspected the issue is still with com.maverick.ssh.components.jce.DiffieHellmanGroupExchangeSha1.performClientExchange(Unknown Source)

Below are the Chipher suits that are connecting to our SFTP vendor

ecdh-sha2-nistp521,ecdh-sha2-nistp384,ecdh-sha2-nistp256,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1,diffie-hellman-group-exchange-sha1

aes256-ctr,aes192-ctr,aes128-ctr,aes256-cbc,aes192-cbc,aes128-cbc,twofish-cbc,blowfish-cbc,3des-cbc,arcfour

hmac-sha2-512,hmac-sha2-256,hmac-sha1,hmac-sha1-96

Cipher suites with SHA384 and SHA256 are available only for TLS 1.2 or later.

We have added the Java cryptography library to Java 7 but it did not resolved the issue

Solution:

The problem is the prime size. The maximum-acceptable size that Java accepts is 1024 bits. This is a known issue (see JDK-6521495).

The bug report that I linked to mentions a workaround using BouncyCastle's JCE implementation. Hopefully that should work for you.

Diffie-Hellman (DH) 2048Footnote 1 Keysize must either be a multiple of 64, ranging from 512 to 1024 (inclusively), or 2048.Footnote 1

DSA 1024 Keysize must be a multiple of 64, ranging from 512 to 1024 (inclusively).

Footnote 1Diffie-Hellman key pair generation supports key sizes up to 2048 bits since Java SE 7u91. Prior to Java SE 7u91, the default key size was 1024.

Upon rigorous research; This issue is found as a limitation of cipher files with Java version below 1.7_131.

JDK-8186290 :

Release Note: Add support for the SHA224withDSA and SHA256withDSA signature algorithms and DSA keys with sizes up to 2048 bits

We have upgraded the Java version to 1.7.0_161 as it is the stable and final version with 1.7 version which is supported by SOA 12.1.3 version.

-bash-4.1$ java -version

java version "1.7.0_161"

Java(TM) SE Runtime Environment (build 1.7.0_161-b13)

Java HotSpot(TM) 64-Bit Server VM (build 24.161-b13, mixed mode)

As per the certification, JDK 8 is not certified to work with SOA 12.1.3. The compatible version is from 1.7.0_99 - 1.7.0_101. We upgraded the java to 1.7.0_161 and it worked.

Additional Resources:

After Enabling SSL TLS1.2 Protocol, The SSL Handshake Fails With: Could Not Generate DH Keypair ( Doc ID 2050352.1 )

WebLogic Server Fails To Establish SSL Handshake With HTTPS Endpoint That Uses Public Key Of 4096 Bits ( Doc ID 2299740.1 )

SHA2 Support For FTP Adapter ( Doc ID 2253315.1 )

OSB SFTP Transport or FTP Adapter do not support AES128-CTR, AES192-CTR or AES256-CTR ( Doc ID 2021603.1 )

SOA 11g: SFTP Adapter returns error establishing an SSH session, 'BINDING.JCA-11445/11447' ( Doc ID 1486775.1 )

Understanding SSL Protocols and Configuring Cipher Suites for Oracle WebLogic Server ( Doc ID 1484562.1 )

https://docs.oracle.com/javase/7/docs/technotes/guides/security/SunProviders.html

http://bugs.java.com/bugdatabase/view_bug.do?bug_id=7044060

https://docs.oracle.com/cd/E19830-01/819-4712/ablsc/index.html

http://httpd.apache.org/docs/current/ssl/ssl_faq.html#javadh

Happy learning.! Keep Sharing.!

Ram.

Oracle SOA 12.1.3 dehydration tables list in one place

Hello,

I Just wanted to keep the dehydration tables in one place I have mentioned every table in all the schemas.

If you need specific information you need to join multiple tables as per your requirement.
Here is the list of dehydration tables.

TNAME TABTYPE
ACTIVITY_PERF VIEW
ACTIVITY_SENSOR_VALUES TABLE
ADMIN_LIST_CI VIEW
ADMIN_LIST_CX VIEW
ADMIN_LIST_TD VIEW
ADMIN_LIST_TDEF VIEW
ADMIN_LIST_WI VIEW
AG_INSTANCE TABLE
AIA_CAVSCALLBACKJMSQTAB TABLE
AIA_ERROR_FLEX_FIELD TABLE
AIA_ERROR_MONITOR TABLE
AIA_ERROR_NOTIFICATIONS TABLE
AIA_SYSTEMS TABLE
AQ$AIA_CAVSCALLBACKJMSQTAB VIEW
AQ$B2B_BAM_QTAB VIEW
AQ$EDN_AQJMS_TOPIC_TABLE VIEW
AQ$EDN_AQJMS_TOPIC_TABLE_R VIEW
AQ$EDN_AQJMS_TOPIC_TABLE_S VIEW
AQ$EDN_EVENT_QUEUE_TABLE VIEW
AQ$EDN_EVENT_QUEUE_TABLE_R VIEW
AQ$EDN_EVENT_QUEUE_TABLE_S VIEW
AQ$EDN_OAOO_DELIVERY_TABLE VIEW
AQ$EDN_OAOO_DELIVERY_TABLE_R VIEW
AQ$EDN_OAOO_DELIVERY_TABLE_S VIEW
AQ$IP_QTAB VIEW
AQ$IP_QTAB_R VIEW
AQ$IP_QTAB_S VIEW
AQ$OSB_EMAIL_TRANSPORT_TBL VIEW
AQ$OSB_FILE_TRANSPORT_TBL VIEW
AQ$OSB_FTP_TRANSPORT_TBL VIEW
AQ$OSB_PURGE_TBL VIEW
AQ$OSB_REPORTING_ERROR_TBL VIEW
AQ$OSB_REPORTING_TBL VIEW
AQ$OSB_SFTP_TRANSPORT_TBL VIEW
AQ$TASK_NOTIFICATION_Q_T VIEW
AQ$_AIA_CAVSCALLBACKJMSQTAB_F VIEW
AQ$_B2B_BAM_QTAB_F VIEW
AQ$_EDN_AQJMS_TOPIC_TABLE_F VIEW
AQ$_EDN_AQJMS_TOPIC_TABLE_G TABLE
AQ$_EDN_AQJMS_TOPIC_TABLE_H TABLE
AQ$_EDN_AQJMS_TOPIC_TABLE_I TABLE
AQ$_EDN_AQJMS_TOPIC_TABLE_L TABLE
AQ$_EDN_AQJMS_TOPIC_TABLE_S TABLE
AQ$_EDN_AQJMS_TOPIC_TABLE_T TABLE
AQ$_EDN_EVENT_QUEUE_TABLE_F VIEW
AQ$_EDN_EVENT_QUEUE_TABLE_G TABLE
AQ$_EDN_EVENT_QUEUE_TABLE_H TABLE
AQ$_EDN_EVENT_QUEUE_TABLE_I TABLE
AQ$_EDN_EVENT_QUEUE_TABLE_L TABLE
AQ$_EDN_EVENT_QUEUE_TABLE_S TABLE
AQ$_EDN_EVENT_QUEUE_TABLE_T TABLE
AQ$_EDN_OAOO_DELIVERY_TABLE_F VIEW
AQ$_EDN_OAOO_DELIVERY_TABLE_G TABLE
AQ$_EDN_OAOO_DELIVERY_TABLE_H TABLE
AQ$_EDN_OAOO_DELIVERY_TABLE_I TABLE
AQ$_EDN_OAOO_DELIVERY_TABLE_L TABLE
AQ$_EDN_OAOO_DELIVERY_TABLE_S TABLE
AQ$_EDN_OAOO_DELIVERY_TABLE_T TABLE
AQ$_IP_QTAB_F VIEW
AQ$_IP_QTAB_G TABLE
AQ$_IP_QTAB_H TABLE
AQ$_IP_QTAB_I TABLE
AQ$_IP_QTAB_L TABLE
AQ$_IP_QTAB_S TABLE
AQ$_IP_QTAB_T TABLE
AQ$_OSB_EMAIL_TRANSPORT_TBL_F VIEW
AQ$_OSB_FILE_TRANSPORT_TBL_F VIEW
AQ$_OSB_FTP_TRANSPORT_TBL_F VIEW
AQ$_OSB_PURGE_TBL_F VIEW
AQ$_OSB_REPORTING_ERROR_TBL_F VIEW
AQ$_OSB_REPORTING_TBL_F VIEW
AQ$_OSB_SFTP_TRANSPORT_TBL_F VIEW
AQ$_TASK_NOTIFICATION_Q_T_F VIEW
ATTACHMENT TABLE
ATTACHMENT_REF TABLE
AUDIT_COUNTER TABLE
AUDIT_DETAILS TABLE
AUDIT_TRAIL TABLE
B2B_APP_MESSAGE TABLE
B2B_AUDIT_TEMP TABLE
B2B_BAM_QTAB TABLE
B2B_BATCH_EVENT TABLE
B2B_BUSINESS_MESSAGE TABLE
B2B_BUSINESS_MESSAGE_RETRY TABLE
B2B_CONTROL_NUMBER TABLE
B2B_CONTROL_NUMBER_SET TABLE
B2B_CTL_NUMBER TABLE
B2B_DATA_STORAGE TABLE
B2B_EXT_BUSINESS_MESSAGE TABLE
B2B_GROUP_STATUS TABLE
B2B_HA_REGISTRY TABLE
B2B_INSTANCEMESSAGE VIEW
B2B_LIFECYCLE TABLE
B2B_LOCK_REGISTRY TABLE
B2B_PARAMETER TABLE
B2B_PENDING_MESSAGE TABLE
B2B_PURGE_TEMP_AM TABLE
B2B_PURGE_TEMP_BM TABLE
B2B_PURGE_TEMP_WM TABLE
B2B_RESEQUENCER_MESSAGE TABLE
B2B_RES_CONTAINERID_LEASE TABLE
B2B_SEQUENCE_MANAGER TABLE
B2B_SERVICE_DETAIL TABLE
B2B_STREAMSTORE TABLE
B2B_SYSTEM_MV TABLE
B2B_TRANSPORT_MANAGER TABLE
B2B_WIRE_MESSAGE TABLE
BEAM_ALERT_ESCALATION TABLE
BEAM_ALERT_RULE TABLE
BEAM_COLUMN TABLE
BEAM_DATAOBJECT TABLE
BEAM_FLEXTABLE TABLE
BEAM_FLEX_1 TABLE
BEAM_FLEX_10 TABLE
BEAM_FLEX_11 TABLE
BEAM_FLEX_12 TABLE
BEAM_FLEX_13 TABLE
BEAM_FLEX_14 TABLE
BEAM_FLEX_15 TABLE
BEAM_FLEX_16 TABLE
BEAM_FLEX_17 TABLE
BEAM_FLEX_18 TABLE
BEAM_FLEX_2 TABLE
BEAM_FLEX_29 TABLE
BEAM_FLEX_3 TABLE
BEAM_FLEX_37 TABLE
BEAM_FLEX_38 TABLE
BEAM_FLEX_4 TABLE
BEAM_FLEX_41 TABLE
BEAM_FLEX_42 TABLE
BEAM_FLEX_43 TABLE
BEAM_FLEX_46 TABLE
BEAM_FLEX_5 TABLE
BEAM_FLEX_51 TABLE
BEAM_FLEX_52 TABLE
BEAM_FLEX_53 TABLE
BEAM_FLEX_54 TABLE
BEAM_FLEX_6 TABLE
BEAM_FLEX_7 TABLE
BEAM_FLEX_8 TABLE
BEAM_FLEX_9 TABLE
BEAM_NAMEMAPPING TABLE
BEAM_PROPERTY TABLE
BEAM_SEQUENCE TABLE
BEAM_TRANSACTION_CONTEXT TABLE
BEAM_VIEW_1 VIEW
BEAM_VIEW_10 VIEW
BEAM_VIEW_11 VIEW
BEAM_VIEW_12 VIEW
BEAM_VIEW_13 VIEW
BEAM_VIEW_14 VIEW
BEAM_VIEW_15 VIEW
BEAM_VIEW_16 VIEW
BEAM_VIEW_17 VIEW
BEAM_VIEW_18 VIEW
BEAM_VIEW_19 VIEW
BEAM_VIEW_2 VIEW
BEAM_VIEW_20 VIEW
BEAM_VIEW_21 VIEW
BEAM_VIEW_22 VIEW
BEAM_VIEW_23 VIEW
BEAM_VIEW_24 VIEW
BEAM_VIEW_25 VIEW
BEAM_VIEW_26 VIEW
BEAM_VIEW_27 VIEW
BEAM_VIEW_28 VIEW
BEAM_VIEW_29 VIEW
BEAM_VIEW_3 VIEW
BEAM_VIEW_30 VIEW
BEAM_VIEW_31 VIEW
BEAM_VIEW_32 VIEW
BEAM_VIEW_33 VIEW
BEAM_VIEW_34 VIEW
BEAM_VIEW_35 VIEW
BEAM_VIEW_36 VIEW
BEAM_VIEW_37 VIEW
BEAM_VIEW_38 VIEW
BEAM_VIEW_4 VIEW
BEAM_VIEW_41 VIEW
BEAM_VIEW_42 VIEW
BEAM_VIEW_43 VIEW
BEAM_VIEW_46 VIEW
BEAM_VIEW_5 VIEW
BEAM_VIEW_51 VIEW
BEAM_VIEW_52 VIEW
BEAM_VIEW_53 VIEW
BEAM_VIEW_54 VIEW
BEAM_VIEW_6 VIEW
BEAM_VIEW_7 VIEW
BEAM_VIEW_8 VIEW
BEAM_VIEW_9 VIEW
BPELNOTIFICATION TABLE
BPELNOTIFICATION_FILTERMSGS TABLE
BPELNOTIFICATION_INVALADDRS TABLE
BPEL_ACTIVITY_SENSOR_VALUES VIEW
BPEL_FAULTS_VW VIEW
BPEL_FAULT_SENSOR_VALUES VIEW
BPEL_PROCESS_INSTANCES VIEW
BPEL_VARIABLE_ANALYSIS_REPORT VIEW
BPEL_VARIABLE_SENSOR_VALUES VIEW
BPM_ACTIVITY TABLE
BPM_ACTIVITY_DEFINITION_V VIEW
BPM_ACTIVITY_INSTANCE TABLE
BPM_ACTIVITY_INSTANCE_V VIEW
BPM_ACTIVITY_PERFORMANCE_V VIEW
BPM_ACTIVITY_PROPERTY TABLE
BPM_APP_ROLE_OU_CAL_ASSOC TABLE
BPM_AUDIT_QUERY TABLE
BPM_AUDIT_QUERY_METADATA TABLE
BPM_AUDIT_QUERY_VARMD_EXT1 TABLE
BPM_AUDIT_QUERY_VARVALS_EXT1 TABLE
BPM_AUDIT_QUERY_VAR_MD TABLE
BPM_AUDIT_QUERY_VAR_RANGES TABLE
BPM_AUDIT_SEQUENCE TABLE
BPM_BAC_METADATA_STORE TABLE
BPM_BAC_SESSION TABLE
BPM_BUSINESS_CONSTANT TABLE
BPM_BUSINESS_CONSTANT_OU_ASSOC TABLE
BPM_CALENDAR_RULE TABLE
BPM_CALENDAR_WORKDAY TABLE
BPM_CASE TABLE
BPM_CASE_ACTIVITIES TABLE
BPM_CASE_ATTRIBUTES TABLE
BPM_CASE_DATA TABLE
BPM_CUBE_ACTIVITY TABLE
BPM_CUBE_ACTIVITY_INSTANCE TABLE
BPM_CUBE_ACTIVITY_PROPERTY TABLE
BPM_CUBE_ACTIVITY_SEQFLOW TABLE
BPM_CUBE_AUDITINSTANCE TABLE
BPM_CUBE_AUDITINST_FLEX01 TABLE
BPM_CUBE_GLOBALCREATETASK TABLE
BPM_CUBE_LASTSNAPSHOT TABLE
BPM_CUBE_LOCK TABLE
BPM_CUBE_NAMETAB TABLE
BPM_CUBE_NAMETAB_RANGE TABLE
BPM_CUBE_ORGUNIT TABLE
BPM_CUBE_ORGUNIT_ASSOC TABLE
BPM_CUBE_PARTNER_SERVICE TABLE
BPM_CUBE_PROCESS TABLE
BPM_CUBE_PROCESSPERFORMANCE TABLE
BPM_CUBE_PROCESS_PARTNER TABLE
BPM_CUBE_PROCESS_PARTNER_SVC_V VIEW
BPM_CUBE_PROCPERF_FLEX01 TABLE
BPM_CUBE_ROLE TABLE
BPM_CUBE_SEQUENCE TABLE
BPM_CUBE_TASKPERFORMANCE TABLE
BPM_CUBE_TASKPERF_FLEX01 TABLE
BPM_CUBE_WORKLOAD TABLE
BPM_CUBE_WORKLOAD_FLEX01 TABLE
BPM_CUSTOM_APPS TABLE
BPM_EXT_USER_PROPERTY_GLOBAL TABLE
BPM_EXT_USER_PROPERTY_VALUE TABLE
BPM_EXT_USER_PROP_AVLBL_COL TABLE
BPM_FISCAL_YEAR TABLE
BPM_FISCAL_YEAR_DIVISION TABLE
BPM_HOLIDAYS TABLE
BPM_HOLIDAY_RULE TABLE
BPM_LOGICAL_PEOPLE_GROUP TABLE
BPM_LPG_MEMBER TABLE
BPM_MEASUREMENT_ACTIONS TABLE
BPM_MEASUREMENT_ACTION_EXCEPS TABLE
BPM_MEASUREMENT_ACTION_SEQ TABLE
BPM_OPTIMIZATION_DATA TABLE
BPM_OPT_COMPLETION_DATE_DATA TABLE
BPM_OPT_DATA_SEQUENCE TABLE
BPM_ORGANIZATIONAL_UNIT TABLE
BPM_OU_MANAGER TABLE
BPM_OU_USER TABLE
BPM_PARTNER_SERVICE TABLE
BPM_PML_HS TABLE
BPM_PML_HS_BPM_PML_HS_ITEM TABLE
BPM_PML_HS_ITEM TABLE
BPM_PML_SEQUENCE TABLE
BPM_PP_ENTITY_GS_MAP TABLE
BPM_PRESENTATION TABLE
BPM_PRESENTATION_GRANT TABLE
BPM_PROCESS TABLE
BPM_PROCESS_DEFINITION_V VIEW
BPM_PROCESS_INSTANCE_V VIEW
BPM_PROCESS_PARTNER TABLE
BPM_PROCESS_PARTNER_SERVICE_V VIEW
BPM_PROCESS_PERFORMANCE_V VIEW
BPM_PROJECTSHAREDATA TABLE
BPM_PROJECTSHAREDATA_SEQ TABLE
BPM_PV_ACTIVITY_DEFINITION_V SYNONYM
BPM_PV_ACTIVITY_V SYNONYM
BPM_PV_CASE_ACTIVITY_DEF_V SYNONYM
BPM_PV_CASE_ACTIVITY_V SYNONYM
BPM_PV_CASE_STAKE_HOLDER_MEM_V SYNONYM
BPM_PV_CASE_STAKE_HOLDER_V SYNONYM
BPM_PV_CASE_V SYNONYM
BPM_PV_COMPOSITE_DEFINITION_V SYNONYM
BPM_PV_HWF_ASSIGNMENT_V SYNONYM
BPM_PV_HWF_TASK_DEFINITION_V SYNONYM
BPM_PV_HWF_TASK_V SYNONYM
BPM_PV_PROCESS_DEFINITION_V SYNONYM
BPM_PV_PROCESS_V SYNONYM
BPM_PV_ROLE_DEFINITION_V SYNONYM
BPM_ROLE_DEFINITION_V VIEW
BPM_RT_FLOW_ELEMENT TABLE
BPM_RT_INSTANCE_CREATION TABLE
BPM_RT_SEQUENCE TABLE
BPM_RT_SEQUENCE_FLOW TABLE
BPM_RT_SNAPSHOT TABLE
BPM_SEQUENCE TABLE
BPM_USERAPPLICATIONDATA TABLE
BPM_USERAPPLICATIONDATA_GRANT TABLE
BRDECISIONFAULT TABLE
BRDECISIONINSTANCE TABLE
BRDECISIONUNITOFWORK TABLE
BRIDGE_INSTANCE TABLE
BRSEQUENCE TABLE
BULK_RECOVERY_JOB TABLE
CAVS_DEFINITIONS TABLE
CAVS_DEFINITION_AUDITS TABLE
CAVS_DEFINITION_NSXPATHS TABLE
CAVS_DEFINITION_XPATHS TABLE
CAVS_DEFINITION_XPATH_VW VIEW
CAVS_DEFINITION_XREFS TABLE
CAVS_GRPDEFINITIONS TABLE
CAVS_GRPDEFINITION_DEFINITIONS TABLE
CAVS_GRPINSTANCES TABLE
CAVS_GRPINSTANCE_INSTANCES TABLE
CAVS_INSTANCES TABLE
CAVS_INSTANCE_NSXPATHS TABLE
CAVS_INSTANCE_XPATHS TABLE
CAVS_INSTANCE_XREFS TABLE
CAVS_INSTANCE_XREF_VW VIEW
CAVS_ROUTING_SETUP TABLE
CAVS_ROUTING_SETUP_DETAILS TABLE
CAVS_SCHEDULER TABLE
CI_AVG_INV_PROCESSING_DELAY VIEW
CI_AVG_PROCESSING_TIME VIEW
CI_INDEXES TABLE
CLUSTER_MASTER TABLE
CLUSTER_NODE TABLE
CM_ACTIVITY_ATTRIBUTE TABLE
CM_ACTIVITY_CASE_DEFINITION TABLE
CM_ACTIVITY_CATEGORY_DEFN TABLE
CM_ACTIVITY_CORRELATION TABLE
CM_ACTIVITY_DEFINITION TABLE
CM_ACTIVITY_INSTANCE TABLE
CM_CASE TABLE
CM_CASE_DATA TABLE
CM_CASE_DEFINITION TABLE
CM_CASE_DISPLAY TABLE
CM_CASE_DOCUMENT TABLE
CM_CASE_EVENT TABLE
CM_CASE_FLEX_FIELD TABLE
CM_CASE_HEADER TABLE
CM_CASE_MILESTONE TABLE
CM_CASE_MILESTONE_DEFINITION TABLE
CM_CASE_OBJECT TABLE
CM_CASE_STAKE_HOLDER TABLE
CM_CASE_STAKE_HOLDER_MEMBER TABLE
CM_COMMENT TABLE
CM_FABRIC_HEADER_PROPERTY TABLE
CM_LINKED_CASE TABLE
CM_PROPERTY_BAG TABLE
CM_RULE TABLE
CM_RULE_EDIT TABLE
CM_SEQUENCE_TABLE TABLE
CM_TRANSLATION TABLE
COMPONENT_INSTANCE TABLE
COMPONENT_INSTANCE_PURGE TABLE
COMPOSITE_FAULT_PURGE TABLE
COMPOSITE_INSTANCE TABLE
COMPOSITE_INSTANCE_ASSOC TABLE
COMPOSITE_INSTANCE_FAULT TABLE
COMPOSITE_INSTANCE_PURGE TABLE
COMPOSITE_SENSOR_VALUE TABLE
CUBE_INSTANCE TABLE
CUBE_PROCESS_BREAKPOINT TABLE
CUBE_SCOPE TABLE
DBG_WI VIEW
DECISIONCOMPONENTERRORVIEW VIEW
DECISIONCOMPONENTINSTANCEVIEW VIEW
DLV_AGGREGATION TABLE
DLV_MESSAGE TABLE
DLV_SUBSCRIPTION TABLE
DOCUMENTDEFINITION TABLE
DOCUMENTINSTANCE TABLE
DOCUMENTPACKAGEDEFINITION TABLE
DOCUMENTPACKAGEINSTANCE TABLE
DOCUMENTPACKAGEPROCESS TABLE
DOCUMENTPACKAGEPROPERTIES TABLE
DOCUMENTPACKAGEPROPERTIESMAP TABLE
DOCUMENT_CI_REF TABLE
DOCUMENT_DLV_MSG_REF TABLE
DS_RESOLVED VIEW
DS_UNRESOLVED VIEW
ECID_PURGE TABLE
EDN_AQJMS_TOPIC_TABLE TABLE
EDN_CLUSTERS TABLE
EDN_EVENT_AGENTS TABLE
EDN_EVENT_ERROR_STORE TABLE
EDN_EVENT_QUEUE_TABLE TABLE
EDN_EVENT_SUBSCRIPTIONS TABLE
EDN_LOG_ENABLED TABLE
EDN_LOG_MESSAGES TABLE
EDN_OAOO_DELIVERY_TABLE TABLE
EDN_RETRY_COUNT TABLE
EIS_CONNECTION_DOWN_TIME TABLE
FAULT_ALERT TABLE
FAULT_NOTIFICATION_RULE TABLE
FAULT_SENSOR_VALUES TABLE
FILEADAPTER_IN TABLE
FILEADAPTER_MUTEX TABLE
FILEADAPTER_TRANSACTION_LOG TABLE
HEADERS_PROPERTIES TABLE
ID_RANGE TABLE
INSTANCE_PAYLOAD TABLE
INSTANCE_PERF VIEW
IP_QTAB TABLE
JCA_NATIVE_CORRELATION TABLE
JOB_FLOW_CONTROL TABLE
LABEL_VERSION_PCBPEL TABLE
LDAPADAPTER_IN TABLE
LOAN_CUSTOMER TABLE
MEDIATOR_AUDIT_DOCUMENT TABLE
MEDIATOR_CALLBACK TABLE
MEDIATOR_CASE_DETAIL TABLE
MEDIATOR_CASE_DETAIL_V VIEW
MEDIATOR_CASE_INSTANCE TABLE
MEDIATOR_CONTAINERID_LEASE TABLE
MEDIATOR_CORRELATION TABLE
MEDIATOR_DEFERRED_MESSAGE TABLE
MEDIATOR_GROUP_STATUS TABLE
MEDIATOR_INSTANCE TABLE
MEDIATOR_PAYLOAD TABLE
MEDIATOR_RESEQUENCER_MESSAGE TABLE
MEDIATOR_RES_CONTAINERID_LEASE TABLE
MEDIATOR_SERVICE_DETAIL TABLE
MESSAGE_STATISTICS TABLE
MESSAGE_STATS_TEMP TABLE
MFT_CALLOUT_INSTANCE TABLE
MFT_DATA_STORAGE TABLE
MFT_ERROR_INFO TABLE
MFT_ES_AUTHORIZATION TABLE
MFT_ES_PORT_ASSIGNMENT TABLE
MFT_PAUSED_INSTANCE_INFO TABLE
MFT_RCU_PURGE TABLE
MFT_RESUBMIT_INFO TABLE
MFT_RETRY_INFO TABLE
MFT_SECURITY_INFO TABLE
MFT_SOURCE_LIFECYCLE TABLE
MFT_SOURCE_MESSAGE TABLE
MFT_SOURCE_UNPROCESSED TABLE
MFT_TARGET_INSTANCE TABLE
MFT_TARGET_LIFECYCLE TABLE
MFT_TARGET_MESSAGE TABLE
MFT_TRANSFER_INSTANCE TABLE
MFT_TRANSFER_LIFECYCLE TABLE
MFT_TRANSFER_SCHEDULE TABLE
MFT_TRANSFER_TARGET_REL TABLE
MLOG$_MFT_DATA_STORAGE TABLE
MLOG$_MFT_SOURCE_MESSAGE TABLE
MLOG$_MFT_TARGET_INSTANCE TABLE
MLOG$_MFT_TARGET_MESSAGE TABLE
MLOG$_MFT_TRANSFER_INSTANC TABLE
MV_MFT_PAYLOAD_INFO TABLE
MV_MFT_SOURCE_INFO TABLE
MV_MFT_SOURCE_MESSAGE TABLE
MV_MFT_TARGET_INFO TABLE
MV_MFT_TRANSFER TABLE
MV_MFT_TRANSFER_COUNT_INFO TABLE
NATIVE_CORRELATION TABLE
OSB_EMAIL_TRANSPORT_TBL TABLE
OSB_FILE_TRANSPORT_TBL TABLE
OSB_FTP_TRANSPORT_TBL TABLE
OSB_GROUP_STATUS TABLE
OSB_MSG TABLE
OSB_PURGE_TBL TABLE
OSB_REPORTING_ERROR_TBL TABLE
OSB_REPORTING_TBL TABLE
OSB_RESEQUENCER_MESSAGE TABLE
OSB_RES_CONTAINERID_LEASE TABLE
OSB_SERVICE_DETAIL TABLE
OSB_SFTP_TRANSPORT_TBL TABLE
PC_OWF TABLE
PC_TASK TABLE
PC_TASKASSIGNEE TABLE
PC_TASKASSIGNEEHISTORY TABLE
PC_TASKATTACHMENT TABLE
PC_TASKHISTORY TABLE
PC_TASKPAYLOAD TABLE
PRUNE_RUNNING_INSTS TABLE
REFERENCE_INSTANCE TABLE
REFERENCE_INSTANCE_PURGE TABLE
REJECTED_MESSAGE TABLE
REJECTED_MESSAGE_PURGE TABLE
REJECTED_MSG_NATIVE_PAYLOAD TABLE
RESOURCES TABLE
RM_LOCALIDS TABLE
RM_SEQUENCES TABLE
RM_UNACKED_MESSAGES TABLE
ROLES TABLE
RUPD$_MFT_DATA_STORAGE TABLE
RUPD$_MFT_SOURCE_MESSAGE TABLE
RUPD$_MFT_TARGET_INSTANCE TABLE
RUPD$_MFT_TARGET_MESSAGE TABLE
RUPD$_MFT_TRANSFER_INSTANC TABLE
SCA_ASYNC_CPNT_STATE TABLE
SCA_ATTACHMENT_REF TABLE
SCA_COMMON_FAULT TABLE
SCA_ENTITY TABLE
SCA_FLOW_ASSOC TABLE
SCA_FLOW_INSTANCE TABLE
SCA_FLOW_TO_CPST TABLE
SCA_META_DATA TABLE
SCA_PARTITION TABLE
SCA_REJECTED_MESSAGE TABLE
SCA_SENSOR_VALUE TABLE
SCA_SEQUENCE TABLE
SENSOR_SEQUENCE TABLE
SEQUENCE TABLE
SOAQTZ_BLOB_TRIGGERS TABLE
SOAQTZ_CALENDARS TABLE
SOAQTZ_CRON_TRIGGERS TABLE
SOAQTZ_FIRED_TRIGGERS TABLE
SOAQTZ_JOB_DETAILS TABLE
SOAQTZ_JOB_LISTENERS TABLE
SOAQTZ_LOCKS TABLE
SOAQTZ_PAUSED_TRIGGER_GRPS TABLE
SOAQTZ_SCHEDULER_STATE TABLE
SOAQTZ_SIMPLE_TRIGGERS TABLE
SOAQTZ_TRIGGERS TABLE
SOAQTZ_TRIGGER_LISTENERS TABLE
SOA_PURGE_ALERT TABLE
SOA_PURGE_HISTORY TABLE
SPACES TABLE
SYS_IOT_OVER_109697 TABLE
SYS_IOT_OVER_109799 TABLE
SYS_IOT_OVER_109828 TABLE
SYS_IOT_OVER_109861 TABLE
TASK_NOTIFICATION_Q_T TABLE
TEMP11G_CUBE_INSTANCE TABLE
TEMP11G_DOCUMENT_CI_REF TABLE
TEMP11G_DOCUMENT_DLV_MSG_REF TABLE
TEMP11G_WFTASK_PURGE TABLE
TEMP11G_XML_DOCUMENT TABLE
TEMP_BRDECISION_INSTANCE TABLE
TEMP_BRDECISION_INSTANCE_GLB TABLE
TEMP_COMPOSITEDN_UPGRADE TABLE
TEMP_COMPOSITEDN_UPGRADE_ALL TABLE
TEMP_CUBE_INSTANCE TABLE
TEMP_FLOWID_PURGE TABLE
TEMP_MEDIATOR_DEFERRED TABLE
TEMP_MEDIATOR_DEFERRED_GLB TABLE
TEMP_MEDIATOR_INSTANCE TABLE
TEMP_MEDIATOR_RESEQUENCER TABLE
TEMP_MEDIATOR_RESEQUENCER_GLB TABLE
TEMP_PROCESSED_CIKEY TABLE
TEMP_PROCESSED_MI TABLE
TEMP_UPGRADE_BRDECISION TABLE
TEMP_UPGRADE_CI TABLE
TEMP_UPGRADE_CPST_INST TABLE
TEMP_UPGRADE_DLV_ECID_MAP TABLE
TEMP_UPGRADE_DLV_MSG TABLE
TEMP_UPGRADE_ECID TABLE
TEMP_UPGRADE_MCDV TABLE
TEMP_UPGRADE_MCI TABLE
TEMP_UPGRADE_MI TABLE
TEMP_UPGRADE_WFTASK TABLE
TEMP_UPGRADE_WKITM_CI TABLE
TEMP_WFTASK_PURGE TABLE
TEMP_WFTASK_PURGE_GLB TABLE
TENANTCATEGORIES TABLE
TENANTROLES TABLE
TENANTS TABLE
TEST_DEFINITIONS TABLE
TEST_DETAILS TABLE
TEST_INSTANCE TABLE
TRS_BRDECISION_INSTANCE TABLE
TRS_COMPONENT_INSTANCE TABLE
TRS_COMPOSITE_INSTANCE TABLE
TRS_COMPOSITE_INSTANCE_FAULT TABLE
TRS_CUBE_INSTANCE TABLE
TRS_DOCUMENT_DLV_MSG_REF TABLE
TRS_INSTANCE_PAYLOAD TABLE
TRS_MEDIATOR_GROUP_STATUS TABLE
TRS_MEDIATOR_INSTANCE TABLE
TRS_MEDIATOR_PAYLOAD TABLE
TRS_MEDIATOR_PAYLOAD_TEMP TABLE
TRS_MEDIATOR_RESEQ_MESSAGE TABLE
TRS_PARAMETER TABLE
TRS_REFERENCE_INSTANCE TABLE
TRS_REJECTED_MESSAGE TABLE
TRS_SOA_ECID TABLE
TRS_WFTASK TABLE
TRS_XML_DOCUMENT TABLE
UPGRADE_CURRENT_SEQUENCE TABLE
UPGRADE_CURRENT_SEQUENCE_TEMP TABLE
UPGRADE_ERROR_LOG TABLE
UPGRADE_INFO TABLE
UPGRADE_INJECTION TABLE
UPGRADE_OPEN_ECIDS_STATUS TABLE
UPGRADE_PARAMETER_TABLE TABLE
UPGRADE_PROGRESS_LOG TABLE
USERS TABLE
USERSROLES TABLE
VARIABLE_SENSOR_VALUES TABLE
VERIFY_BPEL_GROUP1 TABLE
VERIFY_DC_GROUP2 TABLE
VERIFY_DL_GROUP1A TABLE
VERIFY_FABRIC_GROUP1 TABLE
VERIFY_GROUP1 TABLE
VERIFY_MEDIATOR_GROUP1 TABLE
VERIFY_MP_GROUP2 TABLE
VERIFY_WORKFLOW_GROUP1 TABLE
VERSION TABLE
V_MFT_DELIVERY_TIME_INFO VIEW
V_MFT_SOURCE_PAYLOAD_INFO VIEW
V_MFT_SOURCE_TIME_TAKEN_INFO VIEW
V_MFT_TGT_PAYLOAD_INFO VIEW
WFAPPROVALGROUPMEMBERS TABLE
WFAPPROVALGROUPS TABLE
WFASSIGNEE TABLE
WFATTACHMENT TABLE
WFATTRIBUTELABELMAP TABLE
WFATTRIBUTELABELUSAGE TABLE
WFCERTAUTHORITY TABLE
WFCERTIFICATE TABLE
WFCERTIFICATEREVOKED TABLE
WFCOLLECTIONTARGET TABLE
WFCOMMENTS TABLE
WFEVIDENCE TABLE
WFHEADERPROPS TABLE
WFMESSAGEATTRIBUTE TABLE
WFNOTIFICATION TABLE
WFNOTIFICATIONMESSAGES TABLE
WFNOTIFICATIONSTATUS TABLE
WFPRODUCTIVITY_VIEW VIEW
WFREVIEWER TABLE
WFROUTINGSLIP TABLE
WFRULEDICTIONARY TABLE
WFTASK TABLE
WFTASKAGGREGATION TABLE
WFTASKASSIGNMENTHISTORY_VIEW VIEW
WFTASKASSIGNMENTSTATISTIC TABLE
WFTASKCYCLETIME_VIEW VIEW
WFTASKDISPLAY TABLE
WFTASKERROR TABLE
WFTASKHISTORY TABLE
WFTASKHISTORY_TL TABLE
WFTASKMETADATA TABLE
WFTASKPRIORITY_VIEW VIEW
WFTASKSEQUENCECHANGES TABLE
WFTASKTIMER TABLE
WFTASK_TL TABLE
WFUNATTENDEDTASKS_VIEW VIEW
WFUSERPREFERENCE TABLE
WFUSERTASKVIEW TABLE
WFUSERTASKVIEWGRANT TABLE
WFUSERVACATION TABLE
WI_EXPIRABLE VIEW
WI_EXPIRABLE_CLUSTER VIEW
WI_FAULT TABLE
WLI_QS_REPORT_ATTRIBUTE TABLE
WLI_QS_REPORT_DATA TABLE
WORK_ITEM TABLE
XML_DOCUMENT TABLE
XML_DOCUMENT_REF TABLE
XREF_DATA TABLE
XREF_DELETED_DATA TABLE

DEV_ESS
TNAME TABTYPE

ASYNC_ALLOCATIONS TABLE
ASYNC_LIMITS TABLE
COMMAND_WORK TABLE
CONFIGURED_BINDINGS TABLE
ESS_APP_CONFIGS TABLE
ESS_APP_REGISTRATION TABLE
ESS_CONFIG TABLE
ESS_COORD TABLE
ESS_DATA_SECURITY SYNONYM
ESS_TEMP_REQID TABLE
ESS_WS_ASYNC_INFO TABLE
EVENT_FILTER TABLE
EVENT_WORK TABLE
FAILED_EXECUTION_HISTORY TABLE
INCOMPATIBILITY_LOCK TABLE
JOB_INCOMPATIBILITY TABLE
META_CHANGE_NOTIFS TABLE
OPERATIVE_BINDINGS TABLE
PARAMETER_STASH TABLE
PTEMP_REQUEST TABLE
RECOVERY_DELETE TABLE
REQUEST_ATTRIBUTE TABLE
REQUEST_CONSTRAINT TABLE
REQUEST_CONTENT TABLE
REQUEST_CP TABLE
REQUEST_HISTORY TABLE
REQUEST_HISTORY_VIEW VIEW
REQUEST_INCOMPATIBILITY TABLE
REQUEST_METADATA TABLE
REQUEST_PROPERTY TABLE
REQUEST_PROPERTY_VIEW VIEW
SCHEMA_INFO TABLE
SCRATCH_QUERY_PRINCIPAL TABLE
UNTHROTTLED_WORKASSIGNMENTS TABLE
WAIT_QUEUE TABLE
WORK_UNITS TABLE

DEV_MFT
TNAME TABTYPE

FILEADAPTER_IN TABLE
FILEADAPTER_MUTEX TABLE
JCA_NATIVE_CORRELATION TABLE
LDAPADAPTER_IN TABLE
MFT_CALLOUT_INSTANCE TABLE
MFT_DATA_STORAGE TABLE
MFT_ERROR_INFO TABLE
MFT_ES_AUTHORIZATION TABLE
MFT_ES_PORT_ASSIGNMENT TABLE
MFT_PAUSED_INSTANCE_INFO TABLE
MFT_RCU_PURGE TABLE
MFT_RESUBMIT_INFO TABLE
MFT_RETRY_INFO TABLE
MFT_SECURITY_INFO TABLE
MFT_SOURCE_LIFECYCLE TABLE
MFT_SOURCE_MESSAGE TABLE
MFT_SOURCE_UNPROCESSED TABLE
MFT_TARGET_INSTANCE TABLE
MFT_TARGET_LIFECYCLE TABLE
MFT_TARGET_MESSAGE TABLE
MFT_TRANSFER_INSTANCE TABLE
MFT_TRANSFER_LIFECYCLE TABLE
MFT_TRANSFER_SCHEDULE TABLE
MFT_TRANSFER_TARGET_REL TABLE
MLOG$_MFT_DATA_STORAGE TABLE
MLOG$_MFT_SOURCE_MESSAGE TABLE
MLOG$_MFT_TARGET_INSTANCE TABLE
MLOG$_MFT_TARGET_MESSAGE TABLE
MLOG$_MFT_TRANSFER_INSTANC TABLE
MV_MFT_PAYLOAD_INFO TABLE
MV_MFT_SOURCE_INFO TABLE
MV_MFT_SOURCE_MESSAGE TABLE
MV_MFT_TARGET_INFO TABLE
MV_MFT_TRANSFER TABLE
MV_MFT_TRANSFER_COUNT_INFO TABLE
RUPD$_MFT_DATA_STORAGE TABLE
RUPD$_MFT_SOURCE_MESSAGE TABLE
RUPD$_MFT_TARGET_INSTANCE TABLE
RUPD$_MFT_TARGET_MESSAGE TABLE
RUPD$_MFT_TRANSFER_INSTANC TABLE

DEV_MDS

TNAME TABTYPE

MDS_ATTRIBUTES TABLE
MDS_COMPONENTS TABLE
MDS_DEPENDENCIES TABLE
MDS_DEPL_LINEAGES TABLE
MDS_LABELS TABLE
MDS_LARGE_ATTRIBUTES TABLE
MDS_METADATA_DOCS TABLE
MDS_NAMESPACES TABLE
MDS_PARTITIONS TABLE
MDS_PATHS TABLE
MDS_PURGE_PATHS TABLE
MDS_SANDBOXES TABLE
MDS_STREAMED_DOCS TABLE
MDS_TRANSACTIONS TABLE
MDS_TXN_LOCKS TABLE

Happy Leaning.! Keep Sharing..!

Ram.