My Oracle Support Banner

Handling Multi Schema Payment Transfer Via PCM_OP_PYMT_RECYCLE_PAYMENT (Doc ID 1559003.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

User want to transfer payment from account A on schema 1 to account B on schema 2.

SCENARIO
-------------
Step 1 - Make a payment to a account on schema1 : main opcode PCM_OP_PYMT_COLLECT
Step 2 - Suspended the payment made to the account. (If you want to use clients, then select the option "Undo Allocation" from the payment center) : main opcode PCM_OP_PYMT_RECYCLE_PAYMENT
Step 3 - Allocate the payment (which is now on the suspended account) to an account on schema 2 : main opcode PCM_OP_PYMT_RECYCLE_PAYMENT

Below is the snippet of the error cm.pinlog

    fm_bill_utils_set_def_billinfo input flist
# number of field entries allocated 20, used 13
0 PIN_FLD_ACCOUNT_OBJ    POID [0]../account 50605 0
0 PIN_FLD_PAY_TYPE       ENUM [0] 10012
0 PIN_FLD_AMOUNT       DECIMAL [0] 666
0 PIN_FLD_PAYMENT      SUBSTRUCT [0] allocated 20, used 2
1     PIN_FLD_DESCR           STR [0] "NAME1"
1     PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_CHECK_INFO    ARRAY [0] allocated 20, used 5
3             PIN_FLD_CHECK_NO        STR [0] ""
3             PIN_FLD_BANK_CODE       STR [0] ""
3             PIN_FLD_EFFECTIVE_T  TSTAMP [0] (31446000) Thu Dec 31 00:00:00 1970
3             PIN_FLD_BILL_NO         STR [0] ""
3             PIN_FLD_BANK_ACCOUNT_NO    STR [0] ""
0 PIN_FLD_STATUS         ENUM [0] 0
0 PIN_FLD_CURRENCY        INT [0] 985
0 PIN_FLD_COMMAND        ENUM [0] 0
0 PIN_FLD_EVENT_OBJ      POID [0] .. /event/billing/payment/check 278554673827420115 0
0 PIN_FLD_SUB_TRANS_ID    STR [0] "1368091234"
0 PIN_FLD_PAYMENT_REASONS  ARRAY [0] allocated 20, used 2
1     PIN_FLD_REASON_ID       INT [0] 2006
1     PIN_FLD_REASON_DOMAIN_ID    INT [0] 14
0 PIN_FLD_CHANNEL_ID      INT [0] 0
0 PIN_FLD_TRANS_ID        STR [0] "T2,4c,0"
0 PIN_FLD_ACCOUNT_NO      STR [0] "00002000010335"
D Fri May 10 14:30:01 2013  x  cm_api:24739  fm_bal_get_balances.cpp:190 1:dev:testnap:24737:-135448880:3739:1368189001:1
    op_bal_get_balances input flist
# number of field entries allocated 20, used 1
0 PIN_FLD_POID           POID [0] .. /account 50605 0
D Fri May 10 14:30:01 2013  x  cm_api:24739  cm_child.c(119):4851 1:dev:testnap:24737:-135448880:3739:1368189001:1
    opcode db: 3(..), context db: 2(..), trans_state: 2, opcode: 4
D Fri May 10 14:30:01 2013  x  cm_api:24739  pcm.c(57):929 1:dev:testnap:24737:-135448880:3739:1368189001:1
    pcm_op: cannot retry PCM_OP_READ_FLDS, flags 0x40000400 - in a transaction - state=2
E Fri May 10 14:30:01 2013  x  cm_api:24739  fm_bal_get_balances.cpp:777 1:dev:testnap:24737:-135448880:3739:1368189001:1
    error in op_bal_get_balances: input flist is
# number of field entries allocated 20, used 1
0 PIN_FLD_POID           POID [0] ../account 50605 0
E Fri May 10 14:30:01 2013  x  cm_api:24739  fm_bal_get_balances.cpp:778 1:dev:testnap:24737:-135448880:3739:1368189001:1
    op_bal_get_balances error
    <location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
    <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
    <facility=0 msg_id=0 version=0>
E Fri May 10 14:30:01 2013  x  cm_api:24739  fm_bill_utils_bal_utils.cpp:4090 1:dev:testnap:24737:-135448880:3739:1368189001:1
    fm_bill_utils_set_def_billinfo
    <location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
    <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
    <facility=0 msg_id=0 version=0>
D Fri May 10 14:30:01 2013  x  cm_api:24739  fm_bill_utils_bal_utils.cpp:4094 1:dev:testnap:24737:-135448880:3739:1368189001:1

 

dm_oracle.pinlog:


D Fri May 10 14:30:01 2013  x  dm:20313  pcm_tbls.c(21):313 1:dev:testnap:24737:-135448880:3739:1368189001:1
    libpcmext64.so Library initialized
D Fri May 10 14:30:01 2013  x  dm:20313  pcm_tbls.c(21):316 1:dev:testnap:24737:-135448880:3739:1368189001:1
    PCMEXT initialized with 0 function failures
M Fri May 10 14:30:01 2013 x  dm:20313  dm_search.c(110):3299 1:dev:testnap:24737:-135448880:3739:1368189001:1
    in update size is 1000 (default)
E Fri May 10 14:30:01 2013  x  dm:20317  dm_ops.c(249):3728 1:dev:testnap:24737:-135448880:3739:1368189001:1
    ERROR RFLDS: do_sql_select "select poid_DB, poid_ID0, poid_TYPE, poid_REV, gl_segment, currency, currency_secondary, item_poid_list, next_item_poid_list, bal_grp_obj_DB, bal_grp_obj_ID0, bal_grp_obj_TYPE, bal_grp_obj_REV from account_t where account_t.poid_id0 = :1", x=2, pp->id 50605
E Fri May 10 14:30:01 2013  dev  dm:20317  dm_back.c(31):1440 1:dev:testnap:24737:-135448880:3739:1368189001:1
    DMbe #4: process_op: op 4(PCM_OP_READ_FLDS), err 3(PIN_ERR_NOT_FOUND)

 

Solution

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
Goal
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.