Mobile Number Change End Date Is Not Set Correctly In Pipeline Cache (Doc ID 2487420.1)

Last updated on DECEMBER 01, 2023

Applies to:

Goal

On : 7.5.0.15.0 version, Pipeline Manager

Scenario:

Migrated the complex legacy data using PL/SQL to BRM database.
In mobile number change scenario, user added few rows with different effective_t value in AU_SERVICE* tables for a service. 
For these mobile numbers the end date is not properly set in pipeline memory, and because of that, all the old CDRs are getting rated where as they should have got rejected.

Here is the data seen from database, for the account in question:

It is showing that cell number xxxxxx2057 is valid from 14-MAR-18 to 19-JAN-2038, whereas its valid period is only from 14-MAR-18 to 19-MAR-2018.

So it is showing 2147483647[19-JAN-2038] for the cell number in pipeline memory but data in au_service_t table looks fine. why ?

NOTE: For a new account created in the Same system and mobile number change scenario for that account is all working fine.
 

Solution

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