Decimal points and thousand separators

SELECT
CAST(CONVERT(VARCHAR, CAST(A.HOURLY_RT AS MONEY), 1) AS VARCHAR)

Multiple EMail Addresses

SELECT A. EMPLID, A .NAME, B.E_ADDR_TYPE , B. EMAIL_ADDR, B .PREF_EMAIL_FLAG

  FROM PS_PX_ACTV_WRKR_VW A , PS_EMAIL_ADDRESSES B

  WHERE ( A. EFFDT =

        (SELECT MAX(A_ED .EFFDT) FROM PS_PX_ACTV_WRKR_VW A_ED

        WHERE A. EMPLID = A_ED .EMPLID

          AND A. EMPL_RCD = A_ED .EMPL_RCD

          AND A_ED. EFFDT <= SUBSTRING(CONVERT (CHAR, GETDATE(),121 ), 1, 10))

    AND A .EFFSEQ =

        (SELECT MAX(A_ES .EFFSEQ) FROM PS_PX_ACTV_WRKR_VW A_ES

        WHERE A. EMPLID = A_ES .EMPLID

          AND A. EMPL_RCD = A_ES .EMPL_RCD

          AND A. EFFDT = A_ES .EFFDT)

     AND A. EMPLID = B .EMPLID

     AND A. EMPLID IN (SELECT C .EMPLID

                                           FROM PS_EMAIL_ADDRESSES C

                                            GROUP BY C.EMPLID

                                           HAVING COUNT (*) > 1) )

ORDER BY 2, 3 , 4

Schedule JobSet Definitions

Need to Update/Delete the data from the following 7 tables:

1. PS_SCHDLDEFN
2. PS_SCHDLITEM
3. PS_SCHDLNODEPARM
4. PS_SCHDLNOTIFY
5. PS_SCHDLMESSAGE
6. PS_SCHDLDEFNINFO
7. PS_SCHDLTEXT

select 'PS_SCHDLDEFN' , * from PS_SCHDLDEFN where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLITEM' , * from PS_SCHDLITEM where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLNODEPARM' , * from PS_SCHDLNODEPARM   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLNOTIFY' , * from PS_SCHDLNOTIFY   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLMESSAGE' , * from PS_SCHDLMESSAGE   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLDEFNINFO' , * from PS_SCHDLDEFNINFO   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLTEXT' , * from PS_SCHDLTEXT   where SCHEDULENAME like 'PRI009%'

Peoplesoft: Error while opening Schedule Jobset: peopletools, audit check

This issue is documented in Oracle note 656527.1.

The reason for the "no matching buffer found for level (15,26)" is because of orphaned rows.  When reading data from the DB into the component buffers, the panel processor checks for the existence of a parent row. If the parent row does not exist, then the error message is thrown.  Check for orphaned rows in the component tables.

For the Schedule JobSet definitions case, use below statements to Delete SCHEDULENAME causing ISSUE:

SQL> DELETE FROM PS_SCHDLITEM WHERE SCHEDULENAME='SCHEDULE causing issues';
SQL> DELETE FROM PS_SCHDLDEFNINFO WHERE SCHEDULENAME='SCHEDULE causing issues';
SQL> DELETE FROM PS_SCHDLDEFN WHERE SCHEDULENAME='SCHEDULE causing issues'; 

SELECT *

  FROM [PNRP1PH] . [dbo] . [PS_SCHDLITEM]

WHERE [SCHEDULENAME] like 'HRI00%'

 

select *

from PS_SCHDLDEFNINFO

WHERE [SCHEDULENAME] like 'HRI00%'

 

select *

from PS_SCHDLDEFN

WHERE [SCHEDULENAME] like 'HRI00%'