My Oracle Support Banner

CI_TXN Table Archive (Doc ID 2532018.1)

Last updated on APRIL 22, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Goal

1) Will there be any issues or challenges if we only archive CI_TXN_DETAIL and CI_TXN_DTL_PRITM tables? And not archive billable charge and other tables.
2) Does oracle have any suggestion to move such high volume of data faster? These tables are partitioned by CURR_SYS_PRCS_DT field.
3) Will the TFM process performance increase if data is archived?
4) Are there any other considerations before we proceed with archive?
 

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
References


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