Setting Up Oracle Advanced Queuing

Before you can create an RA Oracle E-Business Suite Agent solution 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 Oracle SYS account enter the following, substituting the text in < > with the appropriate text for your database:

    2. 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. Copy the aq_admin_setup.sql and aq_user_setup.sql files from the RA Oracle E-Business Suite Agent .zip file from the Automic Download Center.
  3. Create roles and AQ. From the SYS account enter:

    4. @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');

  4. Do one of the following: 
    • To use the apps user as RA Oracle E-Business Suite Agent user, grant the role to the apps user. From the SYS account enter:

      • @aq_user_setup.sql

      This will prompt you for the RA Oracle E-Business Suite Agent username.

    • To use a separate user as RA Oracle E-Business Suite Agent user, follow the instructions in Setting Up a Separate Oracle User Account for the Agent. There is no need to run the script in the apps user.