HI @AjayKumar Maddipati - Thanks for your response. Helpful. I was however looking for Legal Seniority & Legal Hire Date. I have Enterprise Seniority/ Hire Date in my report already but would like to add the Legal ones too. Can you suggest on the above please? Regards, Abhishek

Hi @Nishanth B Jain - Thanks for your swift response. Will try this option at my end. This is helpful! Regards, Abhishek

Hi @Nishanth B Jain - Thanks for your response. I checked it, I think the scheduler option I see in OTBI at my end is different than what you showed in here. I feel the one you showed is from BIP, is it? Below is the one what i see in my scheduler - let me know if you have any idea around this one - thanks in advance!…

Hi @Amrita Gupta-Oracle - Also, in the meantime, i tried doing some alternatives to do the exclusion. I put up below formula so that i could exclude 1 & keep only 0 thru filter in Criteria page however when i see the output for below formulae, it only shows 0 for all records (whereas it should show 1 for 4 persons). Not…

Hi @Amrita Gupta-Oracle - No I didn't. I feel simple RCount is not providing what you see in the results at your end. Regards, Abhishek

Hi @Amrita Gupta-Oracle - I am afraid, because when I use this one, i only see value as 1 for all records (incl. duplicates).. am i missing something in here?

Hi @Amrita Gupta-Oracle - thanks so much for your response, this is really helpful. However, when i applied this, i do get results like below (which is what you mentioned in your response already). Wondering: is it feasible to get an output for the duplicate records as 1,2,3.. intent is to take them out through the report.…

Hi @ravikiran goda-Oracle - i didn't. where can i check this, can you advise pls? thanks in advance. Regards, Abhishek

Hi @Mandeep Gupta - You're right, I will now use the country code from Location description to do a country mapping thru SQL. REgards, Abhishek

Hi @Priscila Terazawa-Support-Oracle - No worries - thanks for your response & assistance. Regards, Abhishek

Hi @Ramprapanna Bhattacharya-Oracle Thanks for your response. I was open for any SA if its available, however in my current report I was using WF Mgt - Worker Assignment Real Time. REgards, Abhishek

Hi @Amrita Gupta-Oracle - Thanks for your response. Have added in this field in the report i built, this helps however my query was mainly on creating a flag for Supervisor (while comparing with Person Number) to understand if the existing Supervisor is active or in-active. In our organization, Manager Flag & Direct…

Hi @Jahnavi-Oracle - Thanks for your response & explanation. You are right, the former approach won't provide exactly what I want to achieve. Later approach would be more appropriate. Thanks so much! Regards, Abhishek

Hi @Priscila Terazawa-Support-Oracle Thanks for your quick response. Unfortunately, I don't see any out of box queries in given path: /shared/Sales/Subject Area Contents/Saved Queries - OTBI.. most probably, they are only available with an admin access levels. Sales - CRM Resource and retrieve the hierarchy from Employee /…

Hi @Bhaskar Konar In my case, below one worked quite well. Thanks again! CAST(TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date", CURRENT_DATE) AS FLOAT) / 365 Regards/ Abhishek

Hi @Bhaskar Konar This worked - thanks for your kind assistance! Cheers! Abhishek

Hi @Bhaskar Konar Thanks for your response. Below shared is the calculation i tried - using CURRENT DATE function & Seniority Date field (to calculate in time tenure). Hope below snap helps understand about my query better. Regards, Abhishek

Hi @Bharath Raghupathi-Oracle Thanks for your response. Though this is helpful, however this will perhaps filter out the Person number report for all those colleague who is also present in Manager Person Number field. I wanted to create a flag field (as Yes/ No) in the report -> Yes, if person is present in Manager Person…

Hi Konar - Sure. Manager Flag is an appropriate field to refer to. However, as you mentioned its not a mandate field for ORG, I do see some DQ updates required to better use the output. In addition, Assignment Status Type (under Manager folder) is useful to understand the current status however again, DQ updates required…

HI Konar, Many thanks for your assistance - this helps. Cheers!