Query to Find Tax Updates Installed in PeopleSoft

When maintaining a PeopleSoft environment or even doing a PeopleSoft upgrade, you’re likely to come across a scenario where you need to find out the last tax update applied to a particular environment. You may also have to find out all the previous tax updates applied in the environment. All this is usually done to understand the environment readiness for a PeopleSoft upgrade or applying a new update or a bundle.

All the PeopleSoft patches, bundles and tax updates makes an entry in PS_MAINTENANCE_LOG table and hence, running a query against this table would get you the result to find out the tax updates that are currently installed in your PeopleSoft environment

Query to Find Tax Update Installed in Peoplesoft HRMS

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHEREupper(A.DESCRLONG) like ‘%TAX UPDATE%’ ORDER BY 2 DESC

Query to Find Bundles Installed in Peoplesoft

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like ‘%BUNDLE%’ ORDER BY 2 DESC