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

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 to 2.3.1 [Release 2.3]
Information in this document applies to any platform.

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

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