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
-
HCM BI report data model tables to check SQLquerySummary HCM BI report data model tables to check SQLqueryContent Hi, I wonder if there are tables that I can check SQL query for custom BI reports. We have multiple BI r… -
BIP Contact Bursting ReportSummary BI Publisher report to send emails about various contact scenariosContent We have a requirement to send out emails (we have specific templates so BIP is needed) …User_2025-01-23-21-24-21-434 54 views 4 comments 0 points Most recent by User_2025-01-23-21-24-21-434 -
Dashboard Prompt Value from ExpressionSummary Dashboard Prompt Value from ExpressionContent Hi, We have embeded a BIP report on Fusion page by placing it on a dashboard. We are passing value to its Dashboard… -
How to download drilldown reportContent Hi, We have a dashboard with drill down reports. But there is no option to download the detailed report when you access it through dashboard. I could see only tw… -
OTBI Agent Email From, Reply-to, CCSummary OTBI Agent Email From, Reply-to, CCContent Hi all: Using an Agent, is it possible to alter the "From" email address and add "CC" and "BCC" email addresses? The c…
-
Reg BI RolesContent Hi We are in 19C , and employee does not have BI Consumer, BI Administrator and BI Author roles , but still able to see the folders in BI delivered folders , why…
-
Performance Tile doesn't return data when table view is removed.Summary Performance Tile doesn't return data when table view is removed.Content Hi, I have created a custom OTBI analysis using Performance Subject area in which i need …
-
Oracle Cloud HCM Deferred Terminations analysisSummary Need a way to report on deferred terminationsContent Need a way to report on deferred terminations. Does anyone know how to pull that field?
-
How to merge OTBI rowsContent Hello experts, is there a way to merge OTBI information in a single row for each worker? For example, the highlighted employees appears five times. How can I agg… -
BIP burstingSummary BIP bursting FTPContent I have a bursting report with FTP config, it is generating and placing the file in FTP path but the excel output is junk . Need help to u…
-
Query ValuesetContent Hi, I just created a valueset and looking for a SQL to query them from the application. Is there an easy way to do it? -
Reporting State, County and City tax card informationSummary Need field associated with the specific geography the tax card is associatedContent I need help finding the table and field associated with the specific geograph… -
Need table names for reporting on the report job historyContent Hi All, Could you please provide the table names associated with the report job history. We need to pull the data for a report where email is being sent to emplo… -
Department not in Payroll - Payroll Costing Setup Details Real Time Subject AreaSummary Department not in Payroll - Payroll Costing Setup Details Real Time Subject AreaContent Hi I wonder if you can help me. When I try to report the cost centre for …User_2025-02-06-09-29-18-902 189 views 2 comments 0 points Most recent by User_2025-02-06-09-29-18-902
-
PGP Key generation for encryption of BIP ReportSummary Please let us know can this pair be generated from Fusion Application itself or do we need a separate software for PGP key generation, encryption and decryption?…
-
BI Report on Notification Approvals StatusSummary Trying to create a BI Report on the status of Notification ApprovalsContent I've tried looking at a number of tables, firstly in OTBI, but the subject area "Huma…
-
Performance Tile - Changing Totals?Summary Returning to a page with Performance Tiles shows incorrect aggregated values.Content I have a dashboard that has a first, summary page with several KPI/counts as…
-
Ranges for Geographic DifferentialsSummary Is it possible to pull a report of salary ranges for Locations that have a geographic differential?Content If possible, what subject area and field should be pul…
-
How to fetch payroll relationship number in OTBI?Summary How to fetch payroll relationship number in OTBI?Content Hello Experts, I have a requirement where to fetch all the assignment details and payroll relationship n…
-
How to link Person Real Time Subject Area with Workforce Management - Worker Assignment Event Real TSummary Is it possible to do this using logical SQL?Content Hi, I'm new to OTBI and I'm experiencing a lot of frustration regarding the Person Real Time Subject Area not…
-
Report to fetch all the employees who is missing Home address/ work address using OTBI?Summary Report to fetch all the employees who is missing Home address/ work address using OTBI?Content Hello Experts, I have a requirement where to fetch all the employe…
-
What Role i need to get data out of AnalysisSummary What Role i need to get data out of AnalysisContent Hi I have BI Admin / HR Specialist and manager / Application Developer roles. I can write sql on BI report an… -
Report on Job Seniority Date by AssignmentSummary Report on Job Seniority Date by Assignment (v3)Content We are in the process of implementing seniority dates, specifically for job by assignment. We believe this… -
Filter analysis based on results of other fields which were based on a filterContent I created a report that will compare, by benefit, what should have been deducted from an employee's check vs what actually did get deducted. As a result I have t… -
RetirementSummary Eligible to RetireContent To be eligible for the pension plan an employee has be to be aged 65 or meet the “magic 80” rule which is the employees’ start date + a…
-
Reporting ESS and MSS transactionsSummary Reporting ESS and MSS transactionsContent Is it possible to report on Employee Self Service (ESS) and Manager Self Service (MSS) transactions? What defines a ESS… -
need a table name to get the "Payroll Transfer Status" field in time and laborSummary need a table name to get the "Payroll Transfer Status" field in time and laborContent Hi Team, i am looking for a table to get the "Payroll Transfer Status" fiel…User_2025-02-04-07-00-18-658 186 views 1 comment 0 points Most recent by User_2025-02-04-10-25-07-624
-
Compare State column in OTBIContent Hello, We have a requirement to show only those employees whose primary mailing address state is not equal to their work location state. I am able to fetch all t… -
Report of employees not in Open EnrolmentSummary Report showing any employees that have not got an Open EnrolmentContent I need to get a report of employees who have not been put into Open enrolment. Our Annual…
-
What are the various benefit plans to which the workers have enrolled, by various years?Content Looking at the Benefits - Enrollments Real Time subject area's business question it is noted that the subject area has attributes that will answer this question.…