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

Last updated on JUNE 14, 2017

Applies to:

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

Goal

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.?
 

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