Inquiry on NEW_DEBIT_SW and NEW-CHARGE-SW variables
(Doc ID 2452530.1)
Last updated on JUNE 02, 2024
Applies to:
Oracle Utilities Customer Care and Billing - Version 2.6.0.1.0 and laterInformation in this document applies to any platform.
Goal
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?
Solution
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
Goal |
Solution |
References |