OTBI
Discussion List
-
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 18K 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 41 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 55 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 41 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 11 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 11 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 21 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 31 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 11 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 21 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 31 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 104 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
multiple phone numbers on single rowSummary: I have an employee report returning multiple rows when the employee has multiple phone types. Does anyone know how to correct so that the report only shows one …Gaby Castelan 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard Prompt: Year, Quarter,MonthSummary: Need help on OTBI Dashboard Prompt: Year, Quarter, Month with Variable Content (please ensure you mask any confidential information): We are working on a custom…Mohan Murali P-Oracle 52 views 1 comment 0 points Most recent by Mohan Murali P-Oracle Reporting and Analytics for HCM
-
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI report to fetch goal plan and its goalsHello, I'd like to create an OTBI report to fetch all the goal plans created and goals associated directly to each goal plan - even if goal plans and goals have not been…
-
OTBI Column Properties Data format First Name Last NameSummary: The current format is Last Name, First Name - is there a way to switch this with below Data Format? Content (please ensure you mask any confidential information…THawkins_LGI 24 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
New And Old Address ReportSummary New And Old Address ReportContent Hi All, I working on building a report which will populate Address Change ( Old & New) with Assignment & Location Change detail…User_2025-02-07-19-03-14-525 95 views 10 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - …
-
HCM Position Hierarchy standard report code file required which is running in backendHi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name so that w…Suresh Gandla-Oracle 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to give Delegations for Reporting?Summary: We would like a manager to allow an employee to pull reports for her direct reports We tried Role delegation and Approval Delegations but none of them help with…THawkins_LGI 21 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Learning Calendar reportSummary: Hi Folks, Learning calendar view is blank and does not have the calendar view Please help to fix this All other reports for learning calendar title and learning…Sowmiya Velusamy 122 views 7 comments 0 points Most recent by User_7DF56 Reporting and Analytics for HCM