Customer Solutions

Announcement

This area allows you to enter ideas for Oracle Utilities products. You can help promote an idea by:

Being as specific as possible about your request.
Clearly articulating the benefits. For example, reducing implementation effort or reducing cost to serve.
Calling out if you have seen this requirement from other utilities.
Voting for suggestions you think should be implemented.

Purge of financial transactions for obfuscated accounts

Maria Rus-OracleNov 27 2025 — edited Dec 8 2025

ith GDPR. inactive accounts are obfuscated but their financial transactions remains. Keeping the FT has multiple impacts:

- The CI_FT table size is increasing every year and “inactive” financial transactions
- Some batches are not as performant as intended when querying in the table
- Custom reports for the customer are wrong as they reflects the existing FT

The objects related to those FT (bill, adjustment, payment) are also purged with the use of ILM.

Is there a base solution to delete the FT in CCB 2.7.0.3.0 or other current on-prem versions?

Added on Nov 27 2025

Closed - Alternative Option

0 people have voted for this idea

#c2m, #ccb, #other-customer-solutions

2 comments

29 views

1 mention