My Oracle Support Banner

KYC[807]: Excel Upload KDD_CODE_SET_TRNLN Fails With Unexpected Unknown Error (Doc ID 2759568.1)

Last updated on MARCH 16, 2021

Applies to:

Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

Customer requires bulk updating (excel upload) of data to in the KDD_CODE_SET_TRNLN table. There are more than 2000+ custom entries that are required for KYC risk model use. client does not want to use SQL update/insert/delete where ever possible because of restriction of access in a production environment setting, and would prefer to perform this on through OFSAA UI by using bulk upload feature. However, below record fails to insert blank value in 'Not null' column.

select * from KDD_CODE_SET_TRNLN where code_val ='h-z'

Cause

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
Symptoms
Cause
Solution


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