EGL 9.2: How to clear exceptions from KK_EXCPTN_TBL After Applying Certain Bug Fixes

(Doc ID 2382597.1)

Last updated on APRIL 04, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

After applying the following bugs which fixed the issue of the exceptions not being cleared:

<BUG:24837014> - GL: BUDGET EXCEPTIONS NOT CLEARED FROM PS_KK_EXCPTN_TBL WHEN TRANSACTION IS DELE
<BUG:23064598> - GL:DELETING PO WITH BUDGET EXCEPTION DOES NOT REMOVE ROWS FROM KK_EXCPTN_TBL
<BUG:24811520> - AP: BUDGET EXCEPTIONS NOT CLEARED FROM PS_KK_EXCPTN_TBL WHEN VOUCHER IS DELETED

 it was determined that the bug fixes do not delete the existing records that were not cleared before the bugs were applied.

Is there a fix supplied by Oracle to remove these existing records?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms