Suspense Recycling Not Working (Doc ID 1219546.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 9-FEB-2015***

Symptoms

On Oracle Communications Billing and Revenue Management(BRM) Applications, 7.4.0.0.0 Version, after submitting the rejected records for recycling in suspense management center the suspense request is not dequeuing from the sync queue. Request is pending in the queue table. 

When pin_ifw_sync_oracle.pl has been run, the events did not clear from queue.

$ pin_ifw_sync_oracle.pl report -r summary -q SYNC -l pin4/pin4@$ORACLE_SID
queue_table = SYNC_T
queue_name = SYNC

Thu May 27 page 1
Event Summary Report

Evt. State Event Name Event Count
---------------- -------------------------------- -----------
READY RecycleRequest 4
**************** -----------
sum 4

$ pin_ifw_sync_oracle.pl report -r detail -q SYNC -l pin4/pin4@$ORACLE_SID
queue_table = SYNC_T
queue_name = SYNC

Thu May 27 page 1
Event Detail Report

Mesg. ID Event Name Evt. State Enq. Time Deq. Time
-------------------------------- -------------------------------- ---------------- ----------------- -----------------
876775DF57564938E0440003BA4DE486 RecycleRequest READY 05/25/10 13:24:01
876AC907639149E8E0440003BA4DE486 RecycleRequest READY 05/25/10 17:22:01
876ADEAE95FE49F0E0440003BA4DE486 RecycleRequest READY 05/25/10 17:28:04
876AF1A3C38B49ECE0440003BA4DE486 RecycleRequest READY 05/25/10 17:33:22

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