OTBI
Discussion List
-
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the … -
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an…Becky Stalsby 234 views 13 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Enrollment effective end date meaningSummary: Enrollment effective end date meaning Content (please ensure you mask any confidential information): Hello experts, I've created a report with the Learning Reco…Oriana L. 11 views 3 comments 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Performance Documents Competency Assessment TasksSummary: Looking for the Performance Documents Competency Assessment Tasks assessee and assessor data Content (please ensure you mask any confidential information): Hell…
-
how to report learners in waitlist otbiSummary: how to report learners in waitlist otbi Content (please ensure you mask any confidential information): Hello experts, we would like to create an OTBI analysis t…
-
How to fetch SourceRef values loaded via hdl?Summary: We are loading some source reference values while loading allocated checklist to employees. However I am not sure how to fetch this values in an OTBI and BI rep… -
How to set in OTBI report the difference between a variable (an input parameter) and a fieldSummary: How to set in OTBI report the difference between a variable (an input parameter) and a field Content (please ensure you mask any confidential information): Hi, …Barile Alberto 73 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid…AjayKumar Maddipati 23 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn…Oriana L. 44 views 3 comments 1 point Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …Oliviero Riva 22 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 16.7K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OCI: Infrastructure utilization statsHello Team, Please guide on how to generate the following reports Infrastructure utilization stats Including for the peak times - store opening and closing We want to ma…Wale Odusanya 11 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Transpose rows to columns for RatingsSummary: I want to show the ratings of two specific performance document section names in columns. I named the header like the section name. I used a "CASE WHEN" stateme…
-
Is it possible to create an OTBI report that will show payment details by payment date and employee?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Chris West 42 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Multiple Values in PIVOT tableSummary How to have multiple values in Pivot tableContent Hi I want to have a pivot table where i want to show the Competencies in measure with competency type as Column…Jagdish Varadraj 56 views 3 comments 0 points Most recent by Krishna_Vellela525 Reporting and Analytics for HCM -
Fusion HCM Table Column to fetch "New Hire Status"Please guide us with Table.Column to fetch "New Hire Status" information for an employee. PFA image for UI screenshot.Ranganatha_CV 45 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Not possible to use the phase/state name joining other subject area in OTBI analysisHi all, We are trying to create an Analysis in OTBI with Recruiting data. For this, we are joining the "Recruiting - Recruiting Events Real Time" and the "Recruiting - R…
-
Pre-Active and Post-Active Details OTBI subject areaSummary: Pre-Active and Post-Active Details OTBI subject area Content (please ensure you mask any confidential information): Hello Experts, I'm currently using the OTBI …
-
'Sort Column' doesn't workI created this pivot table but seems like function 'Sort Column' only works for 'Person Number' column which is all numbers. I'm looking for sorting report by 'District'…Yiming Xiong 12 views 4 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
Is it possible to use CASE to replace 4712/12/31 with CURRENT_DATEContent (please ensure you mask any confidential information): I'm using the Compensation - Salary History Details Real Time to return the "Salary Details"."To Date" fie… -
Custom ESS Audit ReportSummary: I am trying to find instructions on how to build a report that will contain all ESS transaction history (before and after data). Could someone please assist on …Pamela_Diaz 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Specializations not pulling in Enrollment typeSummary: I pulled a report for Learning Assignments (To match the Learning Assignments Screen that summarizes a Team Members Learning Assignments) The screen shows the s…THawkins_LGI 22 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Seeded data models renewal /shared/Human Capital Management/Workflow NotificationsSummary: We have compared with demo environment that we have old DM and templates in /shared/Human Capital Management/Workflow Notifications. How we can get latest /shar…
-
Reporting on Seniority DatesSummary: Our OTBI reporting only has 2 Seniority Date codes when there should be 5. Content (please ensure you mask any confidential information): When I run a simple re…Kevin Orze 34 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Location or Functional access to Absences for Higher Grade ManagersSummary: I currently have a business case to develop an absence calendar which provides managers at a certain grade access to the absences for their Location and Functio…Dan_Hinsley 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Custom Dashboard look and feelHi Team, My customer has shared a requirement to customize a OTBI dashboard and wanted to view like attached image. Is there any option to make such graphical view? Plea…Mohan Murali P-Oracle 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Brazil HR unable to access the Custom folder under OTBISummary: Has anyone had issues with their Brazil HR being unable to see the Custom folder in OTBI? If I log in from Canada as this Brazil HR person, I can see the Custom…Crystal Adrian 11 views 3 comments 0 points Most recent by Dan_Hinsley Reporting and Analytics for HCM
-
Some job codes drop from report when I add minimum from grade rate valueSummary: I have a report from Compensation - Workforce Assignment Salary Real Time. I added job code (filtered to included >0499), job name, FLSA status and it's working…Sherie Ross 33 views 9 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …AprilleLyn 98 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM