OTBI
Discussion List
-
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 99 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 32 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 38 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 -
Briefing BookSummary Customization in content of Briefing BookContent Hello, We have created a Briefing book with combination of different analysis and schedule it. Struggling with b…User_2025-02-05-07-43-29-505 66 views 4 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM -
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudNageshwaran1 20 views 1 comment 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Add note text of an invoice in OTBI/BIPSummary Add note text of an invoice in OTBI/BIPContent Hello, My need is the following : create a report which will show the comments of invoice which are rejected This …Antoine.Kaiber 98 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
EBS to Fusion Migration - Impact on BI ReportingSummary Re-map EBS interfaces with FusionContent We have build DWH from Oracle EBS which has several reports on top of it. We are migrating to fusion and want to retain …Naeem Khan 47 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
General BIP Report AssistanceSummary I have a series of questions about a BIP report I am trying to developContent Hi all, I just have a series of questions about BIP reports/Dashboards when embeddi…CIT Shane 65 views 9 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 30 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Unable to report on secret and closed communitiesSummary Reporting and dashboards with community informationContent Hello It appears we cannot report on closed communities unless the user running the report is the owne… -
Recover Deleted Report or FolderSummary How can I recover a deleted report or folder in any environment after deletion?Content Hi all, I would like to know if there is a recover option when a report or…User_2025-02-05-05-51-12-049 78 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM