Runtime Exception Coming From Audit Table While Deleting SP Characteristics
Last updated on JUNE 14, 2017
Applies to:Oracle Utilities Customer Care and Billing - Version 220.127.116.11.0 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.?
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