Newly created OEBS AGENT object in Client 0000 will not go to "Ready" ("Test" button grayed out)

Document ID : KB000089932
Last Modified Date : 14/04/2018
Show Technical Document Details
Newly created OEBS AGENT object in Client 0000 will not go to "Ready" ("Test" button grayed out)
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.