My Oracle Support Banner

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

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Utilities Energy Information Platform - Version 04.52 and later
Oracle Utilities Meter Data Management - Version 04.53 and later
Oracle Utilities Billing Component - Version 04.52 and later
Oracle Utilities Quotations Management - Version 04.52 and later
Oracle Utilities Rate Management - Version 04.52 and later
Information in this document applies to any platform.
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

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
Goal
Solution


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