My Oracle Support Banner

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

Last updated on NOVEMBER 13, 2020

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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