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%'