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

Last updated on OCTOBER 09, 2023

Applies to:

Goal

One user wants 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, the main opcode PCM_OP_PYMT_COLLECT.
Step 2 - Suspend the payment made to the account, the main opcode PCM_OP_PYMT_RECYCLE_PAYMENT.
              If you want to use client tools, then select the option "Undo Allocation" from the Payment Center.
Step 3 - Allocate the payment, which is now on the suspended account, to an account on schema 2, the main opcode PCM_OP_PYMT_RECYCLE_PAYMENT.

Below is the snippet of the error in 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 <HOSTNAME> cm_api:24739 fm_bal_get_balances.cpp:190 1:<HOSTNAME>: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 <HOSTNAME> cm_api:24739 cm_child.c(119):4851 1:<HOSTNAME>: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 <HOSTNAME> cm_api:24739 pcm.c(57):929 1:<HOSTNAME>: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 <HOSTNAME> cm_api:24739 fm_bal_get_balances.cpp:777 1:<HOSTNAME>: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 <HOSTNAME> cm_api:24739 fm_bal_get_balances.cpp:778 1:<HOSTNAME>: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 <HOSTNAME> cm_api:24739 fm_bill_utils_bal_utils.cpp:4090 1:<HOSTNAME>: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 <HOSTNAME> cm_api:24739 fm_bill_utils_bal_utils.cpp:4094 1:<HOSTNAME>:testnap:24737:-135448880:3739:1368189001:1

dm_oracle.pinlog:

D Fri May 10 14:30:01 2013 <HOSTNAME> dm:20313 pcm_tbls.c(21):313 1:<HOSTNAME>:testnap:24737:-135448880:3739:1368189001:1
libpcmext64.so Library initialized
D Fri May 10 14:30:01 2013 <HOSTNAME> dm:20313 pcm_tbls.c(21):316 1:<HOSTNAME>:testnap:24737:-135448880:3739:1368189001:1
 PCMEXT initialized with 0 function failures
M Fri May 10 14:30:01 2013 <HOSTNAME> dm:20313 dm_search.c(110):3299 1:<HOSTNAME>:testnap:24737:-135448880:3739:1368189001:1
in update size is 1000 (default)
E Fri May 10 14:30:01 2013 <HOSTNAME> dm:20317 dm_ops.c(249):3728 1:<HOSTNAME>: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 <HOSTNAME> dm:20317 dm_back.c(31):1440 1:<HOSTNAME>:testnap:24737:-135448880:3739:1368189001:1
  DMbe #4: process_op: op 4(PCM_OP_READ_FLDS), err 3(PIN_ERR_NOT_FOUND)

Solution

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