My Oracle Support Banner

Regarding Deleting Ledger Data (Doc ID 1293029.1)

Last updated on APRIL 13, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 6.7.0.0.0 to 6.7.0.0.0 [Release 6.7.0]
Information in this document applies to any platform.

Purpose

Among options considered for purging data, A CSR has indicated that the ledger data contained in the LEDGER_REPORT_ACCTS_T and LEDGER_REPORT_T tables is no longer needed.
The ledger commands have a start/end parameter, assuming that this information can be regenerated. Some questions and answers discussed as below.

Questions and Answers

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
Purpose
Questions and Answers
 Is it safe to simply delete all the data on these two tables?
 Would that data be easily recovered/regenerated in case it’s needed in the future?
 Are there any other tables that would need to be cleaned up if we delete the data on these two tables?
 Will there be no impact on our portal or application once we execute the deletion from these tables?
 We intend to delete the contents of only two tables: LEDGER_REPORT_T and LEDGER_REPORT_ACCTS_T because they are the ones taking up a lot of space.
Is it strictly necessary to delete contents of the other ledger-related tables?
e.g. ledger_report_account_groups_t
       ledger_report_gl_segments_t
       ledger_report_total_groups_t
Would there be a problem if we leave these tables untouched and we need to recreate ledger data in the future?
References

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