CDR Suspension With Service Not Found For Customer (Doc ID 1941303.1)

Last updated on JANUARY 02, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.

Goal

Below errors will be seen while processing CDRs if the Short Codes for the services are not defined at integrate.IFW_IMPACT_CAT.

1) Customer login not found: identifier=(966561248820) prefix=(SMTGP) serviceCode=()
2) Customer has no valid products for account (2497900900012) at time (1413482573).

Also verified by this query, it returns no row:

select unique pricemodel, impact_category from integrate.IFW_RATEPLAN_CNF where impact_category like '%500200%';

no rows selected

This is leading to CDRs getting suspended.

Solution

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