Can Redundant Records be Deleted from the ICEPAYLOAD table? (Doc ID 739548.1)

Last updated on AUGUST 22, 2016

Applies to:

LODESTAR EIP - Version: 04.52
Oracle Utilities Meter Data Management - Version: 04.53
Oracle Utilities Billing Component - Version: 04.52
Oracle Utilities Quotations Management - Version: 04.52
Oracle Utilities Rate Management - Version: 04.52
Oracle Utilities Portfolio Management - Version: 04.52
Oracle Utilities Load Profiling and Settlement - Version: 04.52
Oracle Utilities Transaction Management - Version: 04.52
Information in this document applies to any platform.

Goal

The ICEPAYLOAD table holds the incoming payload when the storage level is greater than 0. It is also used for payloads imported using DPORTAL. Can duplicate or old records be deleted from the ICEPAYLOAD table? Are there any other dependent tables that will also require records deleted from them?


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