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 to [Release 7.3.0]
Information in this document applies to any platform.


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.


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 




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

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