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
-
OTBI Subject Areas not joining properly- Costing & AssignmentContent Hello, I'm trying to combine following two subject areas on multiple ways but it seems like that these are not joining properly despite having all dimensions inc… -
Last chance to tell us how you use OTBIContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn… -
OTBI - Field to show max effective_start_date by action_codeSummary In OTBI workforce assignments I'd like to show the max effective_start_date of assignment based on action_codeContent Hi all, While working on "Workforce Managem… -
CASE WHEN in BI PublisherSummary Using CASE WHEN in BI Publisher SQL and not getting resultsContent Hi all, I have been writing a BI Publisher data model with SQL to bring back employees along w… -
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…
-
Infolet IssueSummary Infolet 4th tile need to enableContent Hi All, Can you please help me to sort out the below query. I want to add my detailed report to 4th tile in infolet. Once …
-
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average … -
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 116 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 208 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 30 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 137 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 47 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…