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
Issue:
Newly created OEBS AGENT object in Client 0000 will not go to "Ready" ("Test" button grayed out)
Resolution:
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 :
?


Investigation

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.
?


Solution

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:

@aq_admin_setup.sql

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:

@aq_user_setup.sql

This will prompt you for the OEBS Agent username.
?