My Oracle Support Banner

Account Financial History (C1-ACCFINHR3) Query Zone Does Not Exclude FTs With Null Extract Date (Doc ID 2684410.1)

Last updated on SEPTEMBER 28, 2022

Applies to:

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


Problem Summary
Account Financial History (C1-ACCFINHR3) Query Zone does not exclude FTs with null Extract Date

Problem Description
Account Financial History Search by GL Extract Date Query Zone (C1-ACCFINHR3) also shows results with GL Extract Date set to null. See attached for the screenshots

Reproduce Steps
The issue can be reproduced in following steps:
1.In the Account Financial History page, search by "GL Extract Date", the Zone ‘C1-ACCFINHQ3’ shows FTs that has no GL Extract Date.

2.By checking Adjustment Type -> Algorithms -> "O-APEUSP"
See that Adjustment FT Creation's algorithm "ADJT-CA" shows detail "PayoffAmt = 0、 Current Amt = Adj Amount (no GL)"

3.Some of the FTs, like the above adjustment type, is does not have GL so they would not have a GL Extract Date.

4.By checking Account Financial History, for some of the output, it took row 168 to show FTs with actual Extract Date, which took 7 clicks of Next Button.

5.The root cause was that the Zone used to retrieve the data (C1-ACCFINHR3) does not exclude FTs with null Extract Date.
6.SQL run shows that it retrieves records with null XFER_TO_GL_DT.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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