My Oracle Support Banner

How to Customize BRM Customer Center to Review Payment Channel (Doc ID 1482098.1)

Last updated on MARCH 10, 2021

Applies to:

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


A Revenue Assurance (RA) department may need to ensure that all the payments that came from different sources are applied into BRM. Currently it is possible to see the payments in the Customer Center GUI, but it is not possible to view from which Channel such payments came from. That makes it difficult for that department to do the conciliation among the received payments and the source sent by the different channels.

Currently the only way to view this information is to query the database directly and giving a report to the Revenue Assurance Department, but need a more automated way to do it, enabling the RA Department to query that info by themselves.

Is there any default tab/field/link in Customer Center where the user can find such information? Or does Customer Center need to be customized in order to show the Payment Channel? If so, what would be the procedure?

The payment channel information is stored onto the table EVENT_BILLING_PAYMENT_T, within the column CHANNEL_ID. It comes from the object "/event/billing/payment" and field PIN_FLD_CHANNEL_ID.  The user is using the opcode PCM_PYMT_OP_COLLECT to store such info. Preferably, the user would like to see the payment channel under the Payments → Payment Details page.  However, they are open to hear other alternatives if putting the data in such page is not feasible.


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.