Find and Audit Active Service Operations
By Chris Malek | Thu, Sep 5, 2013
It is a good idea to periodically monitor what service operations are active in your production database.
Here is a base query that should return active Service operations that are routed to an active local node.
- Make sure the values returned here are only service operations that you are actually using.
- You should inactivate routings and service operations that you are not using.
- This will ensure you do not have data being posted to the integration broker and updating or extracting data.
- This should be checked after applying bundles and patches
-- Find All Active Service Operations and routings select O.IB_OPERATIONNAME, RD.SENDERNODENAME,RD.RECEIVERNODENAME, o.descr from PSOPERATION o, PSOPRVERDFN OV, PSIBRTNGDEFN RD, PSMSGNODEDEFN MN where O.IB_OPERATIONNAME = OV.IB_OPERATIONNAME AND OV.ACTIVE_FLAG = 'A' AND RD.IB_OPERATIONNAME = OV.IB_OPERATIONNAME AND RD.VERSIONNAME = OV.VERSIONNAME AND RD.EFF_STATUS = 'A' -- ROUTING IS ACTIVE AND RD.RECEIVERNODENAME = mn.msgnodename AND mn.active_node = 1 AND mn.localnode = 1 ORder by O.ib_operationname, RD.SENDERNODENAME;
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?
Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.
Integration Broker - The Missing Manual
I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.