PIN_CYCLE_FORWARD Never Ends Execution

(Doc ID 968706.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2012***
***Checked for relevance on 27-May-2014***


Problem Statement:
pin_cycle_forward does not terminate.

Analysis :
The pin_cycle_forward utility was added in cron tab on Monday Aug 24. As per the cron tab entry, it was started executing from Aug 25, 1:15. As it was not completed, it kept running and next day, Aug 26 1:15, one more pin_cycle_forward started in parallel to first one. And so on. On Aug 28, 4 pin_cycle_forward processes were running concurrently. They were then killed.
We can see that there are multiple cycle fee arrays created by using:

select obj_id0,count(obj_id0) from PURCHASED_PRODUCT_CYCLE_FEES_T group by obj_id0 having count(obj_id0)>1;


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