OTBI
Discussion List
-
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex…Rebekah Gilday 85 views 9 comments 0 points Most recent by Diane G123 Reporting and Analytics for HCM -
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will … -
We have a requirement to fetch salary component calculation columns in OTBI and a stat graph.Summary: We have a requirement to fetch all these calculation columns in OTBI as we have partially developed the solution in BIP, but client want this in OTBI so can we …Kumar Rajgeet 42 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Grade MidpointSummary Joining Worker Assignment Real Time to Grade Rate Real TimeContent Hi, we're currently building reports for use in UAT ahead of upgrade to Cloud next year. I've …User_2025-02-08-05-56-00-229 19 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…User_2025-01-28-07-12-45-467 132 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …User_2025-01-31-00-03-33-089 292 views 25 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag…User_2025-01-28-20-43-56-568 38 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Comparing columns from two different Analysis areas.Summary Comparing columns from two different Analysis areas.Content I am attempting to grab Job Codes for employees and the grades for the jobs. In the analysis i am usi…User_2025-02-10-19-21-48-801 37 views 14 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with Grade Rate Real Time Subject AreaSummary Grade Rate value is not returnedContent We had a requirement to display all workers who has a current salary not equal to the current grade step rate value i.e, …Akash Kiran Jana 30 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to report on missing Costing of Positions?Summary: Content (please ensure you mask any confidential information): I'm trying to find a way to report on Position Costing that is missing. In the 'costing of positi…Leanne W 120 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic…
-
Parameter definition in reportI will use the last_update_date parameter in the report I prepare. But I want to use the last_update_date column in more than one table in a single parameter. For Ex: pe…Cansel Karasoy 21 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
manager hierarchy analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bhagyashri_Bhoge 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Standard template Compensation Change statements notificationContent Hello experts, I need to change the notification template the employee receive when Compensation Change Statements is available in Person Information> My Compens… -
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…Kalyani Koylada 873 views 8 comments 0 points Most recent by Tonya H Reporting and Analytics for HCM
-
Only display the row with the earliest seniority dateSummary: Hi I'm creating a basic staff list which has seniority date on (some of our staff have protected service from a previous company) and I need to be able to show …HRJon 42 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to get latest anniversary seniorSummary: How to get the most recent date to show on an employee transaction Content (please ensure you mask any confidential information): In OTBI, using the subject 'Wo…EllieG 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to add the EEO 4 field from Job to a OTBI report?Summary: Adding EEO 4 field to a OTBI report Content (required): Hello - how can you add the EEO 4 field to a OTBI report? I am able to locate the EEO-1 field but not EE…Jbow 54 views 1 comment 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM
-
Payroll - Calculation Cards Real TimeContent Good Morning, We are trying to find granular details with regards to Pension details. On the front end we can see in a sub-folder called 'Calculation Component D…User_2025-01-28-07-12-45-467 188 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 104 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
How to export OTBI Dashboard Section Permission?Summary: I am looking for an option to export the permissions granted at each section level. Is this possible? I attached the screenshots. I appreciate your help. thanks…SantoshKumarBhairi 11 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
General help -> Unable to access oracle.comSummary Unable to access oracle.comContent hello, Is anyone facing this type of issue? I am unable to access any site within oracle.com. Nothing changed in my browsers a…SantoshKumarBhairi 176 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on…
-
In past we get all questions from prescreen questions report but now two questions missing ?Summary: HI Team, In past we get all questions from prescreen questions report but now two questions missing ? any refrence and help me on . Please find issued SQL file.…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Representing the data in graphs using custom formulas and logics in OTBI Dashboard.Summary: Representing the data in graphs using custom formulas and logics in OTBI Dashboard. We have a requirement to create a graphs in OTBI using the Absence Balances,…Bhukya Vamsi Naik 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report to get list of users who are lockedSummary I need to get a list of locked user accountsContent I looked at the 'Reporting on Application Users and Roles' section the Oracle documentation, but none of thos…David Villegas 1.6K views 17 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How do you retrieve Payroll Relationship Close date into report in OTBI?Summary: Content (required): Looking to include close date off the payroll relationship field into an OTBI analysis report, I have looked at a few subject areas but this…
-
Is there a way to show only data for a user that is running a dashboard?Summary: I have created a dashboard for several reports. It shows the user that last updated a record. Is it possible for the user that runs the dashboard to show only r… -
OTBI Report Source System Item Real TimeSummary: When i join Item Number and one of my EFF attribute in Product table i am getting one extra row in EFF table which is all blank. Do you know what might be the i…Ankit Shah 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 70 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM