FND Queue rebuild

1. Stop all middle tier services including the concurrent managers. Make sure no FNDLIBR, FNDSM, or other dead processes are running.

2. Stop and then restart the database.


3. Rebuild Q

SQL> exec DBMS_AQADM.STOP_QUEUE('FND_CP_GSM_IPC_AQ');


PL/SQL procedure successfully completed.

SQL> SQL> exec DBMS_AQADM.DROP_QUEUE('FND_CP_GSM_IPC_AQ');


PL/SQL procedure successfully completed.

SQL> SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE('FND_CP_GSM_IPC_AQTBL');


PL/SQL procedure successfully completed.

SQL> SQL> exec DBMS_AQADM.CREATE_QUEUE_TABLE(queue_table => 'FND_CP_GSM_IPC_AQTBL', -
> queue_payload_type => 'SYSTEM.FND_CP_GSM_IPQ_AQ_PAYLOAD', -
> sort_list => 'priority,enq_time', -
> multiple_consumers => TRUE, -
> comment => 'IPC for GSM Generic Cartridge', -
> compatible => '8.1');


PL/SQL procedure successfully completed.

SQL> SQL>
SQL> exec DBMS_AQADM.CREATE_QUEUE ('FND_CP_GSM_IPC_AQ', FND_CP_GSM_IPC_AQTBL');

ERROR:
ORA-01756: quoted string not properly terminated


SQL> SQL> exec DBMS_AQADM.CREATE_QUEUE ('FND_CP_GSM_IPC_AQ','FND_CP_GSM_IPC_AQTBL');

PL/SQL procedure successfully completed.

SQL> exec DBMS_AQADM.START_QUEUE ('FND_CP_GSM_IPC_AQ');


PL/SQL procedure successfully completed.

SQL> SQL> exit








4.  Log in as applmgr to $FND_TOP/patch/115/sql
Run the script: afdcm037.sql

5. Relink FNDSM and FNDLIBR executables as mentioned below:
$ adrelink.sh force=y link_debug=y "fnd FNDLIBR"
$ adrelink.sh force=y link_debug=y "fnd FNDSM"

6. Run cmclean.sql

7. Start up the Services and retest.