Billing Care : ACH Payments In Suspense Are Not Showing Up In Payment Suspense Of Billing Care (Doc ID 2186324.1)

Last updated on OCTOBER 12, 2016

Applies to:

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

Symptoms

On : 7.5.0.15.0 version, Customer Care

ACTUAL BEHAVIOR
---------------
Billing care : ACH payments in suspense are not showing up in payment suspense of billing care

BRM considers the ACH and credit card payment as BRM initiated payment types. Hence, billing care is filtering out those payment types from showing in suspense user interface (UI).
User has following requirement: the ACH payments can be customer initiated as well from a bank and can enter suspense if required amount of information is not passed.  Therefore, this filtering needs to be removed for the ACH payments to show up in suspense list as well as a filter criteria.

The search being constructed form billing care is
W Mon Jul 18 20:28:26 2016 d-brmapp3.ord1.corp.xxxx.com cm:12345 cm_utils.c(148):1548 2:bcui-n01:UnknownProgramName:0:[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)':7:1468873706:0:root.0.0.0.1:::
  CM FM->DM opcode PCM_OP_SEARCH, opflags=0x0
# number of field entries allocated 20, used 10
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_MAX_ROW INT [0] 25
0 PIN_FLD_MIN_ROW INT [0] 1
0 PIN_FLD_RESULTS ARRAY [0] NULL array ptr
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_CREATED_T TSTAMP [0] (1466226002) Sat Jun 18 05:00:02 2016
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_PAYMENT SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_STATUS ENUM [0] -1
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_PAYMENT SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_PAY_TYPE ENUM [0] -1
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_CREATED_T TSTAMP [0] (0)
0 PIN_FLD_TEMPLATE STR [0] "select X from /event/billing/payment 1 where lower( 1.F1 ) > V1 and F2 in ( 15, 16 ) and F3 not in ( 10003, 10005 ) order by 1.F4 asc "
0 PIN_FLD_FLAGS INT [0] 0

The "not in" clause is adding the credit card and ACH types to be not fetched. Which is causing this issue.

EXPECTED BEHAVIOR
-----------------------
User has following requirement: the ACH payments can be customer initiated as well from a bank and can enter suspense if required amount of information is not passed.  Therefore, this filtering needs to be removed for the ACH payments to show up in suspense list as well as a filter criteria.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a manual payment in suspense of ACH payment type.
2. Open payment suspense Ui in billing care UI.
3. Filter criteria does not show ACH/DD and CC types (10005 and 10003) because of the search mentioned.
4. Also the payment that you entered in suspense for ACH/DD will not show in the suspense payment list.

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