Error In Bill Print Extract Where There Is A Cancelled Payment (Doc ID 1588561.1)

Last updated on AUGUST 14, 2014

Applies to:

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

Symptoms

Symptom 1

===========

On : 2.4.0 version of CCB

When attempting to run the Bill Print Extract Batch whenever there is cancelled payment associated to the bill being extracted,
the following error occurs.

ERROR
-----------------------
02:52:16,466 [CobolThread 8] ERROR (com.splwg.base.support.cobol.CobolToJavaGateway) Error invoking method invoke
java.lang.ClassCastException: com.splwg.ccb.domain.admin.paymentCancelReason.entity.PaymentCancelReason_Id cannot be cast to java.lang.String
at com.splwg.base.support.impl.AbstractResultRow.getString(AbstractResultRow.java:45)
at com.splwg.ccb.domain.admin.billRouteType.algorithm.billExtract.BillExtractXMLFileAlgComp_Impl.mapBillPaymentDetails(BillExtractXMLFileAlgComp_Impl.java:582)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a bill
2. Create a payment and them cancel it.
3. Create another payment then freeze it. There are 2 payments now. One is cancelled and the other one is frozen.
4. Create another bill so that the two previous payments will be included in the newly created bill.
5. Then run the base Bill PRINT batch, the Bill Route Type POSTAL uses the base batch control and base extract algorithm C1-BLEX-XML.
6. Batch ended with error message above.

 

Symptom 2

=========

On : 2.4.0 version of CCB

The Bill Extract XML File Algorithm (C1-BLEX-XML) is throwing a NullPointerException error if
the given Account does not have a Mailing Premise.

STEPS
----------------------
1. Setup the Postal Bill Route Type to use the C1-BLEX-XML Bill Extract Algorithm.
2. Create an Account that has no Mailing Premise defined.
3. Bill the Account.
4. Run the POSTROUT batch to generate bill extract.
5. Verify that the batch ended with NullPointerException error due to the Account that has no
Mailing Premise defined.

Cause

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