Talent Profile HDL Error JBO-27008: Attribute ProfileId in view object ProfileItemLogical cannot be set (Doc ID 2724573.1)

Last updated on OCTOBER 25, 2022

Applies to:

Symptoms

On : 11.13.20.07.0 version, Data Load

When attempting to load Talent Profile Education Items via HDL, the load completes for some employees successfully, but for others the following error occurs.

ERROR
-----------------------
JBO-27008: Attribute ProfileId in view object ProfileItemLogical cannot be set.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to load Talent Profile Education Items via HDL
2. Encounter the error message above for some employees, but for others the file completes successfully
3. Confirm that the output of the query below

select papf.PERSON_NUMBER, hpb.PROFILE_ID, hpb.PROFILE_CODE, hpb.CREATED_BY, hpb.CREATION_DATE, hpb.PROFILE_STATUS_CODE, hpb.PROFILE_USAGE_CODE, hptb.PROFILE_TYPE_CODE
from fusion.PER_ALL_PEOPLE_F papf, fusion.HRT_PROFILES_B hpb, fusion.HRT_PROFILE_TYPES_B hptb
where papf.PERSON_NUMBER in
(
'<PersonNumber1>',
'<PersonNumber2>',
'<PersonNumber3>'
)
and papf.PERSON_ID = hpb.PERSON_ID
and hpb.PROFILE_TYPE_ID = hptb.PROFILE_TYPE_ID

that the

a. ProfileCode and associated PofileId values are correct
b. Profile Status Code is Active or A
c. Profile Usage Code is Person or P
d. Profile Type Code is PERSON

Cause

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