How to indentify bundles that have been applied?

Question: How do i know what bundles have been applied in my PeopleSoft Application System?

Answer:

All bundles update activity that are been applied to PeopleSoft system is logged into a table called PS_MAINTENANCE_LOG.you can check to this table to see what Bundles or Tax Updates have been applied. Below are the steps how to write a query in QueryTools (2 tier):

1. if you want a PS Query to be built, make sure you have access to this table. if you do not, you need to add this record into query security.

2. once you have access to PS_MAINTENANCE_LOG table, here's how to write the query, add the fields as shown in below screen shot:

3. make sure that for the descr field, you order it by descending.

4. go to expression and right click and pick new expression and enter 1 and say ok

5. go to criteria tab and drag the expression

6. right click on the query criteria expression 2 and select expression

7. enter - 1 AND upper(A.DESCRLONG) like '%BUNDLE%' in the expression box:

8. you should get the query results as shown below:

9. if you are looking to find what tax updates have been applied, either you navigate to this menu:

Set Up HRMS > Product Related > Payroll for North America > Tax Table Reports >Tax Update

or change the upper(A.DESCRLONG) like '%BUNDLE%' expressionto upper(A.DESCRLONG) like '%TAX UPDATE%';

10. alternatively, if you have access to SQL tool, run the below queries:

Bundles Query:

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

Tax Update Query:
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 '%TAX UPDATE%' ORDER BY 2 DESC