Oracle Apps Adapter is unable to consume business events via non apps schema (FMW_SOA)

Solution
********
See to that the below grants are availble to the non apps schema (FMW_SOA)

To run with Apps user
**********************
begin
Dbms_Aqadm.Grant_Queue_Privilege('ALL', 'WF_BPEL_Q', 'FMW_SOA');
end;

GRANT ALL ON WF_BPEL_QTAB to FMW_SOA;
commit;

To run with SYSDBA user
************************
grant CONNECT, RESOURCE, aq_administrator_role TO FMW_SOA;
grant execute ON DBMS_AQ TO FMW_SOA;
grant execute ON DBMS_AQADM TO FMW_SOA;
execute DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('ENQUEUE_ANY','FMW_SOA',FALSE);
execute DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('DEQUEUE_ANY','FMW_SOA',FALSE);

Run the Below Script
********************
GRANT SELECT ON SYS.ALL_DEQUEUE_QUEUES TO FMW_SOA;
GRANT SELECT ON SYS.ALL_QUEUES TO FMW_SOA;
GRANT SELECT ON SYS.ALL_TAB_COLS TO FMW_SOA;
GRANT SELECT ON SYS.ALL_TAB_COLUMNS TO FMW_SOA;
GRANT SELECT ON SYSTEM.AQ$_QUEUES TO FMW_SOA;
GRANT SELECT ON SYSTEM.AQ$_QUEUE_TABLES TO FMW_SOA;
GRANT SELECT ON APPS.AQ$_WF_BPEL_QTAB_F TO FMW_SOA;
GRANT SELECT ON APPS.AQ$_WF_BPEL_QTAB_I TO FMW_SOA;
GRANT SELECT ON SYS.COL$ TO FMW_SOA;
GRANT SELECT ON SYS.COLTYPE$ TO FMW_SOA;
GRANT SELECT ON SYS.DBA_PENDING_TRANSACTIONS TO FMW_SOA;
GRANT SELECT ON SYS.DBA_SERVICES TO FMW_SOA;
GRANT SELECT ON SYS.DUAL TO FMW_SOA;
GRANT SELECT ON SYS.GV$ENABLEDPRIVS TO FMW_SOA;
GRANT SELECT ON SYS.GV$GLOBAL_TRANSACTION TO FMW_SOA;
GRANT SELECT ON SYS.HIST_HEAD$ TO FMW_SOA;
GRANT SELECT ON SYS.OBJ$ TO FMW_SOA;
GRANT SELECT ON SYS.OBJAUTH$ TO FMW_SOA;
GRANT SELECT ON SYS.PENDING_SESSIONS$ TO FMW_SOA;
GRANT SELECT ON SYS.PENDING_TRANS$ TO FMW_SOA;
GRANT SELECT ON SYS.SERVICE$ TO FMW_SOA;
GRANT SELECT ON SYS.TAB$ TO FMW_SOA;
GRANT SELECT ON SYS.V$ENABLEDPRIVS TO FMW_SOA;
GRANT SELECT ON SYS.X$K2GTE2 TO FMW_SOA;
GRANT SELECT ON SYS.X$KZSPR TO FMW_SOA;
GRANT SELECT ON SYS.X$KZSRO TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_XA TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_AQADM TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_AQADM_SYS TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_AQADM_SYSCALLS TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_ASSERT TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_IJOB TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_PICKLER TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_PRVTAQIS TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_RULEADM_INTERNAL TO FMW_SOA;GRANT EXECUTE ON SYS.DBMS_RULE_ADM TO FMW_SOA;
GRANT EXECUTE ON SYS.DBMS_SYSTEM TO FMW_SOA;
GRANT SELECT ON SYS.USER$ TO FMW_SOA;

Manged Server Fails to start due to OracleAppsAdapter initialization error

Applies to:
Oracle SOA Platform - Version: 11.1.1.5.0 and later [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms:
After AppsAdapter.rar was deployed on soa_server1 the 'OracleAppsAdapter' does not go into the Active State.


The below error are generated in the soa_server1.log file:
class 'oracle.tip.adapter.apps.IAppsConnection' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/IDBConnection
[2] The ra.xml class 'oracle.tip.adapter.apps.AppsConnection' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/DBConnection
[3] The ra.xml class 'oracle.tip.adapter.apps.AppsManagedConnectionFactory' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/DBManagedConnectionFactory
[4] The ra.xml class 'oracle.tip.adapter.apps.AppsConnectionFactory' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/DBConnectionFactory.
weblogic.application.ModuleException: [1] The ra.xml class 'oracle.tip.adapter.apps.IAppsConnection' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/IDBConnection
[2] The ra.xml class 'oracle.tip.adapter.apps.AppsConnection' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/DBConnection
[3] The ra.xml class 'oracle.tip.adapter.apps.AppsManagedConnectionFactory' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/DBManagedConnectionFactory
[4] The ra.xml class 'oracle.tip.adapter.apps.AppsConnectionFactory' could not be loaded from the resource adapter archive/application because of the following error: java.lang.NoClassDefFoundError: oracle/tip/adapter/db/DBConnectionFactory
at weblogic.connector.deploy.ConnectorModule.prepare(ConnectorModule.java:230)
at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:518)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:159)
Truncated. see log file for complete stacktrace

Changes :
The 'OracleAppsAdapter' was deleted from the WebLogic Administration Server Console.

Cause :
The 'DBAdapter' has a higher deployment order than 'OracleAppsAdapter'.
In order for 'OracleAppsAdapter' to be deployed successfully (go into the Active State) it needs 'DBAdapter' to be already deployed.

Solution :
Ensure that the DBAdapter has a lower deployment order than OracleAppsAdapter.

1. Login into the WebLogic Administration Console
2. Go to Deployments
3. Delete existing adapter 'OracleAppsAdapter'
4. Restart admin server and managed servers.
5. Login into the WebLogic Administration Console
6. Go to Deployments
7. Click on 'DbAdapter'
8. Go to the Overview tab
9. Verify and note the value for the "Deployment Order" parameter
10. Go back to Deployments
11. Re-create 'OracleAppsAdapter' from '/FMW_HOME/Oracle_SOA1/soa/connectors/AppsAdapter.rar' with the default settings.
12. Update 'OracleAppsAdapter' Adapter with deployment order higher than the 'DBAdapter'
13. Save the changes
14. Go back to Deployments
15. Perform Action 'Start' for 'OracleAppsAdapter'