My Oracle Support Banner

Inquiry on NEW_DEBIT_SW and NEW-CHARGE-SW variables (Doc ID 2452530.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version and later
Information in this document applies to any platform.


Every time Billing batch is run with freeze and online freezing a bill, the New Charge (NEW_DEBIT_SW column) check box of the Financial Transaction is being updated from 'Y' to 'N'.

Upon checking the logs generated, it was found that the base program ProgramCIPFBLCN_Impl has 2 queries (U_NDINARS,U_OIUNBLD) which is being called and updates the NEW_DEBIT_SW of the CI_FT table with a value of NEW-CHARGE-SW to: 'N'. While comparing the 2.6 version of the code to the 2.3 COBOL version CIPFBLCN, it was identified that the NEW_DEBIT_SW is not being updated on 2.3 and it is only the ARS_DT of CI_FT table is being updated.

When will be the NEW_DEBIT_SW (New Charge field in FT page) will be set to 'Y' or 'N'? As far as the code goes, it is dependent on the value of the NEW-CHARGE-SW variable. When will be this variable set to 'Y'? If the Arrears Date is populated, the NEW_DEBIT_SW will be set to 'N' and vice versa?


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.