Skip to main content
Question

Employee_ID Database_ID

  • July 13, 2022
  • 2 replies
  • 104 views
Michael Kaiser
Sidekick (Customer)
Forum|alt.badge.img+9

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
Hero (Employee)
Forum|alt.badge.img+10
  • Jens
  • Hero (Employee)
  • 137 replies
  • July 13, 2022

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
Sidekick (Customer)
Forum|alt.badge.img+9
  • Michael Kaiser
  • Author
  • Sidekick (Customer)
  • 117 replies
  • July 13, 2022

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.


Terms & ConditionsCookie settingsAccessibility statement