OTBI
Discussion List
-
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…User_2025-02-10-05-51-05-868 47 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP -
Report to view employees currently on redeploymentSummary How to exclude employees from a redeployment report if they have been successfully redeployed into a new roleContent I need a report that displays all employees …User_2025-02-10-22-27-57-221 22 views 2 comments 0 points Most recent by User_2025-02-10-22-27-57-221 Reporting and Analytics for HCM -
Possible to retain OTBI/BIP report jobs upon P2TSummary Don't like having to reschedule the same report jobs after every P2TContent As stated in Doc ID 2581724.1 "P2T refresh clears the scheduled information too. Henc…Wim Bos [MLE] 38 views 4 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM -
Dashboard promptsSummary Creating a dashboard prompt using a formula based columnContent Hi We are using below formula to show the actual "Start date" of employees in the reports. IFNULL…Ridma Karunanathan 42 views 2 comments 1 point Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
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 139 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 46 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 52 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 101 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 90 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