OTBI
Discussion List
-
OTBI: How to format Enrollment Coverage start date in the OTBI prompt to the date format to DD-MON-YContent In the prompt Enrollment Coverage start date how to change the date format to DD-MON-YYYY.? Currently the format of the date prompt is DD-MM-YYYY.User_2025-02-08-08-08-53-292 39 views 2 comments 0 points Most recent by User_2025-02-08-08-08-53-292 Reporting and Analytics for HCM -
OTBI reports sent via Email are causing performance issuesSummary OTBIContent Hi. I have noticed that most of the OTBI reports I schedule using the agent and send via Email are causing lagging issues when the user tries to open… -
Pay Group Mass Update in Invoice LevelSummary Is there a Mass Update functionality that we can use for Invoice Pay Group?Content Our client is looking for a way to have a Mass Update of the Invoice Pay Group…arvin villanueva 136 views 1 comment 1 point Most recent by Hemant85 Payables, Payments & Cash Management -
Query on the subject area: Human Capital Management – Transaction Administration Real TimeSummary Query on the subject area: Human Capital Management – Transaction Administration Real TimeContent Hi, Am I correct to say that the subject area 'Human Capital Ma…Karen Waddell 85 views 2 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Preferred Browser for OracleSummary I would like to know what is the preferred browser to use for Oracle applications. Can you provide documentations?User_2025-02-06-07-21-22-662 31 views 2 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM
-
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…User_2025-01-28-05-32-59-092 62 views 5 comments 1 point Most recent by Gopikrishna Nerella Reporting and Analytics for ERP
-
Day Difference excluding weekends in OTBISummary Day Difference excluding weekends in OTBI From Workforce Management - Absence Real TimeContent Hi All, I need to calulate the difference between two dates - Abse…Dharmendra Jha 40 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba…User_2025-02-04-08-51-08-912 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI: How do I use a non fact column in the Column Filter.Summary OTBI: How do I use a non fact column in the Column Filter.Content Hi, I have a requirement where i need to use a non-fact column which is Standard Working Hours …User_MC37Q 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Vacation Rules - table where data is stored???Summary Need to know if anyone has identified the table(s) where Vacation Rules are storedContent Wanting to know if anyone has identified where the Vacation Rules are s…Jeff Hare CPA CISA CIA 151 views 4 comments 1 point Most recent by Sreeni Devireddy-Oracle Reporting and Analytics for ERP -
What is the subject Area to get Learning Request Details (Include DFF)?Summary What is the subject Area to get Learning Request Details (Include DFF)?Content Dear Expert, What is the subject Area to get Learning Request Details (Include DFF… -
Not able to create a report for specific requirementContent Hi All, I have a requirement, I have created a dff that is "Is this eligible for reimbursement?" on course page and in this dff there are 2 values one is No and… -
OTBI Based Dashboard OutputSummary Multiple Employees in different Pages in Dashboard OutputContent Hi All I created a Dashboard for Talent Profile using 10 analysis (Each analysis will bring its …Jagdish Varadraj 53 views 8 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Need to be able to identify all BIP Reports and Analyses that use particular field as filterSummary Need to be able to identify all BIP Reports and Analyses that use particular field as filterContent Does anyone know if there is an Oracle program that will iden…Rich R 48 views 3 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
How to hide data model and edit access for BI ReportsContent Hi Export, We have a requirement to give only view access for BI Report and nothing other than. So we are planning to hide the data model so that a user can not …MohammadAfghanul Khair 289 views 4 comments 0 points Most recent by MohammadAfghanul Khair Reporting and Analytics for HCM -
OTBI - unable to extract catalog request justificationSummary Tried to pull a report in OTBI with the justifications that our employees submitted when they requested for catalog items, but did not manage to do so.Content He…
-
OTBI: how to achieve UNION ALL operation in OTBISummary OTBI: how to achieve UNION ALL operation in OTBIContent Hi, We need to replicate BIP's UNION ALL operation in OTBI Is it possible? Regards RashmiUser_MC37Q 108 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Trend Headcount by Assignment StatusSummary We require a report that displays headcount for each month for the last year, but it should only count those employees with a specific assignment status.Content …Derrick Campion 50 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP -
R13 20A - How to extract BPM approval Configurations task details via SQLSummary Need to extract BPM approval configurationsContent We have a need to extract all the BPM approval configuration task details via SQL. All things BPM related (the…Suganthi Srinivasan 106 views 4 comments 5 points Most recent by Venkatraman G Reporting and Analytics for HCM
-
New Role only seeing their information on any report ran in Reports & AnalyticsSummary PAYADMIN_READONLY_DATA_DATAContent Created a new role in HCM and it only when reports are ran it only shows their information, unless it is a line manager, then …Gabe K 57 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 91 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
When OM creates TO, it creates different transfer order for different lines, is there a way to groupSummary When OM creates TO, it creates different transfer order for different lines, is there a way to group all the lines to create 1 TO for 1 SO
-
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 79 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodSummary Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodContent Hi Experts Please let me know if there is a report for all…Mansur Khalil 54 views 3 comments 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' …Anuradha T 60 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM