KEY NOT FOUND ERROR while editing T2T "T2T_KDD_CASE_ACCT_SMRY_MNTH" (Doc ID 2809328.1)

Last updated on MAY 13, 2022

Applies to:

Symptoms

Object Import failing. Getting KEY NOT FOUND ERROR while editing T2T "T2T_KDD_CASE_ACCT_SMRY_MNTH"

Steps to reproduce the issue:

1st - Navigate to ECM -> Common Tasks -> Unified Metadata Manager -> Data
Integrator Framework -> Warehouse Designer -> Data Mapping;
2nd - Search for "t2t_KDD_CASE_ACCT_SMRY_MNTH";
3rd - Try to edit it;
4rd - you will get the same issue we got - "Key not found

Work around:

1. Execute the below query and get the object id

select * from aai_object_b where v_obj_code='t2t_KDD_CASE_ACCT_SMRY_MNTH'

2. Run the below query to filter the definition id and Src column id

SELECT * FROM AAI_DMT_MAPPING_DETAILS WHERE V_DEFINITION_ID = '’ AND V_SRC_COLUMN_ID = 'ACCT_SMRY_SEQ_ID';

3. See if V_SRC_TABLE_ID column having “FCC_ACCT_SMRY_MNTH” or not by executing above query. If not, please update it as below.

UPDATE AAI_DMT_MAPPING_DETAILS SET V_SRC_TABLE_ID = 'FCC_ACCT_SMRY_MNTH' WHERE V_DEFINITION_ID = '’ AND V_SRC_TABLE_ID = 'EXPRESSION'

Cause

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