Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Double Column PromptSummary Can we do double column prompt in OTBI like we can in data model?Content In data models, we can create double column LOV similar to... select description, id fro… -
Add MTD in Employee active payroll balance reportSummary Add MTD in Employee active payroll balance reportContent We are trying to clone the Employee active payroll balance report and make few modifications in it. Alre…
-
Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeSummary Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeContent Hello, We are hitting an issue after last weekend 18C upgrade, while … -
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
IPEDS Reporting In HCM CloudSummary Identifying requirements to support IPEDS reporting for Higher Ed ClientsContent Hello- We are implementing HCM Cloud and need to comply with with federal (highe… -
Table to get employee title informationContent Hi For the purpose of developing a SQL report required to know the correct table. I have referred tables and views document but could not able to find it. Can so…User_2025-01-28-21-18-43-496 36 views 3 comments 0 points Most recent by User_2025-02-01-08-03-07-149
-
Report on Transactions that failed in BPMSummary Report on Transactions that failed in BPMContent Hi Has anyone worked on creating reports based on BPM tables. I have requirement to fetch the failed termination…User_2025-01-30-21-52-52-008 131 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle
-
Trying to create a custom role for BI Consumer (Read Only)Content Dear Community, We have a question regarding the OTBI security : we usually give a read-only role to the dashboard to our line managers (role details in attachme…
-
Filter based on selected EmployeeSummary How to pass selected employee Person ID into a filterContent Hi I have a basic Analysis I'd like to place on the Absence self service page (old UI, not the new s…
-
BI Publisher: Can we FTP the individual bursted emails onto the Web content serverSummary BI Publisher: Can we FTP the individual bursted emails onto the Web content serverContent HI, We are aware that we can FTP or put to Web content server, a BIP re… -
Run Employee Active Payroll Balance report for All Balance levelsSummary Way to run Employee Active Payroll Balance report for All Balance levelsContent Is there any way to run the Employee Active Payroll Balance report for All Balanc…
-
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were…
-
Max Coverage Date for Enrollment Results in OTBISummary Looking for the max coverage date by employee and benefit plan/optionContent Hello, I want to report the details of an employee's current enrollment (as of today… -
Report to track payroll entries transferred to SLAContent Hi, Is there a way to track the payroll costing entries which are transferred to SLA. We have a situation here where finance has confirmed that the totals in the…
-
Users unable to see some report results on an embedded dashboardSummary We have a report on a dashboard with formula and conditional formatting for staff to quickly review their time balances but this is not working correctly.Content…
-
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 91 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
BI Publisher and Person FTESummary Having issues with FTE in work measures and UNITContent Hi All, I am writing a report and i need to bring back person FTE so i am bring back value and unit from …
-
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…
-
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…
-
Talent Pool DashboardSummary Example of a Talent Pool DashboardContent Hi, Does anyone have an example Talent Pool Dashboard which they are able to share? Regards, Karen Waddell Version Rele… -
Last chance to tell us how you use OTBIContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn… -
Infolet IssueSummary Infolet 4th tile need to enableContent Hi All, Can you please help me to sort out the below query. I want to add my detailed report to 4th tile in infolet. Once …
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio…
-
Report for overtime hours and regular hoursContent We have a requirement to develop a SQL report based on Over Time hours and Regular hours capturing from a third party device. Suppose we are not creating any pay…
-
Hide Catalog and New based on RoleContent Hi All, Is there a way to hide Catalog and New based on User Role? I have a requirement to share reports with other Oracle HCM cloud users, but i want to restric…User_2025-01-30-00-14-06-021 74 views 3 comments 1 point Most recent by User_2025-01-30-00-14-06-021
-
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co…
-
OTBI Subject Areas not joining properly- Costing & AssignmentContent Hello, I'm trying to combine following two subject areas on multiple ways but it seems like that these are not joining properly despite having all dimensions inc… -
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average …
-
Role required to view salarySummary Report is not reflecting the salary detailsContent Hi All, Can you please help me to sort out the below query. Description: Line manager needs to 'View' only the…
-
Catalog objects not visible while creating Data model using Oracle BI analysisSummary Catalog objects not visible while creating Data model using Oracle BI analysisContent I am creating a new Data Set using Oracle BI Analysis, when I click on Orac…