Open Item Accounts: Query Used To Calculate The Balance of SA Or Account (Doc ID 1606878.1)

Last updated on AUGUST 04, 2022

Applies to:

Goal

This is a request for information related to standard CC&B, version 2.3.1 .

The standard Zone: "Current Context" - typically displayed on the Control Central or Dashboard portals - shows the current and payoff balance for the Account.
For Balance Forward customers, the query executed to calculate the balance on the Current Context zone is the following:

SELECT SUM(A.CUR_AMT), SUM(A.TOT_AMT)
 FROM CI_FT A,
 CI_SA B WHERE A.SA_ID = B.SA_ID AND B.ACCT_ID = :1 AND A.REDUNDANT_SW = 'N' AND A.NOT_IN_ARS_SW <> 'Y' AND A.CUR_AMT A.ARS_DT
SELECT SUM(A.CUR_AMT), SUM(A.TOT_AMT)
 FROM CI_FT A,
 CI_SA B WHERE A.SA_ID = B.SA_ID AND B.ACCT_ID = :1 AND A.REDUNDANT_SW = 'N' AND A.NOT_IN_ARS_SW <> 'Y' AND A.CUR_AMT > 0 AND A.FREEZE_SW = 'Y' AND (A.FREEZE_DTTM A.ARS_DT
The questions are the following:

Question1: Is the same query executed for Accounts that have a Customer Class with the switch OPEN ITEM SW = Yes?

Question2: We are trying to determine if the queries calculating the balance for an Open Item Account use the Redundant switch as for the Accounts that are Balance Forward (see above queries).
 

Solution

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