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.


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 hundreds of Community platforms