Problem with the Redundant Process (CIPFFTRB) Not Picking up All The Expected F (Doc ID 612028.1)

Last updated on JULY 24, 2017

Applies to:

PeopleSoft Enterprise Revenue Management Billing - Version: 8.9 - Release: 8.9

Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 713158

Symptoms


The redundant process does not pick up all the expected Financial Transaction (FTs) as it is expected to, due to incorrect condition in the COBOL program, in PERFORM GE000-ADD-FT-COLL section. The condition is IF TMP-CUR-AMT = ZERO AND TMP-TOT-AMT = ZERO.
It seems that this condition is not correct and once the total of FT's selected add up to ZERO, then the remainder of the FTs, that need to be selected and updated as redundant, get ignored.

The system does not pick up the all the expected FT's to flag them as redundant, as expected (based on the conditions in CIPFFTRN_S_FT).
For the FT's to get selected by the redundant process, the following conditions are considered:
The same SA_ID, FREEZE_SW = 'Y', ARS_DT <> NUll, ARS_DT < 'Process date - Aging buckeet days), and REDUNDANT_SW = 'N'.

SELECT FT_ID ,SA_ID ,SIBLING_ID ,FT_TYPE_FLG ,CUR_AMT ,TOT_AMT ,BUSINESS_UNIT_CI ,BUSINESS_UNIT_GL ,CRE_DTTM ,FREEZE_SW ,
FREEZE_OPRID ,FREEZE_DTTM ,ARS_DT ,CORRECTION_SW ,REDUNDANT_SW ,NEW_DEBIT_SW ,SHOW_ON_BILL_SW ,NOT_IN_ARS_SW ,PARENT_ID ,
BILL_ID ,ACCOUNTING_DT ,SCHED_DISTRIB_DT ,CURRENCY_CD ,BAL_CTL_GRP_ID FROM PS_CI_FT
WHERE SA_ID= '3185593010' AND
FREEZE_SW='Y' AND
ARS_DT IS NOT NULL AND
ARS_DT< '10-27-2001' AND REDUNDANT_SW='N'


Chooses all the FT_IDs associated with this SA_ID, using the above conditions. Then it should update the redundant_sw for all of these FTs to 'Y' in the step CIPFFTRN_U_FT:
UPDATE PS_CI_FT   SET REDUNDANT_SW= 'Y'  WHERE FT_ID= :1


But not all expected FTs get picked up. if so it happens that the first few FT's that got selected and updated, their totals adds up to ZERO, then the program dropps out of the loop, without considering the rest of the FT's that are eligible to be flagged as redundant.
IN this Example:

FT1     $35.34
FT2    -$34.20
FT3     $34.20
FT4    -$35.34
--------------------------------------
Total:    $0

The issue ocurrs in this section...
     PERFORM UNTIL S-FT-NO-MORE
      *
      ***      Get the next FT that may be considered redundant
      *
               PERFORM GC000-GET-FT
               IF S-FT-MORE
      *
      ***          Add the FT to the collection and add the current
      ***          amount and the payoff amount to the running total
      ***          current amount and payoff amount.
      *
                    PERFORM GE000-ADD-FT-COLL

                    IF TMP-CUR-AMT = ZERO AND TMP-TOT-AMT = ZERO
      *
      ***              Update all FTs in the collection as redundant
      *
                        PERFORM GG000-UPDATE-FT-COLL
                        INITIALIZE FT-CNT
                                    FT-COLL
                        SET SW-YES OF UPDATE-FT-SW OF W-WRK TO TRUE
                    END-IF
               END-IF
           END-PERFORM
+++++++++++++++++++++++++++++++++++++++++++
This condition causes the issue......                 IF TMP-CUR-AMT = ZERO AND TMP-TOT-AMT = ZERO

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