Detailed Description and Symptoms
Messages similar to these appear in the trace file that is produced when the OEBS RA Agent is started :
java.sql.SQLException: ORA-25226: dequeue failed, queue RA_AQ_ADMIN.RA_MESSAGE_QUEUE is not enabled for dequeue
ORA-06512: at "APPS.UC4_OAE_PK", line 932
ORA-06512: at line 1
Caused by: java.sql.SQLException: (SQLState 99999)
uc4_oae_pk.getStatus 0 timeout : 10 : i : class java.lang.Integer :
Researching the native Oracle error message will return the following explanation:
ORA-25226: dequeue failed, queue string.string is not enabled for dequeue
Cause: The queue has not been enabled for dequeue.
Action: Enable the queue using START_QUEUE.
This information indicates that the steps given in '2.2' (Setting Up Oracle Advanced Queuing) of the "Oracle E-Business Suite Agent Guide" were not completed or were not completed successfully.
Stop your OEBS RA Agent and complete the following steps:
"Set up Oracle Advanced Queuing (AQ)"
Before you can create an OEBS AGENT object, you must set up Oracle Advanced Queuing (AQ) with the following steps:
1. Create an AQ admin account on the same database where OEBS is installed.
From the SYS account enter the following, substituting the text in < > with the appropriate text for your database:
CREATE USER ra_aq_admin IDENTIFIED BY <aq_admin_password>
DEFAULT TABLESPACE <tablespace_name>
TEMPORARY TABLESPACE <temp_tablespace_name>
ALTER user ra_aq_admin quota 100M on <tablespace_name>;
2. Create roles and AQ. From the SYS account enter:
This will prompt for the password for the ra_aq_admin account. You need to pick up a password. This procedure will create Advanced Queue
ra_message_queue and ra_queue_message_table tables and then start the queue.
To manually start the queue, from ra_aq_admin account enter:
EXECUTE DBMS_AQADM.START_QUEUE(queue_name => 'ra_message_queue');
To manually stop the queue, from ra_aq_admin account,
EXECUTE DBMS_AQADM.STOP_QUEUE(queue_name => 'ra_message_queue');
3. Grant role to OEBS user. From the SYS account enter:
This will prompt you for the OEBS Agent username.