Deleting Duplicate Routings
Duplicate routings can cause problems with Integration Broker messaging. Fortunately PeopleSoft has provided (as of PeopleTools 8.48 anyway) functionality to search for and delete duplicate routings.
This is available under in the Routings tab under:
The search will find any duplicate routings and allow you to select and delete them.
Behinds the scenes PeopleCode searches the
PSIBRTNGDEFN Integration Broker Routing Definition for any cases where more than one active routing is associated with the same service operation for any local to local routings, any to local routings and point to point routings.
select IB_OPERATIONNAME, VERSIONNAME, SENDERNODENAME, RECEIVERNODENAME, count(distinct ROUTINGDEFNNAME) from PSIBRTNGDEFN where EFF_STATUS = 'A' group by IB_OPERATIONNAME, VERSIONNAME, SENDERNODENAME, RECEIVERNODENAME having count(distinct ROUTINGDEFNNAME) > 1;