My Oracle Support Banner

INP_RECYCLE Module Generates Duplicated Records When recycling suspended Records (Doc ID 1534439.1)

Last updated on MARCH 13, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

When trying to recycle suspended records from BRM Database table suspended_usage_t, the generated re-recyled *.out file has duplicated records after certain number of processed records.


Example

1- Real time Pipeline IFW process some EDR batch files.
2- Due to wrong rating data for some records in the file, records will be rejected and inserted into Table suspended_usage_t by pin_rel utility . Example (10000 records).
3- Using Suspense Manager,those records were corrected and recycled again for rating again by pipeline (PRE_RECYCLE).
4- Now Generated *.out has some duplication after certain records. Example 2000.
5- Finally the recycled output file has 12000 with 2000 extra records.

Note: The recycled is being done by INP_RECYCLE Module which is fetching the data from suspended_usage_t batch per batch. Size of batch is being specified using parameter NumberOfrow in wireless.reg 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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