My Oracle Support Banner

ILM Partitioning Scripts Were Provided But They Are Not Provided With 2.7.0.1 Version Of Product (Doc ID 2542182.1)

Last updated on FEBRUARY 10, 2020

Applies to:

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

Goal

With the release of 2.6.0.1 version of ORMB, ILM partitioning scripts were provided but they are not provided with 2.7.0.1 version of product. Please provide ILM partition scripts.
 
Also, need confirmation on the following points below:
 
a. CI_FT_GL , CI_FT_PROC and CI_FT_GL_EXT will have FK referenced partition to CI_FT table.
b. CI_PAY will NOT have FK referenced partition to CI_PAY_EVENT table but will have their individual MO level partitions.
c. CI_PAY, CI_FT and CI_PAY_EVENT – all three will have primary partition as ILM_DT (monthly) and sub-partition by their primary IDs (10 partitions each).
d. CI_APAY_CLR_STG will be FK referenced to CI_PAY_EVENT partition strategy.
 

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.