Query to find the Peoplesoft Bundles and Tax Update

How to identify bundles that have been applied?

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

SES Integration with SSL enabled Local Gateway Peoplesoft

Open the People soft URL

1.    Export all SSL certificates from PS URL . Save in notepad. Now open one single notepad & paste all certificate in sequnctial order starting from fi92u.****.eduàCOMODORSADomainValidationSecureServerCA  -à COMODORSACertificationAuthority à AddTrustExternalCARoot 


and save with any filename with extenstion *.cer

PeopleSoft Test Framework Allow Untrusted SSL URL

Apply Below Solution: 

The PT 8.53.14 PRODUCT PATCH 'ReadMe' file reads.
------------------
From this patch onwards, the 'Allow Untrusted SSL' flag will not be used. If the administrator wants to allow the PTF client access to a server with invalid certificates, it will be necessary to set to active the service operation 'PTTST_CONFIG_NO_SSL'
Set the FLAG for pttst_invaild_ssl to 'Y' in the PSPTTSTCONFIG table.
------------------

1. Navigate to 'PeopleTools -> Integration Broker -> Integration Setup -> Service Operations'

2. Look for the Service Operation 'PTTST_CONFIG_NO_SSL'

3. Check the 'Active' checkbox and save the component.
------------------

Solution for PeopleTools 8.55
PTTST_INVALID_SSL is no longer in PSPTTSTCONFIG in PT 8.55.
The solution in PT 8.55 to allow Untrusted SSL is to activate service operation PTTST_CONFIG_NO_SSL.