Hi I am writing an analysis where I need first and last name of manager sepertaly from Oracle HCM BI. I got the first name using Left. How do I take the last name. If I take the last name it comes with the middle name
Hi,
Which Subject Area(SA) are you using?
Do you mean to say, that no separate columns are available in that SA?
Regards,
Raghavan
Hi Parvathi,
Which subject area are you using? Are you using (Full) "Name" not "Display Name"?
Assume this is not your query because this subject area has the fields you need?
select all "Person Names (Global)"."Full Name" s , "Person Names (Global)"."Last Name" , "Person Names (Global)"."First Name" , "Person Names (Global)"."Middle Names" , "Person Names (Global)"."Display Name" , "Person Names (Global)"."List Name" from "Workforce Management - Person Real Time" order by 1 asc nulls last fetch first 7 rows only
Are you looking at the manager of a person worker assignment or event?
select all 0 s_0 , "Manager"."Name" s_1 , "Manager"."Person Identifier" , "Manager"."Person Number" from "Workforce Management - Worker Assignment Real Time" order by 1 asc nulls last, 2 asc nulls last, 3 asc nulls last fetch first 7 rows only
So an option is to join to the person subject area using the manager person id if you want the extra fields.
Unfortunately the concept of first middle last name implemented by Oracle is not a very good fit in our modern multi-cultural global world. Many systems use instead Family Name and Other Names. So it may not be a great idea to split up the name in the first place. But if you have a good business case to do so then…
Be careful using function left and right. The format of a full name is something that is configured in the system by your application implementation consultant by legislation country. So it may be that in UK you have setup full name as "First Name, Last Name" but in the US you have setup "Last Name, First Name" etc. So make sure you check your configuration before making any assumptions that a single format is true for all rows.
Thank you so much for the reply. I was able to separate first and last name using substring, left and right functions. SUBSTRING((TRIM(BOTH ' ' FROM (SUBSTRING("Manager"."Name" FROM (POSITION(' ' IN "Manager"."Name")) FOR 100)))) FROM (LOCATE(' ', (TRIM(BOTH ' ' FROM (SUBSTRING("Manager"."Name" FROM (POSITION(' ' IN "Manager"."Name")) FOR 100)))))) FOR 100)
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
We would like to understand the reason for the difference in configuration options for the “Send Message to Team” action across the Redwood VBCS Recruiting pages. Currently, we observe the following behavior: On the Job Requisition and Job Requisition List pages, it is possible to hide/remove the “Send Message to Team”…
Is there a way to extract existing BIP reports saved in a specific folder? Like can capture Report Name, Report Path and Owner for example?
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
