INP_RECYCLE Module Generates Duplicated Records When recycling suspended Records

(Doc ID 1534439.1)

Last updated on JANUARY 23, 2015

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 

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