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
-
Which Subject Area holds the EmailAddressIdContent Could anyone tell me which subject area I can find the EmailAddressId? I need this to update email addresses through Data Exchange for the full version of HCM Da… -
Legal Employer Hire Date in OTBI ReportContent User is creating OTBI report using subject area "WorkForce Management - Work relationship Real Time" subject area. But user is not able to find any column for "L…
-
Bypass report securitySummary bypass report securityContent Is there a way we can bypass user security when setting up a report? We have created some workforce KPI dashboard reports for a sma… -
Issue in Intro Period Status Burst Report - Performance ManagementContent Hi All, we are facing an issue with an OTBI Analysis Report 'Intro Period Status Burst Report' in Production. Issue Description: When the report is run for recen…
-
BI PUBLISHER FORMATING DATEContent I am developing a report in BI publisher (using rtf template) and we need to show the current date as just 3 letters of the Month name and year. eg: If the date …
-
Need Query/Catalog to pull the Payroll Balance details.Summary we have to create a report to pull the custom balance details for payrollContent Hi Team, We have a requirement to get the custom balance details in payroll for … -
Security for BI Email NotificationsSummary securing a field on a notificationContent Is there a way to secure a field on the BI email notifications? For example, if we want only certain users to see the '…
-
Users Preferred Timezone reportSummary Listing timezones set up in User's preferences by UserContent Hello Everyone, I found this script in one Oracle Support documents but I can't run it as it is sho… -
Changing Date Format at ReportSummary We can not change date format as we want to see.Content Hi All, You can see in below screenshot that we have date format at report column. We can only choose 3 o…User_2025-02-04-18-26-11-309 62 views 5 comments 3 points Most recent by User_2025-02-04-18-26-11-309
-
Bulk fetch failed. (HY000)Summary While casting date in the filter criteria getting error for BulK Fetch Failed - OTBIContent Requirement - Service Anniversary report (Need to get the Employees d…
-
How we can export data from Infolets ?Summary If a table is displayed at expand view and we need to export it. Is there any way ?Content Hi All, We are displaying the data of manager reportees on the expand …
-
Percentage of columnSummary Need to calculate a percentage off Median salary by various attributesContent Attached sample. I can get the first 4 columns. However, I can't come up with the r…
-
Is there any easiest way to find the Fact/Measure columns in OTBISummary Is there any easiest way to find the Fact/Measure columns in OTBIContent Hi Team, I am looking for the easiest way to find the Fact/Measure columns in OTBI inste…User_2025-02-04-07-00-18-658 226 views 6 comments 0 points Most recent by User_2025-02-04-07-00-18-658
-
Calculations - level downContent I need to build three charts that hinge off one another: 1. Average or Median salary by Gender/BU/Management level. 2. From the chart above, I need to just get a…
-
BI Publisher, Bursting Template ConditionsSummary Only show second page of template if condition is metContent Hello I am bursting a letter to colleagues telling them the outcome of a pay review. The template ha…User_2025-01-31-17-49-32-187 53 views 5 comments 1 point Most recent by User_2025-01-30-21-52-52-008
-
Is SFTP possible in OTBI AgentsSummary Is SFTP possible in OTBI AgentsContent Hi Team, Is there a possibility of sending output file to third party by using SFTP in OTBI agents. Regards, Chaitanya.User_2025-02-04-07-00-18-658 63 views 4 comments 0 points Most recent by User_2025-02-04-07-00-18-658
-
Monthly Headcount by Assignment Status for each MonthSummary Monthly Headcount by Assignment Status for each MonthContent The business is looking for Headcount by Month by Assignment Status. I tried using the Workforce Tre…
-
Quarterly State Withholding Tax reportSummary How to create an analytic or report showing state withholding tax for past quarterContent Hi all. We are new to Oracle and need a tax report for our Finance dept…
-
Auditing Hierarchy Loops in Department TreesContent Hi Guys, Does anyone happen to have a report that is able to show hierarchy loops within a department tree? We do currently have a report that shows which manage… -
Random Password for PDF burstingContent Hi, We have a requirement to create random password for the attachment which are sending to employee as pdf. We are able to achieve some extend by using a combin… -
BIP report and sql injectionContent Hello Experts, While creating BIP reports in the Oracle fusion environment , do we need to consider Sql injection? If we have a BIP report that takes input value…User_2025-01-30-00-14-06-021 79 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571
-
Autopopulated Prompt with Current_Date (SYSDATE)Content Hello everyone, We have a OTBI dashboard that contains analysis that is running As-Of date parameter. As-Of reporting was set up by adding SET VARIABLE PARAM_EFF… -
Backend Table column value for Ethnicity "Not_disclosed"Summary Ethinicity "Not_disclosed" backed table column valueContent Hello, Im trying to find Backend Table column value for Ethnicity "Not_disclosed". Attached is the sc…
-
Need a report to get all the fast formulas in the system along with formulaSummary Need a report to get all the fast formulas in the system along with formulaContent Need a report to get all the fast formulas in the system along with formulaVer… -
OTBI Report MigrationSummary How to migrate OTBI Reports from one company's environment to anotherContent Currently company "ABC" is using OTBI tool for analytics purpose over HCM cloud data…User_2025-02-04-22-00-05-391 47 views 3 comments 0 points Most recent by User_2025-02-01-08-03-07-149
-
How do we password-protect a document while bursting it using a Oracle HCM Cloud BI ReportSummary How do we password-protect a document while bursting it using a Oracle HCM Cloud BI ReportContent Hi, How do we password-protect a document while bursting it usi… -
Check for duplicate Position Codes using COUNTSummary Show count of position code to identify duplicatesContent Hi, I am using the Position Real Time subject area and I'm trying to determine which position codes are…
-
Headcount vs. Head Count DefintionsSummary There are at least 14 different headcount presentation columns in OTBI - when do you use whichContent I am new to OTBI and trying to understand when one would us…
-
After Click on Report and Analytics link some times blank screen displaysSummary After Click on Report and Analytics link some times blank screen displaysContent Hi All , I am using the HR dash board to access the Reports and Analytics ,but s…
-
OTBI - Manager person number as the main keySummary Is it possible to refer the manager person number as the primary key in OTBIContent Hi, Can I make a report in OTBI so all the fields (assignment status, job, de…