Top PeopleSoft Jobs

How to indentify bundles that have been applied?

Wednesday, February 10, 2010

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

1 comments:

naveen November 16, 2010 at 7:21 PM  

Please let me know the delivered peoplesoft tables used in I9 processing

Post a Comment

About This Blog

Have you got a PeopleSoft Question? Post it in the forums section or in your preferred place or in comments section, so that we can answer it for you in detail with screen shots;

Learn PeopleSoft functionality and how to use the setups and process flow offered in different modules;

Hope this would give you some ideas...

Blog Archive

  © Blogger template On The Road by Ourblogtemplates.com 2009

Back to TOP