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
-
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 … -
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p… -
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 … -
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… -
"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…
-
How to use in column filter with two subject areasSummary How to use In column filter with two subject areasContent my requirement is to count head count who completed the performance document and who joined in the mont…
-
Length of service - GroupsSummary How to group length of serviceContent Hi, I'm doing some reporting & dashboards and was looking for a way to group the years of service into groups. i.e. number … -
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… -
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.
-
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
-
BIP report date format is not working in Dashboard promptsContent Hi All, I have created a BIP report with date parameter and it is working fine. When I tried to apply dashboard column prompts on the same report data is not fet… -
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 141 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 …
-
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 217 views 3 comments 0 points Most recent by User_2025-01-31-02-45-52-854
-
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
-
Export Embeded Dashboard to Excel in HCMContent All, Is there a way to export a dashboard that is embedded to page in HCM? The export option seems to be only available when the user is in OTBI... -
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…
-
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 496 views 12 comments 0 points Most recent by User_2025-01-30-03-54-32-528
-
Questionnaire Sections in HCM Learning Subject AreaSummary Unable to view the Questionnaire Sections in the "Workforce Learning-Learning Real Time" Subject AreaContent We need to plot the average training feedback on Lea…
-
Report for delegation using BPM worklist vacation rule screenContent A report is required to show BPM Workflow information where a task has been assigned due to a vacation rule taking effect. We are trying to get the following inf…
-
save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsSummary save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsContent Hello, It is a possible to save a BI Publisher Output pdf or OTBI Output pdf in …
-
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…
-
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… -
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…
-
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
-
Oracle Standard Reports - Who to ContactContent Hi all - who do we contact about making an adjustment on the Oracle delivered standard reports? Our team was looking at the Line Manager Dashboard (Shared Folder… -
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…
-
Need to display current year as default value of a date parameter in BI publisher data modelSummary Need to display current year as default value of a date parameter in BI publisher data modelContent Hi, We need to display current year as default value of a dat…
-
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 …
-
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 74 views 11 comments 0 points Most recent by User_2025-01-22-20-02-26-182