Bankruptcy Details Sub Attribute Field Not Migrated when account is boarded through conversion (Doc ID 3074965.1)

Last updated on MARCH 05, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Bankruptcy Details sub attribute field not migrated via conversion route

Bankruptcy details sub attribute field (ABD_BKRP_TYPE_DETAILS_SUB_CD in BKRP_DETAILS) is not migrated when account is boarded through conversion jobs.

Neither this field exposed in the attributes api file (api_att_111.dat), Nor it is selected during migration from the user defined flex table BKRP_TYPE_DETAILS_CD:

in accsel_el_100_01, sel_abd_details procedure, ibkrp_details table is populated from api_att_111 file data for the attribute type BKRP, but sub attribute is not populated:

  FOR ATT_REC IN (SELECT *
  FROM API_ATT_EVW
  WHERE -- --- ---
  AND ATT_TYPE = 'BKRP')
  LOOP
  
  -- -- ---
  IV_IABD_TBL(IDX).ABD_BKRP_TYPE_DETAILS_CD := ATT_REC.ATT_FTA_TABLE_ATTRIBUTE;
  IV_IABD_TBL(IDX).ABD_VALUE := ATT_REC.ATT_VALUE;
  --- ---- ----

Same is then used to populate the servicing table in accaai_en_111_02, insert_bankruptcy procedure:

  INSERT INTO ACC_ABD_EVW
  (
  ABD_AAD_ID
  --- ---- - --
  ,ABD_BKRP_TYPE_DETAILS_CD
  ,ABD_VALUE
  ,ABD_BKRP_TYPE_DETAILS_SUB_CD
-- --- - ---
  )
  SELECT
  IV_ACC_AAD_ID
  --- ---- ---
  ,ABD_BKRP_TYPE_DETAILS_CD
  ,ABD_VALUE
  ,ABD_BKRP_TYPE_DETAILS_SUB_CD
  --- ----
  FROM API_IABD_EVW
  WHERE -- --- ---

Ideally customer should have a way to provide these sub attribute strings or have them taken from FTA setup during migration

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.