Reports
Discussion List
-
Joining Workforce Events to Person Real TimeSummary Having trouble getting the data to align between the two subject areasContent Hello Everyone, I've created a simple example of an analysis we're making to see ho…Rob F 34 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
RTF Template - Field validation with the combination of xdofx and xdoxslt functionsSummary RTF Template - Field validation with the combination of xdofx and xdoxslt functionsContent Hi , I need to add a validation on other-compensation.value field , wh…Phani S-Oracle 63 views 5 comments 1 point Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Access Permission in HFRSummary What is the difference between Full Control, Modify, Inherit access which we give from explore the repository. I didn't find anything from docs
-
OrganogramSummary Organogram RequiredContent Hi, I have come across many previous posts regarding organogram / organisational charts and none deliver a proper organogram whereby e…User_2025-02-05-22-44-35-842 51 views 37 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Change column to NumericSummary I want to change a column to numeric so I can add formulas. How would I do so in the SQL?Code Snippet SELECT "Workforce Management - Worker Assignment Real Time"…User_2025-02-06-07-21-22-662 29 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Inside Bar Edge numbers will only render in black fontSummary Inside Bar Edge numbers set as any colour, will be rendered in PDF/embedded in content as blackContent Hello! I have built some management reports which contain …James Wilson-234586 20 views 5 comments 0 points Most recent by James Wilson-234586 Narrative Reporting
-
Analysis for finding positions with more than one EmployeeSummary Need a report that shows a list of positions that currently have more than one Employee in the positionContent I am trying to build an audit report that shows th…User_2025-02-04-08-51-08-912 37 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
20c Subject Area Changes - Transaction AdministrationSummary Additional fields added to Human Capital Management - Transaction Administration Real TimeContent I have been reviewing the readiness docs for 20c HCM, but I hav…ndryden 56 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report with Position Headcount data as of current month and as of previous month in the same anSummary Current and Previous month data in the same OTBI analysis based on AsOfDate variable parameterContent Hello All, Request help! Trying an OTBI report which includ…pooja yelsangikar-Oracle 167 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Rows For Assignment ManagerSummary Updated the assignment manager job today and each employee now has multiple rowsContent Hi, Today we ran the jobs to update the assignment manager fields. After …
-
Migrate non-Hybrid BSO Cube to EPBCSummary We are encountering performance issues after LCM import into EPBC and hybrid enablement.Content We are transitioning from a non-Enterprise version of PBC to an E…
-
How to increase the number of characters for a OTBI Analysis columnContent Hello experts, a text column returns truncated text while in Core HR I can see the entire text. As a result, I think that it depends on the report configuration.…Valerio Curzi 46 views 5 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Valid Intersection is not working in the HFRSummary We have setup valid intersection for two dimensions called Cost Centre and Analysis, It is working fine in the forms but not working in the financial report (HFR…
-
Canadian Payslip modificationSummary Need to determine the path in the catalog for the payslip as well as how to make a modificationContent With the COVID-19 issue, we have had to add new pay elemen…User_2025-02-04-08-51-08-912 23 views 5 comments 2 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Resume an automated Job - after PAUSINGSummary Resume an automated Job - after PAUSINGContent Resume an automated Job - after PAUSING results in: 1. immediate submission of the job 2. And also runs for all th…User_2025-02-05-22-13-16-277 159 views 1 comment 0 points Most recent by User_2025-02-05-22-13-16-277 Reporting and Analytics for HCM
-
OTBI - Line Manager cannot report on future dated joinersSummary Line Manager cannot report on future dated joinersContent We have a requirement for Line Managers to see future dated joiners and internal movers. We are using t…User_2025-02-05-05-26-04-705 53 views 12 comments 0 points Most recent by User_2025-02-05-05-26-04-705 Reporting and Analytics for HCM
-
Please share tutorials on how to make SQL Queries for BIP ReportsSummary of Request Please share tutorials on how to make SQL Queries for BIP ReportsContent Hi, I am interested in learning SQL query building for BIP Reports. Please sh…Renuka Soneja-154959 56 views 0 comments 1 point Most recent by Renuka Soneja-154959 BI Publisher Learning Center -
Pivot Salary Data For Employee PopulationSummary Want to display salary data for employee population without summing the dataContent Hi - I am trying to create a pivot table in OTBI that would show salary data …Kyle Norris 32 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to lookup the position name of an employee from another analysisContent I am creating an analysis for Development goals and since it's tied to the home/primary assignment I am trying to populate the position name and department name …Mario B 16 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFSeSummary OTBI Analysis is running out with above error after 20B upgradeContent Hi All, One of the Analysis which is having below subject areas is running out in error (c…
-
Calendar event - Holiday ListSummary Calendar event - Holiday ListContent Team, Is there a way to fetch holiday list from Manage calendar event on country wise basis using OTBI report ? (Without usi…acmhari 97 views 2 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to Hide Prompt Section in Dashboard OutputSummary How to Hide Prompt Section in Dashboard Output While printing it.Content Is there a way to hide the Prompt from the Dashboard when we print the Dashboard output …Jagdish Varadraj 140 views 4 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM -
PDF Output properties in BI publisher ReportContent Hi, Is there any option to make the PDF output of the BI publisher report fit to the page? Regards, Nivya -
Editable checkbox in BIP ReportSummary Need a checkbox in report where users can check/uncheckContent Hello - We have a requirement where the BIP report should display checkboxes with options and the … -
What is the Relationship between fusion.hrc_txn_header, fusion.HRC_TXN_CONSOLE_ENTRY AND fa_fusion_sSummary What is the Relationship between fusion.hrc_txn_header, fusion.HRC_TXN_CONSOLE_ENTRY AND fa_fusion_soainfra.WFTASK?Content Can someone explain the relationship b…GTS Narayanen 1.8K views 7 comments 0 points Most recent by Murugesu.V Reporting and Analytics for HCM
-
Editing a copy of a report is affecting the original oneSummary Editing a copy of a report is affecting the original one.Content Hi all, Don't know how simple might be this question, but i've made a copy of a report to edit i…Pedro Teixeira 32 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Holiday Calendar - Subject AreaSummary Holiday Calendar - Subject AreaContent Hi Team, Can anyone know how to pull public Holiday calendar in OTBI report. Please share if we have any subject area for …User_4VVG2 37 views 2 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM
-
How do you find the url link of an analysisContent I am trying to direct link in a document to the url of an analysis but I can't seem to find out how to find the analysis url in HCM.Mario B 57 views 4 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM
-
CSV Format Report is not populating fileSummary CSV Format Report is not populating fileContent Hi Friends, I have created BIP Report and selected CSV format ( Tab delimited) when I run report I do see report …User_2025-02-07-19-03-14-525 37 views 8 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM