Pin_cycle_fees -purchase Kept Picking up the Same Set of 5000+ Products Checking for Applying Purchase Fees (Doc ID 1457683.1)

Last updated on DECEMBER 01, 2023

Applies to:

Goal

'pin_cycle_fees -purchase' went into infinite loop, no purchase fee was charged on products with 'Purchase Fees'. Applied <Patch 13641164> as suggested by the KM <Note 979370.1>.
Now, purchase Fees was charged on all eligible products (products with Purchase Fees), and there is no more infinite loop. But, the script kept picking up these same set of 5000+ products checking for any need to apply Purchase Fees.

>pin_cycle_fees -verbose -purchase
Thread (4151241616) begins ...
Thread (4140751760) begins ...
Thread (4130261904) begins ...
Thread (4119772048) begins ...
Thread (4109282192) begins ...
  Fetched units per step: (1000)
  Fetched units per step: (1000)
  Fetched units per step: (1000)
  Fetched units per step: (1000)
  Fetched units per step: (1000)
Total Fetched (5000) units, err 0
Fetched (5000) units in Total.
  Fetched units per step: (3)
Total Fetched (3) units, err 0
Fetched (5003) units in Total.
Thread (4130261904) exits ...
Thread (4140751760) exits ...
Thread (4119772048) exits ...
Thread (4109282192) exits ...
Thread (4151241616) exits ...
Total number of records processed = 5003.
Number of data errors encountered = 0.
Total number of errors encountered = 0.
 
We do this regularly "Activate and Inactive Service/Product" (with no Purchase Fee). Hence, the number of products picked up by 'pin_cycle_fees -purchase' keeps increasing.  Most of these products don't have a PURCHASE_FEES to charge, please advise if we can manually update (using SQL) the flag with PIN_PROD_PURCHASE_CHARGED?
 

Solution

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