My Oracle Support Banner

Runtime Exception Coming From Audit Table While Deleting SP Characteristics (Doc ID 2079845.1)

Last updated on JUNE 15, 2021

Applies to:

Oracle Utilities Customer Care and Billing - Version and later
Information in this document applies to any platform.


The goal of this article explains what happens when a Runtime Exception comes from the  Audit table while deleting SP Characteristics

Customer have a custom batch CMRTEMON which updates MR Cycle & MR Route in SP from the characteristics value in SP Char (Charateristics Type Code is ROUTECHG). If the value of MR Route & SP Char value is same this batch deletes the charateristics from SP Char.

It was observed that all SP Char are not deleted in one go rather than some records are deleted when some are not.

Upon investigation we found that A audit table is attached in CI_SP_CHAR Table with audit program com.splwg.base.domain.common.audit.DefaultTableAuditor. When this is disabled all characteristics are deleted perfectly fine.

As audit program is a batch program we are not able to identify what is going wrong. Can u provide us a suggestion what needs to be done to overcome the issue.?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.