OTBI
Discussion List
-
User should be able to create a new OTBI Report(Analysis) but will not be able to edit the existing.Our requirement: We need to create a custom role in which a user should be able to create OTBI Reports by using subject area "Procurement- Procure To Pay Real Time" but … -
Manager Hierarchy starting with CEOSummary: We are looking to get the manager hierarchy with CEO as level 1 of the organization. The Flattened Hierarchy table (PER_MANAGER_HRCHY_DN) has data with manager …User_2025-03-07-06-12-02-972 187 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Do we have data model or report for online messages in Sourcing.Summary: We have a requirement in which all the online message of Negotiations of specific buyers will be listed. The current printable page functionality provides outpu…
-
In which table Derived related items are stored in Oracle Fusion CloudHi , In which table Derived Related Items details are stored in Oracle Fusion Cloud. I have already checked EGP_ITEM_RELATIONSHIPS_B table. Thanks and Regards, SanmatiSanmati Patil-Oracle 157 views 1 comment 0 points Most recent by Krishna -Oracle Product Master Data Management
-
OTBI Partner Resource RoleSummary: Hi, I need to create a simple report showing Partners and all the Partner Resources (First Name, Last Name) with their Resource Role. Can someone point me to th…AparajitMalliJawaharBapu 22 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
how to add dynamic values inside message content in BIP report schedulingSummary: I would like to know whether we can add parameter values under "message" while scheduling the report . The screen shot is given below. Content (please ensure yo…Simi_SS 91 views 6 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Any Functional or Technical Design document for Seeded ORC DashboardAs we can see the seeded Dashboard for ORC - Recruit to Hire. But do we have any technical or Functional document available to see the logic (calculations) used in each …Venkatesh S S 70 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Is there any way to create OTBI report based on job code whichSummary: Is there any way to create OTBI report based on job code which is to be used in Learning Initiative for a course but only those employee should come who have no…
-
How to Get Flow Submission Date/Creation Date in OTBI ReportHow to Get Flow Submission Date/Creation Date in OTBI Report. I am using payroll Run Result Real Time Business Area. Scenario: Employee Resigned in the month of Sept2023…Jithindev 44 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
where to find "when is the employee start date" from offer letter in BISummary We need to report "start date" from offer letterContent Hello We have a requirement to include the "When is the employee start date" [hire date] from the offer l…Adil_R 131 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
What role grants me access to view data for real-time analysis of Quality Inspection ResultsSummary: We created a custom infolet for users to view failed Preventive Maintenance work orders. However, only the admin can currently access and read this data, while …
-
No results for some Facts-Candidate Tracking Activity such as number of applies, number of submits.Summary: Running a basic query against Recruiting - Candidate Tracking Real Time subject area. Number of successful submits does display, however Number of Applies, Numb…Melody Herbert 23 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Where are the setup information of Installed Base Asset additional fields stored ?Summary: Via Application Composer, we have defined a number of additional fields for Installed Base Asset object. We need to know via OTBI query wich attribute maps to w… -
Need help finding field in OTBI reportSummary: I have everything done on a custom OTBI report out of Performance Task Status Real Time except I need to pull the "Step" as shown in my image below. I cannot fi…Aaron Reynolds 24 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Data Not fetching when joining cross subject areas with a DFF attributeSummary: We have encountered an issue while join two cross subject areas. Workforce Management - Worker Assignment Real Time and Workforce Performance - Performance Rati…Atul#620 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee hierarchy under a manager - need help passing manager person number as a promptSummary: I am writing a report to show all reports (direct or indirect) under a manager. I am getting the list by hard coding the manager ee# in my OTBI report. Since it…Anita Modi 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to update expired courses ??Summary: update expired courses thru HDL or supress them from employee dashboard Content (please ensure you mask any confidential information): We have many employees wi…
-
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o…
-
How to deliver the OTBI report content to a destination server ex - A FTP serverSummary: Hi, Pl let me know how to deliver the OTBI report content (anlaysis) to a destination server ex - an on-premise FTP server. Where can we setup this in agent con…
-
Why does the Compensation - Salary History Details Real Time not show the correct adjustment?Summary: In the subject area Compensation - Salary History Details Real Time it is showing a value which is not in the front end for adjustment. Content (please ensure y…
-
Enable Drill down from OTBI Report crated from Budgetary Control - Balances Real TimeSummary: Hi, I've Created an OTBI report through "Budgetary Control - Balances Real Time". to retrieve the total budget, expenditure balances and so on. How to make dril…
-
Costing - Item Cost Real Time" subject area replaced with "Costing -Standard Cost Real TimeSummary: Subject Area name and function appears to have slightly changed. We can no longer find the SA called "Costing - Item Cost Real Time", but instead it appears to …
-
PPM Selected Bank AccountSummary How to Find selected bank account under personal payment methodContent Hello All, When employee update their bank details by clicking into their existing payment… -
Any report to get the employees with missing calculation card detailsSummary: Any report to get the employees with missing calculation card details Content (please ensure you mask any confidential information): Hi Team, Greetings! There a…Parag Hiremath 37 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Fiscal YTD not working correctly in HCMSummary: Need to get Fiscal YTD terminations but I cannot get it to result in Sep 1, in instead get 09/22/23 if run today. Content (please ensure you mask any confidenti…Sherie Ross 25 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Schedule Report to FTP including data timestampSummary Schedule Report to FTP including data timestampContent Hello, I want to daily schedule in OTBI report and BI publisher report and in the file name I want to incl…Giuseppe 1234 117 views 7 comments 0 points Most recent by NikhilSamudrala-Oracle Reporting and Analytics for HCM
-
IN below OTBI Manager DR report but country name not showing it showing DRS country nameSummary: Hi Team, we have list of people with direct reporties but when we add the country name in the it showing reporties country but we need manager country . Any one…Maddipati Ajay Kumar 43 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM