My Oracle Support Banner

ILM Crawler For Txn Calc (C1-TCCRL) - ILM_ARCH_SW Is Not Stamped In Child Tables. (Doc ID 2414300.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version to [Release 2]
Information in this document applies to any platform.


On ORMB version, DM - Data Management

ILM Crawler for Txn Calc (C1-TCCRL) - ILM_ARCH_SW is not stamped in child tables.


For the ILM crawler of Txn Calc C1-TCCRL, only the ILM_ARCH_SW in CI_TXN_CALC is marked as 'Y' and not in the child tables like CI_TXN_CALC_LN, CI_TXN_CALC_LN_CHAR, CI_TXN_SQ.

These tables do not have FK referenced partitions to parent table CI_TXN_CALC, so the application code should mark switch as 'Y' in the child tables also.

For child tables like CI_TXN_CALC_LN, CI_TXN_CALC_LN_CHAR, CI_TXN_SQ. the ILM_ARCH_SW is marked as 'Y'.

The issue can be reproduced at will with the following steps:
1. Run Batch C1-TCCRL.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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