Filters PIN_FLD_AMOUNT_FROM And PIN_FLD_AMOUNT_TO On PCM_OP_AR_GET_ACCT_ACTION_ITEMS Dont Work (Doc ID 1305161.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.0 and later ]
Linux x86-64

Symptoms

Filters PIN_FLD_AMOUNT_FROM And PIN_FLD_AMOUNT_TO On PCM_OP_AR_GET_ACCT_ACTION_ITEMS Don't Work

Steps to Reproduce:

1) Create an account
2) Make the following payments for the account:
   i) Amount100
  ii) Amount 500
  iii)Amount 900

By Calling PCM_OP_PYMT_COLLECT opcode as below for Amount 100:

op_pymt_collect input flist
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 8402094 0
0 PIN_FLD_PROGRAM_NAME STR [0] "Pagamento XXX"
0 PIN_FLD_DESCR STR [0] "Pagamento XXX"
0 PIN_FLD_CHARGES ARRAY [0] allocated 20, used 6
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 8402094 0
1 PIN_FLD_BILLINFO ARRAY [0] allocated 20, used 3
2 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 0
2 PIN_FLD_AUTH_DATE STR [0] ""
2 PIN_FLD_AMOUNT DECIMAL [0] 100
1 PIN_FLD_COMMAND ENUM [0] 0
1 PIN_FLD_PAY_TYPE ENUM [0] 10001
1 PIN_FLD_CURRENCY INT [0] 840
1 PIN_FLD_PAYMENT SUBSTRUCT [0] allocated 20, used 2
2 PIN_FLD_DESCR STR [0] "Pagamento XXX"
2 PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 1
3 PIN_FLD_CASH_INFO ARRAY [0] NULL array ptr

Similarly need to make payment for Amount 500 and 900

3) Call PCM_OP_AR_GET_ACCT_ACTION_ITEMS opcode with the below condition:
- PIN_FLD_AMOUNT_FROM = 400 and PIN_FLD_AMOUNT_TO = 800

The PCM_OP_AR_GET_ACCT_ACTION_ITEMS input flist is as shown below:
#PCM_OP_AR_GET_ACCT_ACTION_ITEMS INPUT FLIST
0 PIN_FLD_POID POID [0] 0.0.0.1 /billinfo 8402606 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 0
0 PIN_FLD_AR_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 0
0 PIN_FLD_INCLUDE_CHILDREN INT [0] 0
0 PIN_FLD_POID_TYPE STR [0] "/item/refund, /item/payment"
0 PIN_FLD_AMOUNT_TO DECIMAL [0] 800
0 PIN_FLD_AMOUNT_FROM DECIMAL [0] 400

4) The PCM_OP_AR_GET_ACCT_ACTION_ITEMS return flist is as shown below:

# number of field entries allocated 20, used 5
0 PIN_FLD_POID POID [0] 0.0.0.1 /billinfo 8402606 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 15
1 PIN_FLD_POID POID [0] 0.0.0.1 /item/payment 8396195 1
1 PIN_FLD_ITEM_NO STR [0] "P1-28"
1 PIN_FLD_NAME STR [0] "Payment"
1 PIN_FLD_ITEM_TOTAL DECIMAL [0] -100
1 PIN_FLD_DUE DECIMAL [0] -100
1 PIN_FLD_TRANSFERED DECIMAL [0] 0
1 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1388535235) Wed Jan 01 00:13:55 2014
1 PIN_FLD_CREATED_T TSTAMP [0] (1388535235) Wed Jan 01 00:13:55 2014
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 8402094 0
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 0
1 PIN_FLD_AR_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 2
1 PIN_FLD_RELATED_BILL_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_RELATED_ACTION_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-8402094"
1 PIN_FLD_ALLOCATED DECIMAL [0] 0
0 PIN_FLD_RESULTS ARRAY [1] allocated 20, used 15
1 PIN_FLD_POID POID [0] 0.0.0.1 /item/payment 8397087 1
1 PIN_FLD_ITEM_NO STR [0] "P1-32"
1 PIN_FLD_NAME STR [0] "Payment"
1 PIN_FLD_ITEM_TOTAL DECIMAL [0] -500
1 PIN_FLD_DUE DECIMAL [0] -500
1 PIN_FLD_TRANSFERED DECIMAL [0] 0
1 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1388570662) Wed Jan 01 10:04:22 2014
1 PIN_FLD_CREATED_T TSTAMP [0] (1388570662) Wed Jan 01 10:04:22 2014
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 8402094 0
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 0
1 PIN_FLD_AR_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 2
1 PIN_FLD_RELATED_BILL_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_RELATED_ACTION_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-8402094"
1 PIN_FLD_ALLOCATED DECIMAL [0] 0
0 PIN_FLD_RESULTS ARRAY [2] allocated 20, used 15
1 PIN_FLD_POID POID [0] 0.0.0.1 /item/payment 8397537 1
1 PIN_FLD_ITEM_NO STR [0] "P1-33"
1 PIN_FLD_NAME STR [0] "Payment"
1 PIN_FLD_ITEM_TOTAL DECIMAL [0] -900
1 PIN_FLD_DUE DECIMAL [0] -900
1 PIN_FLD_TRANSFERED DECIMAL [0] 0
1 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1388570804) Wed Jan 01 10:06:44 2014
1 PIN_FLD_CREATED_T TSTAMP [0] (1388570804) Wed Jan 01 10:06:44 2014
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 8402094 0
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 0
1 PIN_FLD_AR_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 2
1 PIN_FLD_RELATED_BILL_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_RELATED_ACTION_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-8402094"
1 PIN_FLD_ALLOCATED DECIMAL [0] 0
0 PIN_FLD_RESULTS ARRAY [3] allocated 20, used 16
1 PIN_FLD_POID POID [0] 0.0.0.1 /item/payment 8400159 3
1 PIN_FLD_ITEM_NO STR [0] "P1-34"
1 PIN_FLD_NAME STR [0] "Payment"
1 PIN_FLD_ITEM_TOTAL DECIMAL [0] -100
1 PIN_FLD_DUE DECIMAL [0] 0
1 PIN_FLD_TRANSFERED DECIMAL [0] -100
1 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1388572274) Wed Jan 01 10:31:14 2014
1 PIN_FLD_CREATED_T TSTAMP [0] (1388572274) Wed Jan 01 10:31:14 2014
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 8402094 0
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 2
1 PIN_FLD_AR_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 8402606 2
1 PIN_FLD_PAY_TYPE ENUM [0] 10011
1 PIN_FLD_RELATED_BILL_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_RELATED_ACTION_ITEM_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-8402094"
1 PIN_FLD_ALLOCATED DECIMAL [0] -100


EXPECTED BEHAVIOR
--------------------------
When we call PCM_OP_AR_GET_ACCT_ACTION_ITEMS opcode  with this fields PIN_FLD_AMOUNT_FROM = 400 and PIN_FLD_AMOUNT_TO = 800
The amount should be filtered based on the condition set in the input flist and return the payment with the value 500.

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