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
-
BIP Report Bursting for L1 and L2 ManagersSummary BIP Bursting Report for L1 and L2 ManagersContent Hi Team, I am using a single Data Model and 3 Templates(for 3 different Jobs ). I am using two columns to pull … -
Conditional Format - a detail field to a summarized fieldContent I have an analysis report where I list all the active positions and their FTE along with the employees assigned to those positions and their FTE. I want to compa… -
Combine Data tables in Data model as one similar to Union AllSummary Is there a way to combine tables in the Data Model which is similar to Union All? For example creating another table where they call all the table in the Data Mo… -
Generate .ZIP file from BI Publisher ReportSummary Need to create a BI publisher Report that can output .zip file to be run in HDLContent Hello, We want to create a BI publisher report that can provide us a .zip …
-
Training Needs AnalysisContent Anyone can share the Training Needs Analysis samples report developed in Oracle HCM? -
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi ExpertsSelect LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. B… -
Address Audit ReportSummary Looking for a report with employee address changesContent Hi, Does anyone have a report that shows all address changes for an employee? Would want to see before …
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…
-
Incorrect result in summary report for Payroll - Element entries history real timeSummary Incorrect result in summary report for Payroll - Element entries history real timeContent For an employee, I am getting 8 records and the sum is 631.95 I have be… -
Do we have any sql to identify the recruiting hirerarchy details?Summary Do we have any sql to identify the recruiting hirerarchy details?Content Would like to know if we have any sql for recruiting hierarchy details (like recruiting …
-
Fusion HCM BIP report completed with errorSummary Fusion HCM BIP report completed with errorContent Hi Everyone, When attempting to run a fusion hcm BIP report Online (not schedule) the following error occurs. E… -
Folder permissions in OTBIContent Hi there, Does anyone have any documentation to summarise each of the folder permissions in OTBI (Full Control, Modify, Open, Traverse, No Access, Custom) and wh…
-
OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysSummary OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysContent Hi Friends, I have been working on this report and finally get it working now. … -
Sample OTBI Dashboards and Reports - Supporting VideosSummary 4 videos to explain how to get the most value from the sample contentContent For anyone new to OTBI or familiar with the sample pack of dashboards and reports th… -
Ability to Report on Approval Flows and Approval Groups Tied to ThemSummary Would like to know how to get a list of approval flows, the approval groups tied to them and possibly who are in those approval groups?Content Hi All, Would like… -
Multiple Conditions CASE StatementSummary Build a case statement to include ELSE conditionContent Hi, Please see the attached formula logic. I am trying to build out this formula for multiple locations b… -
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a…
-
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver…
-
BIP Report with stacked Bar chart not showing all dataContent Hello, We have created a BIP report with stacked bar chart. But it is not showing all data. I have attached screenshot document here. There is 1 filled requisiti…
-
Filtering Workforce Trend Real Time by item in Worker Assignment Real TimeContent Has anyone had success filtering workforce trend real time data by a data point in Worker Assignment Real Time? I want to report on the make up of our officer po…
-
Is it possbile to extract the SQL's wirtten in BI Publisher?Summary Is it possbile to extract the SQL's wirtten in BI Publisher?Content We would like to know if there is any option to export all the custom sql's written in BIP. T…
-
SETSTAT is something that isn’t supported by AWS. How to solve?Summary Trying to deposit a file on a FTP but getting errorContent Hello, we need to deposit a file on an FTP of our partner. I'm using Oracle HCM BI. The configuration …
-
Statement of EarningsSummary Subject area for creating an Analysis in OTBIContent I would like to create an analysis using much of the information from the Statement of Earnings but adding m…
-
Data Store ElementEntryPVO vs. RetroElementEntry - only one contains ElementEntryDateEarnedContent I have reviewed data lineage HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryPVO and HcmTopModelAnalyticsGlobalAM.HcmBatchProcessCoreAM.RetroElementEn…
-
Facing a error while fetching the balance Results from Payroll. Error : ORA-20001: An error occurredContent I'm fetching the different balance results from payroll custom balance groups & getting an error ORA-20001: An error occurred. An assertion failure was detected … -
CSV output being generated in a different layoutSummary BI Publisher report tab is not working properly when CVS output is selected.Content Hi Team, Maybe this is a known issue and I getting late aboard. I've added a … -
in Hyperlink translated as %3c?EVALUATION_ID?%3eSummary in Hyperlink translated as %3c?EVALUATION_ID?%3eContent Hi, We are trying to add a hyperlink on BIP report with a EVALUATION_ID. EVAlUATION_ID is translated per… -
Not able to print pdf output after setting pdf security to true in report propertiesSummary Not able to print pdf output after setting pdf security to true in report propertiesContent Hi All, In order to avoid document modification we have set report le…
-
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…
-
Table to extract data from Manage Business Unit Set Assignments pageContent Hi All, I need help identifying which table I can pull the data in Manage Business Unit Set Assignment. I need to identify what is the reference data set of Busi…User_2025-02-08-02-40-14-106 452 views 2 comments 0 points Most recent by User_2025-02-08-02-40-14-106