Need To Update ORG_NAME In Table "cn_repositories_all_tl" (Doc ID 1677193.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

Found values of columns "REPOSITORY_NAME" and "ORG_NAME" in table "CN_REPOSITORIES_ALL"
are different from the value of "NAME" in table "HR_ORGANIZATION_UNITS_F_TL".

For example :

select ORG_ID, ORG_NAME, REPOSITORY_NAME
from cn_repositories_all_tl
where ORG_ID = 300000000567191;

ORG_ID           ORG_NAME       REPOSITORY_NAME
300000000567191  XXX Group BU   XXX Group BU


select ORGANIZATION_ID, NAME
from HR_ORGANIZATION_UNITS_F_TL
where ORGANIZATION_ID = 300000000567191;

ORGANIZATION_ID NAME
300000000567191 XXX Operations


How to update columns "REPOSITORY_NAME" and "ORG_NAME" in table "CN_REPOSITORIES_ALL" to the same
as "NAME" in table "HR_ORGANIZATION_UNITS_F_TL".

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms