My Oracle Support Banner

What does TB_CORE_ENTY_NAME_PARTS Table Contain NULL Value For NAME_PART_TYPE_CODE in the Pre-migrate Script Logfile Means? (Doc ID 2805404.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

Oracle Healthcare Data Repository - Version 8.1 and later
Information in this document applies to any platform.

Goal

The purpose of this document is to explain the cause of the following entry in the pre-migrate logfile while running the pre-migrate script  such as  ./migrate_sciripts/prevalidate/roles_incorrect_data.sql:

   Following entries in CTB_CORE_ENTY_NAME_PARTS table contain NULL value for NAME_PART_TYPE_CODE.
   So they cannot be mapped to any column in OHF_HDR_%_NAME tables.
   Entity Id: 406982, Entity Version Num: 1, Entity Name Part Id: 1
   Entity Id: 406977, Entity Version Num: 1, Entity Name Part Id: 1 
   Entity Id: 406981, Entity Version Num: 1, Entity Name Part Id: 1

Solution

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
Goal
Solution


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