Billing Care: Unable to Process Cash Payments Files (Doc ID 2727135.1)

Last updated on MARCH 30, 2023

Applies to:

Symptoms

Batch Payments cannot be processed on Billing Care by using the default payment template: cash_payment_template.pit.
When trying to upload a file and run "Process", the Batch File is set to "Unprocessed" and moved to error folder.

ERROR
--------------
Error message printed on Billing Care WebLogic log:
[2020-10-28T18:12:46.275+03:00] [AdminServer] [ERROR] [] [com.oracle.communications.brm.cc.modules.pcm.workers.BatchPaymentWorker] [tid: [ACTIVE].ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 7e4ef0a1-2079-4852-b2db-28ebf363672d-0000d279,0:1] [APP: BillingCare] [partition-name: DOMAIN] [tenant-name: GLOBAL] Unable to parse the date in batch payment file[[
...
[2020-10-28T18:12:46.331+03:00] [AdminServer] [WARNING] [] [com.oracle.communications.brm.cc.modules.pcm.workers.BatchPaymentWorker] [tid: [ACTIVE].ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 7e4ef0a1-2079-4852-b2db-28ebf363672d-0000d279,0:1] [APP: BillingCare] [partition-name: DOMAIN] [tenant-name: GLOBAL] [[
Processing Error.Account Number 2020069946,Bill Number B1-599 and Amount 1840 have the invalid values.
]]



GRID DATA from Batch Payment file has the following entries:
[GRID DATA]
Status    Allocation    *    Bill Number    Account Number    First Name    Last Name    Due Amount    Receipt Date    Receipt No.    Channel    Suspense Description    Status Description    Status Code    Comment    Payment Amount    ach    batch_id    batch_total    channel_id    lockbox_id    lockbox_t    result    submitter_id
Input            B1-599    2020069946                10/27/2020    170146    Unspecified                    1840


STEPS TO REPRODUCE:
---------------------------
1. Go to the Billing care UI and upload the .pmt file in the format requested
2. After uploaded the file, it is placed at below path : /app/BillingCare/BatchPaymentFiles/unprocessed/CashBatchPayment.pmt
3. Then click on “Process” tab - it keeps on processing the file and goes to processing folder.
4. Finally it goes to “error” folder, and .json file is generated along with .pmt file

Changes

Cause

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