KEY NOT FOUND ERROR while editing T2T "T2T_KDD_CASE_ACCT_SMRY_MNTH"
(Doc ID 2809328.1)
Last updated on SEPTEMBER 28, 2021
Applies to:Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.
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
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'
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