Introduction
There might have been situations in the course of an HCM Cloud implementation project which has an outbound interface (generally referred to as HCM Extract) where one or more of the DBI used in the HCM Extracts might not return expected values.
There are many ways to troubleshoot this issue. Some of the common ways being:
- Using OTBI Subject Area
- Using BI SQL Data Model
- Displaying DBI value on UI (using Fast Formula)
In this example we will demonstrate the same.
For this example, we would try to find the value of “PER_ASG_MARITAL_STATUS”. Assuming we were using “PER_EXT_PAY_EMPLOYEES_V2_UE” we can get an idea of which specific database field holds the value.
One can get to know the query underlying a UE from Data Exchange -> User Entity Details ->Query
Also from OTBI Database Lineage Mapping sheet we can get details of the Database column which holds details of “Marital Status” field.
This clearly shows that the database field which holds the data is PER_PEOPLE_LEGISLATIVE_F.MARITAL_STATUS
Also we will create a custom Fast Formula say TEST_DBI_VALUE of Global Absence Entry Validation Fast Formula which would display the DBI Value.
Now we will proceed with verifying the Marital Status value of a colleague.
Marital Status Value as seen from UI (Manage Person)
We will choose John Roberts (Person Number 120) for this demonstration.
We can see from above screenshot that Marital Status of John Roberts is “Single”
Verification Using OTBI Subject Area
We would use “Workforce Management – Person Real Time” subject area and try to display person number and marital status field.
Verification Using BI SQL
We can also validate the value using a SQL.
Displaying DBI Value from UI (using Fast Formula)
For this we would need to associate the custom “Global Absence Entry Validation” Fast Formula “TEST_DBI_VALUE” created above earlier to any existing absence type (we choose “Unpaid Absence AU” for this example).
Now when we try to book an absence of “Unpaid Absence AU” for John Roberts we will get the value of DBI Item (PER_ASG_MARITAL_STATUS)
Summary
So this is how we can check the value of a DBI Item in various different ways.
That’s all from my side, hope you guys had a good time reading this article.
Thank you all for your precious time and with this I end my last article for year 2019.
I wish all of you a very HAPPY, PROSPEROUS & EVENTFUL NEW YEAR.
Comments
which provides these things in quality?
through Google, and found that it's truly informative.
I am going to watch out for brussels. I'll appreciate if you continue this in future.
Lots of people will be benefited from your
writing. Cheers!
and other person will also do similar in favor of you.
It really useful & it helped me out much. I hope to give something back and aid others
like you helped me.
you sound like you know what you're talking
about! Thanks
has truly peaked my interest. I will book mark your site and keep checking
for new details about once per week. I opted in for your Feed too.
The arena hopes for even more passionate writers like you
who are not afraid to mention how they believe. At all times go after your heart.
My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no back up.
Do you have any methods to protect against hackers?
that you just shared this useful info with us. Please keep us up to date like this.
Thanks for sharing.
this particularly fantastic read!! I definitely
appreciated every bit of it and i also have you book marked to look
at new information on your site.
Im really impressed by it.
Hey there, You have done a fantastic job.
I'll certainly digg it and in my opinion suggest to my friends.
I am confident they will be benefited from
this site.
Just wanted to say I love reading your blog and look forward to all your posts!
Carry on the outstanding work!
I have always disliked the idea because of the expenses.
But he's tryiong none the less. I've been using WordPress on a variety of websites for about
a year and am nervous about switching to another platform.
I have heard great things about blogengine.net.
Is there a way I can transfer all my wordpress content
into it? Any help would be greatly appreciated!
nice, all can without difficulty be aware of it, Thanks a lot.
custom writings how to teach essay writing
platform are you using for this website? I'm getting tired of Wordpress because I've had issues with hackers and I'm looking at options for another platform.
I would be great if you could point me in the direction of a good platform.
I want to encourage one to continue your great writing, have a nice evening!
RSS feed for comments to this post