Category Archives: SOA

Update PeopleSoft routing destination nodes via SQL

PeopleTools 8.52
We had a situation where we needed to update the routing destination nodes in PeopleSoft via SQL instead of doing it in PIA. Only do this if you aren’t using a WSDL with the routing and its going to a JMS queue. The statements must be run in order.


UPDATE PSIBRTNGSUBDEFN SET RECEIVERNODENAME='NEW_NODE_NAME' WHERE ROUTINGDEFNNAME IN (SELECT ROUTINGDEFNNAME FROM PSIBRTNGDEFN WHERE IB_OPERATIONNAME ='DEPT_FULLSYNC' AND RECEIVERNODENAME='OLD_NODE_NAME');

UPDATE PSRTNGDFNPARM SET RECEIVERNODENAME='NEW_NODE_NAME' WHERE ROUTINGDEFNNAME IN (SELECT ROUTINGDEFNNAME FROM PSIBRTNGDEFN WHERE IB_OPERATIONNAME ='DEPT_FULLSYNC' AND RECEIVERNODENAME='OLD_NODE_NAME');

UPDATE PSIBRTNGDEFN SET RECEIVERNODENAME='NEW_NODE_NAME' WHERE IB_OPERATIONNAME='DEPT_FULLSYNC' AND RECEIVERNODENAME='OLD_NODE_NAME';

Updating xsd and xsl in jDeveloper

When having to update an xsd (field name changes) in a composite in jDeveloper I found its easier to just go to the source and update the xsd and then go to your Transformation xsl as well and change the source. In order to see the design view updated close your Transformation in jDeveloper and re-open it. You will see the updated field names there. This helps so you don’t have to go and re-do your mapping xsl in the Design view.