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 2.6.0.1.0 to 2.6.0.1.0 [Release 2]
Information in this document applies to any platform.

Goal

On ORMB 2.6.0.1.0 version, DM - Data Management

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

ACTUAL BEHAVIOR
---------------

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.

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

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

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!


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