Reports
Discussion List
-
Need new table names to pull calculation card detailsSummary Need new table names to pull calculation card detailsContent Hi Team, i am looking for the table names/query to pull the calculation card details like Federal , …User_2025-02-04-07-00-18-658 160 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Prompt Search Edit functionality for BIP reportsSummary How to achieve the prompt search edit functionality for BIP reports similar to one available in Analysis ReportsContent How to achieve the prompt search edit fun… -
Element result report - explanationSummary How the Element result report is designedContent Hi All, Can anyone elaborate me how the Element result report is designed. I am able to understand the Extract's…SuryaMuralidharan 49 views 1 comment 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
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…Rebecca Smith-27468 57 views 6 comments 1 point Most recent by Ema Johnson-Oracle Reporting and Analytics for HCM
-
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…Shelly Feyerherm 64 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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…User_1B10X 17 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 …User_2025-02-04-07-00-18-658 133 views 6 comments 0 points Most recent by Visu Reporting and Analytics for HCM
-
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…Alvaro Couto 69 views 4 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
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 Reporting and Analytics for HCM
-
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…Mike Borghoff 59 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 230 views 6 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
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…Mike Borghoff 41 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
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 61 views 4 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
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…Preston Schultz 53 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Michael Cashin 92 views 11 comments 0 points Most recent by Michael Cashin Reporting and Analytics for HCM
-
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…Nivya Mathire 76 views 17 comments 2 points Most recent by User_2025-01-31-00-28-55-093 Reporting and Analytics for HCM -
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 87 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
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…User_KOLMZ 246 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
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…Koteswararao Yenikepalli 46 views 8 comments 1 point Most recent by Koteswararao Yenikepalli Reporting and Analytics for HCM -
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…User_MC37Q 45 views 4 comments 0 points Most recent by User_2025-02-01-08-03-07-149 Reporting and Analytics for HCM -
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…User_2025-02-04-10-47-55-876 137 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…nitin Sharma 50 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Custom Subject Area Content in Analysis / DashboardsSummary Receives errors when sharing an analysisContent So I built some analysis by using some custom subject content areas, i.e. Regions built from multiple locations. …Deb Luisi 55 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Custom report Details queryContent Experts, whether Custom BIP report details are stored in some internal tables? Is there a way to extract those details? There is a requirement to get all the cus…VijayaBaskar Ranganathan 40 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Payroll balance values through OTBIContent Hi All, We created custom balances in the application. We have a requirement to display custom balances and standard balances like (Gross Pay..etc) values throug…User_6I33I 182 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
OTBI custom datesSummary Custom Dates in OTBI reportingContent Hi All, I want to display custom date ranges in OTBI and the corresponding headcounts for the dates. As of now, I am able t…SuryaMuralidharan 58 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Line Manager : Unable to see Termed Managers : Role FilterSummary Line Manager is unable to see termed workersContent Hi Team, We are trying to use the seeded Line Manager Dashboards. Unfortunately our line managers are unable …G Suman 42 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Updated list of delivered HCM Cloud reportsSummary More recent version of the seeded reports / delivered reports / sample reports for HCM CloudContent I'm looking for an updated list of delivered HCM Cloud report…Sara KC 367 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
REST API for Oracle BI PublisherSummary REST API for Oracle BI PublisherContent Hi. We are using webservices to use the REST API, we´re having an error with the URL for getting the PATch, postman gives…JAVIER COLLADO-125113 107 views 3 comments 2 points Most recent by User_IYN7Q Reporting and Analytics for HCM