PeopleSosft IB Messages Monitoring Scripts

 

 

 

-- PUB Contract monitoring:

 

SELECT A.QUEUENAME,DECODE(A.PUBCONSTATUS,0,'ERROR',6,'TIME',A.PUBCONSTATUS) STATUS, COUNT(*) FROM PSAPMSGPUBCON A

WHERE A.LASTUPDDTTM >= sysdate - 99 AND (A.PUBCONSTATUS IN (0,6)

OR (A.PUBCONSTATUS = 0 AND A.LASTUPDDTTM < SYSDATE - 1/48))

GROUP BY A.QUEUENAME, DECODE(A.PUBCONSTATUS,0,'ERROR',6,'TIME',A.PUBCONSTATUS);

 

 

--Oper Instance monitoring:

 

SELECT  A.QUEUENAME,DECODE(A.PUBSTATUS,0,'ERROR',6,'TIME',A.PUBSTATUS) STATUS, COUNT(*) FROM PSAPMSGPUBHDR A

WHERE A.LASTUPDDTTM >= sysdate - 99

AND (A.PUBSTATUS IN (0, 6) OR (A.PUBSTATUS = 0 AND A.LASTUPDDTTM < SYSDATE - 1/48))

GROUP BY A.QUEUENAME, DECODE(A.PUBSTATUS,0,'ERROR',6,'TIME',A.PUBSTATUS);

 

--Sub Contract monitoring

SELECT A.QUEUENAME,DECODE(A.SUBCONSTATUS,0,'ERROR',6,'TIME',A.SUBCONSTATUS) STATUS, COUNT(*)

FROM PSAPMSGSUBCON A

WHERE A.LASTUPDDTTM >= sysdate - 99

AND (A.SUBCONSTATUS IN (0, 6)

OR (A.SUBCONSTATUS = 0 AND A.LASTUPDDTTM < SYSDATE - 1/48))

GROUP BY A.QUEUENAME,  DECODE(A.SUBCONSTATUS,0,'ERROR',6,'TIME',A.SUBCONSTATUS);

 

 

Note :

 Script updated to check only last 99 days "error and timeout" messages.

 

 

Useful Oracle Timeout format :

 

Time Interval	Format
Now	sysdate
Tomorrow/Next Day	sysdate + 1
Seven Days from Now	sysdate + 7
One Hour from Now	sysdate + 1/24
Three Hours from Now	sysdate + 3/24
Half an Hour from Now	sysdate + 1/48
Ten Minutes from Now	sysdate + 10/1440
Thirty Seconds from Now	sysdate + 30/86400
Tomorrow at 12 Midnight	trunc(sysdate + 1)
Tomorrow at 8am	trunc(sysdate + 1) + 8/24
Next Monday at 12 Noon	next_day(trunc(sysdate), 'MONDAY') + 12/24
First Day of the Month at 12 Midnight	trunc(last_day(sysdate) + 1)
The Nex Monday, Wednesday or Friday at 9am	trunc(least(next_day(sysdate,''MONDAY''),next_day(sysdate,''WEDNESDAY''),next_day(sysdate,''FRIDAY''))) + (9/24)

 

 

How to change header images using Macro Sets in PeopleSoft Fluid Home Page

 

 

1.      Macro Sets can be used  to apply custom look and feel to the Homepage

The delivered sample macro set is called PT_DEFAULT_MACROSET_855

Navigation:

PeopleTools, >Portal, >Branding, >Theme Macro Set

 

2.      To create a new macro set that you can customize, select and copy a sample macro set— PT_DEFAULT_MACROSET_855.

3.      Click the Copy Macro Set button to create a custom Macro Set.

 

 

4.      Now we can open this Macro Set and make changes.

5.      For an easier way to examine and analyze the macros to determine which ones to modify, you can click the download to excel button on the grid to download the list of macros to an excel spreadsheet.

6.      Before making changes you can upload your custom images.

7.      Navigate to people Tools>Portal >Branding>  Branding Objects

 

 

8.      Now as an example we will modify the header  logo. In the custom macro set change the macro for header logo to the above image name.

 

 

 

9. Now that the changes to macro are done, we need to apply it. Here only one change was made but generally macro set is for changing the complete look and feel like the background, other header images like the Action List, Home etc.

To 10. To apply the changes,  create a custom theme by cloning the DEFAULT_THEME_FLUID and entering the following values in it.

Macro Set: NEW_MACROSET

Classic Components Theme Style Sheet: PT_BRAND_CLASSIC_TEMPLTE_FLUID

Fluid Components – Global Override Style Sheet: PT_BRAND_FLUID_TEMPLATE

 

 

   11. Now apply this new theme to Branding Options.

 

12.  Log out and log back in to see the changes to the logo