OTBI
Discussion List
-
How to give an accees to a user to run custom ess jobSummary How to give an accees to a user to run custom ess jobContent Hello , I have created one custom report and i have creates custom ess job as well , Now i want to g…Koteswararao Yenikepalli 92 views 3 comments 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
Payment Reference Number field subject Area in OTBI for PayrollSummary Payment Reference Number field subject Area in OTBI for PayrollContent Hi All, We are trying to create payroll reconciliation report and we are almost completed … -
Auto-assignmentsSummary Required Courses & Offerings auto-assigning as VoluntaryContent Required courses and offerings are auto-assigning as Voluntary instead of Required. Once the cour…
-
Full-Time Equivalent Measure Will Not SuppressSummary When the Full-Time Equivalent measure was pulled into a Benefits report, the FTE is not suppressing, even though the column properties have been set to suppress.…User_2025-12-05-01-24-53-219 48 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Identify if comma is present in a fieldSummary How to do that in OTBI?Content Hi, we need to embed the following logic into OTBI report (CASE WHEN hr_loc.location_name like '%,%' then '"'||hr_loc.location_nam…Nicola Petri 14 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
OTBI Bursting ReportSummary Bursting report is not splitting out rows to recipientsContent Hello! I have an OTBI bursting report for absence balances. I've included a column with the user n…Susan Anderson 96 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Comprehensive Reporting Role in Fusion CloudSummary Role that has Access to all the Subject Areas/Dashboards/Reports. (Object Level as well as Data Level)Content Do we have a role other than BI Administrator that …Senthilrajan V 69 views 9 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
how to create a page in UI and add dashboard into it in release 20BSummary how to create a page in UI and add dashboard into it in release 20BContent Hi, how to create a page in UI and add dashboard into it in release 20B. 20B is very d…User_MC37Q 28 views 2 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Hiding prompt while exporting data from dashboardSummary Hiding prompt while exporting data from dashboardContent Hi Team, Can you please let me know how to hide the dashboard prompt while exporting data to excel. Than…
-
Dashboard with Prompts using LSQLSummary Write analyses for Dashboard with Prompts using LSQLContent Is there a way to write analysis using LSQL(more complex, which would have outer joins etc.) which ca…Jozef Kozak 60 views 6 comments 0 points Most recent by user10465876 Reporting and Analytics for HCM
-
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p…Mahgoub S.Mohamed 34 views 3 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM -
Can we lock the column order in the report outputSummary Can we lock the column order in the report outputContent Hi Team, Can we lock the column order in the dashboard output so that customer will not change the order…
-
Learning - Reporting on RecommendationsSummary Would like to report on who recommended learning items and to whomContent I would like to create a report to show who recommended learning items and to whom. I h…User_2025-01-25-05-06-07-246 57 views 3 comments 0 points Most recent by User_2025-01-25-05-06-07-246 Reporting and Analytics for HCM -
How to update the link for an embedded reportSummary Links for Embedded reportsContent Hi All, I am attempting to update the link for an embedded report after a recent copy from our production to test environment. …User_2025-02-04-08-51-08-912 34 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll Balance Duplicating with Multiple AssignmentsContent Hi, I am trying to write a report in OTBI to pull Gross Earnings in a specific time period, and I am running into a problem where the amount is duplicating in so…User_2025-02-08-04-27-03-855 98 views 1 comment 1 point Most recent by Anshul_Khandelwal Reporting and Analytics for HCM
-
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…User_2025-02-10-08-27-16-805 33 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 60 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
Reference Field is not coming up for expense type customer entertainment.Summary Reference Field is not coming up for expense type customer entertainment.Content Hi All, Reference Field is not coming up for expense type customer entertainment…
-
New Line of data for each variableSummary Just checking options available to prevent multiple lines if data in reportsContent Hi, I think I know the answer to this already but apart from using BI Publish…User_2025-02-05-22-44-35-842 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to view audit data in _ tablesSummary Unable to view audit data in _ tablesContent Hi All I have enabled audit for user roles and able to view the data from Tools -> Audit reports. I want to extract … -
Ability to add hierarchy fields as Dashboard promptsSummary Unable to add hierarchy fields as Dashboard promptsContent I am trying to add "Hierarchy"."Level 1 Department" from Worker Assignment real time subject area as D…User_2025-02-10-08-27-16-805 29 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide options in cogwheel on embedded DashboardSummary As the title implies, we have a dashboard that we would like to hide some options on.Content Hi all, In the attached picture, we have two dashboards -- the botto…CIT Shane 21 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Reporting on employment contractsSummary New hires are still showing as pending workers in Employment Contracts Real Time subject area.Content I'm trying to write a report that will show all employees w…
-
Time entry Third Party System integration with oracle PPMContent Hi All, we are planning to intergeate our third party time entry system with oracle project costing and for project resource management dashboard to view the act…User_2025-02-06-13-19-17-977 37 views 2 comments 0 points Most recent by User_2025-02-06-13-19-17-977 Project Management
-
I can't join suppliers tables and ZX tables through the withholding Group IDSummary I have a retention group code. Do you know how do I get to the PERCENTAGE RATES by query,Content I have a retention group code. Do you know how do I get to the P…Max Lopez-Oracle 36 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Using analysis as a sub query - many values for the IN predicate errorSummary Using analysis as a sub query - many values for the IN predicate errorContent Hi, Using OTBI analysis as a sub query for a field for the another analysis . While…Phani S-Oracle 81 views 4 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM