Question

Employee_ID Database_ID

Michael Kaiser
Rank
Userlevel 4
Badge +7

Hi,

for external (QlickView) security reasons we need the following format in the DIM_Employee/DIM_Person in the datawarehouse.

FirstCharacterSurName+LastName. Like MKAISER (michael.kaiser@company.de)

While I’m in the IFS mask
Solution Manager > Security > Users > Create User
I will see IDENTITY and Database ID: with the formatting above.

The System Info stays empty and the debug console don’t show anything.

So any hints, in which View/Table I can find an PERSON_ID and DATABASE_ID in one row?

 

Thanks a lot!

All the best.

 

Michael

 

Know your goal, ask relevant questions, decide strong, fast and smart.

2 replies

Jens
Rank
Userlevel 4
Badge +8

Hi,

you have to use the views FND_USER and PERSON_INFO to get these information.

In FND_USER us the field IDENTITY and join it with the field USER_ID of PERSON_INFO to get the PERSON_ID. The other mentioned fields will be in FND_USER.

But not every user in FND_USER must have a corresponding PERSON_ID in PERSON_INFO.

/Jens

Michael Kaiser
Rank
Userlevel 4
Badge +7

Hi Jens,
that did the job! Brilliant!
I tried to join the Active Directory Data but the displayname there and the internaldisplay from ifs do not match all the time.

ü, ö, ä , missing commas and other stuff :-(

Thank you!!

 

all the best

 

Michael

 

Know your goal, ask relevant questions, decide strong, fast and smart.

Reply


Terms & ConditionsCookie settings