Moshe - SOA Time!

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;