Pin_recycle Utility Working Alongside FCT_TriggerBill Module Results In CRITICAL Pipeline Error (Doc ID 2087476.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Symptoms

On :  7.3.1.0.0 version, Pipeline Manager

Scenario :

*  The user is getting invalid item POID error when rating the CDR because the billing had not happened for that account.
*  To avoid this, the user included FCT_TriggerBill module and then recycling those suspended CDR's using pin_recycle utility.
*  Using "FCT_TriggerBill" module and "pin_recycle" utility one after the other to recycle the suspended CDR's, billing is happening ok for these accounts, but when executing the pin_recycle utility, the status of  the CDR's in "suspended_usage_t" table changed from 0 to 1 and remains at 1. The CDR is not getting recycled too. One would expect the status to change to 2 for a successful recycling of CDR.
*  As per observation, out of around 1000 records, 700 records are failing to get recycled, the rest are recycled without any issues.
*  The pipeline also throws CRITICAL errors in this scenario.

Error snippet from pipeline log :

 

Expected Behavior :

EDRs should get recycled properly.


Steps to reproduce :


Due to this issue, the user cannot recycle the suspended CDRs using pin_recycle utility and the balance impact is not getting applied for those affected accounts.

 

Cause

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