IBRK-13 System Audit Issue

During Upgrades of the Toolset and various maintenance, I have ran into issues with the SYSAUDIT showing IBRK-13 issues.

This is caused by the Service Operation Table missing entries. PeopleSoft has a little workaround that nicely solves the problem:

/** Step 1: Verify Data: Store/backup data***/
select * from PSSERVICEOPR order by 1;

/*** Step 2: Delete data ***/
delete from PSSERVICEOPR;

/*** Step 3: Verify Delete ***/
select * from PSSERVICEOPR order by 1;

/*** Step 4: Insert data ***/
insert into PSSERVICEOPR (
select A.IB_SERVICENAME, B.IB_OPERATIONNAME
from PSSERVICE A, PSOPERATION B
where A.IB_SERVICENAME=B.IB_SERVICENAME);

/*** Step 5: Verify Insert ***/
select * from PSSERVICEOPR order by 1;