Issue Occured On Non-currency Resources While They Were Migrated (Doc ID 1912982.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Symptoms

During migration, non-currency resources are migrated with 2 different validity periods:

 Configuration:

  1. Add the below entry in $PIN_HOME/apps/cmt/Infranet.properties infranet.cmt.deleteExistingBalances = false
  2. Restart services
 
  Steps:
  1. Load an account via Conversion Management Tool (CMT) (there are no balances/subbalances at this point)
  2. Load balance, sub-balance with resource_id = 100040 and balance 500
  (correspoding bal_grp_bals_t and bal_grp_sub_bals_t are created successfully)
  3. Load balance, sub-balance with resource_id = 100041 and balance 800
 
  Actual Behavior:
  ===========
  When infranet.cmt.deleteExistingBalances is set to false,
 

SQL> select bg.poid_id0, bg.realtime_cntr, bgsb.rec_id2, bgsb.rec_id from
  bal_grp_t bg, bal_grp_sub_bals_t bgsb where bg.account_obj_id0 = 438516 and
  bg.poid_id0 = bgsb.obj_id0 order by bg.poid_id0, bgsb.rec_id, bgsb.rec_id;
 
   POID_ID0 REALTIME_CNTR    REC_ID2     REC_ID
  ---------- ------------- ---------- ----------
     450036             0     100041          2
     450036             0        978             3
     450036             0     100040          3
     450036             0     100040          4
 
  Expected Behavior:
  ======================
  When infranet.cmt.deleteExistingBalances is set to false,
  SQL> select bg.poid_id0, bg.realtime_cntr, bgsb.rec_id2, bgsb.rec_id from
  bal_grp_t bg, bal_grp_sub_bals_t bgsb where bg.account_obj_id0 = 422412 and
  bg.poid_id0 = bgsb.obj_id0 order by bg.poid_id0,bgsb.rec_id, bgsb.rec_id;
 
   POID_ID0 REALTIME_CNTR    REC_ID2     REC_ID
  ---------- ------------- ---------- ----------
     433932             6     100041          2
     433932             6     100040          4
     433932             6        978             6

Changes

Cause

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