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
-
URL to LSQL Analysis with ParameterSummary How to prompt on LSQL column so that assignment_id can be passed in URL?Content Hi guys, We have a Logical SQL analysis which we'd like to embed on the app scree… -
Pay Cost Allocation in OTBISummary Department Costing information in OTBIContent Hello Guys, Do you know which Subject Area I can find Pay Cost Allocation details? More specifically, I need to bui… -
How to get Parent Business Unit Name of business Unit name in AnalysisSummary How to get Parent Business Unit Name of business Unit name in AnalysisContent How to get Parent Business Unit Name of business Unit name in Analysis.My requireme… -
Report failing when using 3 subject areasContent Hi I have a report pulling data from 3 different subject areas, which is failing despite they all include a fact from each, they all contain a common dimension (…User_2025-01-29-19-59-51-150 33 views 2 comments 0 points Most recent by User_2025-01-29-19-59-51-150 -
How to link Dependent Care Physician to DependentSummary How to link a Dependent with their Dependent Care PhysicianContent I am trying to pull a report of employee and dependent care physician after Open Enrollment. I… -
Improving Performance with Hierarchy ColumnsSummary Is there anything to speed up the performance of Hierarchy ColumnsContent Hello, I love the idea of the hierarchy columns. Having an easily expandable hierarchy … -
Overall Manager Rating Bar Graph - Display All ValuesContent We've drafted a performance related analysis from the Workforce Performance - Performance Rating Real Time subject area to capture overall manager rating distrib…User_2025-01-23-23-27-03-729 47 views 4 comments 0 points Most recent by User_2025-01-23-23-27-03-729 -
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i… -
Custom Benefit report to list Name of the Life Event Reason from parameter LOVContent Custom Benefit report to list Name of the Life Event Reason from parameter LOV and the most recent last changed Reason with in the calendar year. I am using OTBI… -
BIP report generating JAVA exception "java.lang.NullPointerException"Summary BIP report running into errorContent I am trying to run a BIP report but its generating an error.On running the data model for over 200 rows it generates the fol… -
Use dashboard parameters in a sub-reportSummary Use dashboard parameters in a sub-reportContent We have a dashboard utilizing an OTBI analysis that requires a sub-report. The sub-report needs the begin/end dat…User_2025-01-31-18-54-11-515 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Need help with the Starting Period Active FTE and the Starting Period FTE in the Trending Subject ArSummary Starting Period Active FTE and the Starting Period FTE in the Trending Subject AreaContent I have some questions about Workforce Management - Workforce Trend Rea…User_2025-01-22-19-28-28-240 39 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Restrict Report data based on security profileSummary Restrict Report data based on security profileContent Is there a way to restrict report/analysis output data based on security profile. We have created a data se… -
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu… -
Print Dashboard vs Print AnalysesContent Hi all - I have seen a few posts about this but have not seen a solution and am hoping you can assist. Our users access reporting by signing into Fusion and then… -
License and Certification ReportContent Hello, I was wondering if anyone has created a License and Certification Report with Expiration Dates for employees? I'm trying to pull in the information, but n… -
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole…
-
Error generating document in Excel when Exporting From OTBISummary Getting an error producing document in error in excel spread sheetContent Hi All, We have had an upgrade to OTBI over the weekend and now reports we run which is… -
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie… -
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi… -
OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Summary OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Content Hi, I need to know the difference between 'Keep Timestamps' and 'Ke… -
Seated Line Manager Dashboard : Unable to see Termination (Hierarchy)Summary Line Manager is unable to see his/her TermsContent Hi There, We are working on using the Seated Line Manager Dashboard (Shared Folder --> Human Capital Managemen… -
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I… -
Employee list with Performance Document status - whether document exists or notSummary I'm trying to get one consolidated current employee list with the performance document status of a particular document with one row per employee.Content Hi all, … -
Double Column PromptSummary Can we do double column prompt in OTBI like we can in data model?Content In data models, we can create double column LOV similar to... select description, id fro… -
Add MTD in Employee active payroll balance reportSummary Add MTD in Employee active payroll balance reportContent We are trying to clone the Employee active payroll balance report and make few modifications in it. Alre… -
Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeSummary Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeContent Hello, We are hitting an issue after last weekend 18C upgrade, while … -
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs…
-
IPEDS Reporting In HCM CloudSummary Identifying requirements to support IPEDS reporting for Higher Ed ClientsContent Hello- We are implementing HCM Cloud and need to comply with with federal (highe… -
Table to get employee title informationContent Hi For the purpose of developing a SQL report required to know the correct table. I have referred tables and views document but could not able to find it. Can so…User_2025-01-28-21-18-43-496 35 views 3 comments 0 points Most recent by User_2025-02-01-08-03-07-149