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
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio… -
Turnover ReportSummary Looking for help creating a turnover reportContent Hi, We have set-up turnover reports but when I checked the data the report is not pulling the correct informat…User_2025-01-30-01-37-19-048 115 views 8 comments 0 points Most recent by User_2025-02-03-23-33-26-899 -
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co… -
How-To Create Distribution Analysis in OTBI?Summary How-To Create Distribution Analysis in OTBI?Content Hi Experts, Do anyone of you have some documents illustrating how to create distribution analysis using OTBI … -
OBIEE Presentation Variable To Dynamically Switch Filtered Column Values Based On Dashboard Prompt VSummary Unable to read value of presentation variable.Content Hi All, I am trying to follow steps in - http://obinsight.blogspot.com/2012/03/obiee11g-presentation-variab…
-
How to use in column filter with two subject areasSummary How to get one subject area fact column value based on other subject area filter with two subject areasContent my requirement is to count head count who complete…
-
Need to build a report that show the results of the Payroll Calculation CardsSummary Need help in building a report that show the results of the Payroll Calculation CardsContent Does anyone have an example of a report that shows Payroll Time Entr…
-
An easier way to navigate Oracle to find HCM resources!Summary Know which Oracle HCM Cloud resources to use - and when - in a single page dashboard view!Content Check out these product specific Quick Link charts. These make … -
Workflow table Fusion HCMSummary Need to extract notification historyContent Hi, Being saas customer do i have option to extract workflow data from Fusion HCM Br Azfar.
-
"Workforce Goals - Goal Status Overview Real Time" issue:-Like and Contains Works , but not Equal toSummary "Workforce Goals - Goal Status Overview Real Time" issue:-Like and Contains Works , but not Equal to/InContent Hi, We are having a dashboard analysis where Goals…
-
Need database table name that stores the Performance Goals that are present in subject area ""WorkfoSummary Need database table name that stores the Performance Goals that are present in subject area ""Workforce Goals - Goal Status Overview Real Time" "Content Hi. Need…
-
ORA-01427; single-row subquery returns more than one row error on data modelSummary Receiving oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.Content…User_2025-01-31-02-45-52-854 205 views 3 comments 0 points Most recent by User_2025-01-31-02-45-52-854
-
Goals not connecting to worker from Goal Status OverviewSummary Some goals disappear when adding the worker dimension in reportingContent We have a case where some workers have created 5 goals in a specific goal plan but when… -
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…
-
Need a report to get calculation card Override details along with maximum allowence for fedral andSummary we have a requirement to pull the override rate, override amount, override suplemental rate for fedaral and state from manage calculation cardsUser_2025-02-04-07-00-18-658 90 views 4 comments 1 point Most recent by User_2025-02-04-07-00-18-658
-
Job Requisition Current Status FieldSummary Trying to locate this fieldContent Anyone know what subject area and folder the current job req status is stored? I'm having trouble locating it.User_2025-01-28-08-47-04-905 28 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905
-
Best option to generate HR change letters in Oracle HCM CloudSummary Our HR department would like to generate letters (on demand) for employees upon data changes in HCM Cloud such as department changes, employment changes, etc. Wh…User_2025-01-30-03-25-05-093 138 views 5 comments 0 points Most recent by User_2025-01-30-03-25-05-093
-
Latest Person Profile ContentSummary Max(Date From) not working with mutiple subject areasContent We need data from the subject area "Workforce Profiles - Person Profile Real Time" including Person …
-
Cutting string at a certain character in SQL BI PublisherSummary i want to cut a string at a certain point of a string in BI PublisherContent Hi All, I have a department name however in the middle there is a . (full stop) and …User_2025-01-29-21-02-12-466 46 views 2 comments 0 points Most recent by User_2025-01-29-21-02-12-466
-
New Hire Notifications to Manager, Payroll, HR Business Partner, EmployeeSummary Creating Individualized New Hire NotificationsContent Hello, We are currently transitioning to HCM Fusion and we need a New Hire alert that sends out to their Ma…
-
Active\Inactive Employees with assigned Line ManagersSummary A requirement for a BIP report to show all employees and their Line ManagersContent Hi All, I have a requirement to create a BIP report to display all Active and…User_2025-01-30-03-54-32-528 455 views 12 comments 0 points Most recent by User_2025-01-30-03-54-32-528
-
Identifying if an assignment change was done with a future, retro or current dateSummary Having trouble finding a way to identify if an assignment change was done with a future date or retro date after the fact.Content Hello, My team is in the proces…
-
Infolets Area on Home ScreenSummary Can the refresh button be removed?Content Hi all, We are currently looking at adding infolets to a newsfeed style home screen within HCM and currently we have ou…
-
OTBI report writing access model to users outside HRISSummary Need a model to allow users outside of HRIS to write and save reports in BI CatalogContent We implemented HCM Fusion this year and are looking for ideas as how t…
-
Filter on "Primary Assignment Flag" is dropping few recordsSummary Weird issue specific to few recordsContent Hi, We are facing a weird issue and hoping to get expert guidance. We have an employee as of date report using 2 subje… -
report errors with multiple subject areasSummary error getting information when using more than one subject areaContent When logged in as someone with lots of roles, I am able to create and view an analysis usi…User_2025-01-30-03-29-08-639 51 views 3 comments 0 points Most recent by User_2025-01-30-03-29-08-639
-
Creating an Analysis from Multiple Subject Areas - Using Measures Column from each subject area?Summary Creating an Analysis from Multiple Subject Areas - Using Measures Column from each subject areaContent I don't understand the logic of when creating an OTBI Anal…
-
Access to a Folder for a custom roleSummary Access to a Folder for a custom roleContent How can we access to one folder only for a particular with view only mode. Have given permission to the role as Read …User_2025-02-01-05-31-10-698 75 views 11 comments 0 points Most recent by User_2025-01-22-20-02-26-182
-
Which table stores value set details used in fast formulaContent Hello everyone, Which table stores the information about the value set which is used in fast formula. if anyone knows which tabe defines the relationship between…
-
Historical promotions and assignment for terminated recordsSummary Trying to pull trending data on promotions and transfersContent When using an assignment history report I notice that the history is not included for terminated …