Tuesday, November 8, 2016

Dequeuing in Oracle BRM



Although it is not recommended, but sometimes in the test environment where there is no interface to dequeue the message from advance queue, the queue is clogged and we wish to dequeue it. Here is the way to do it:


DECLARE
po_t dbms_aqadm.aq$_purge_options_t;
BEGIN
dbms_aqadm.purge_queue_table('AQ_SYNC', NULL, po_t);
END;

Execute the above from SQL client or command line.

Migrating PDC data from one system to another

Given System “A” with BRM and PDC and System “B” with BRM and PDC, following is the process for moving new or changed pricing data from ...