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
-
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti… -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
How to keep my oracle account active after changing companies?Summary: Hi Team, How to keep my oracle account active after changing companies? Thank You, Ajay Content (please ensure you mask any confidential information): Version (… -
The absence report should calculates absence durations based solely on working days.We have created a report name "Absence Balance Details Report" , which has below columns : EMPLOYEE NUMBER EMPLOYEE NAME LEGISLATION CODE LEGAL EMPLOYER NAME ASSIGNMENT … -
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for …
-
Scheduled agent is failedHi Experts, I’m hoping someone can assist me here. We have several agents scheduled that were running successfully. However, one of the scheduled agents has suddenly sto…
-
OTBI Report Issue - "Compensation - Workforce Compensation Real Time"I am currently building a report using the “Workforce Compensation – Real Time” subject area in OTBI. My objective is to retrieve basic employee details along with their…
-
Notify Project Admin when Project manager is terminatedSummary: Hi I have received a request from Project Administration if it is possible to create an alert to notify the registered Project Admin if the currently active Pro…
-
Unable to pull the pull the complete parent hierarchy chain through OTBI reportUnable to pull the pull the complete parent hierarchy chain (Parent Manager 01 to Parent Manager 05) for terminated cases through OTBI report Subject Area > Workforce Ma…
-
Bursting query to trigger resignation letter to personal emailSummary: Hi Team, I need help with a data model and bursting query. The goal is to trigger the resignation letter and route it to the employee's personal email. Could yo…
-
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…
-
OTBI Dashboard Prompt Default TimeHi, I am trying to set a dynamic value for Calendar Year in an OTBI Dashboard Prompt. I am using the "Recruiting - Recruiting Events Real Time"."Time"."Calendar Year" co…
-
OTBI - "Workforce Management - Documents of Record Real Time" returns 0 resultsWe are experiencing an issue with an OTBI analysis using the "Workforce Management - Documents of Record Real Time" subject area. When we include only worker-related col…
-
Issue w/ Balance Definitions with several elements for rolling 12 months not producing correct valueIssue with Balance Definitions made out of several elements for rolling 12 months as the dimension but the results don't change at all and tested for multiple users with…
-
Employee Rating not fetchingSummary: I have issue with my performance rating analysis. I was able to get the Overall Manager Rating but it's not fetching the Employee Rating, Rating Level Name, Sta…
-
How to report on questionnaires attached to candidate in job application flow folderSummary: We have a questionnaire created (Candidate Survey) Subscriber: Recruiting; Questionnaire Library: Job application flow Content (please ensure you mask any confi… -
Sql query to get the payroll balance ITD value from the below image It is not from balance resultsHi Team, I need an sql query to fetch the payroll balance ITD value from the below screens (Not from balance results which can be seen in person results). For an employe…
-
Time cards ConfigSummary: Exam Leave - for regular employees (not on Union Job Codes) - should be allowed on Public Holidays and Weekends. Today, system does not allow me to enter this l…
-
How is everyone handling and accessing metadata within OracleSummary: Looking for metadata for both business and log-based data. Would like the Oracle dictionary rather than re-creating the wheel. Where can I locate a full table a… -
OTBI Pivot Table Issue–Unable to Retrieve Questionnaire Response Text and Response Answer CorrectlyWe are using the subject area Workforce Management - Checklist Real Time to retrieve the following attributes: Questionnaire Question Text Response Answer Response Text …
-
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an… -
BPM Worklist: SQL query to skip approval if job requisition is pipelineSummary: I need to skip the job requisition approval in 2 scenarios: Job requisition is created as pipeline Job requisition is not having position id However the skip ru…
-
Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F?Summary: Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F? The lineage documentation (https://community.oracle.com/customerconne…
-
custom US Cheque Report repositioning when printed to a copierHi, I have built a custom US Cheque Report based upon Oracle's seeded US report. I am having issues after a test payroll is ran and converted to pdf and at that point th…
-
Powerpoint export of BIP report is showing unnecessary boxesHi , We have BIP report which has rtf template and when we are exporting this report in ppt format output is showing unnecessary boxes which are difficult to edit in ppt…
-
HCM Extract changes only with dynamic group criteriaHI All We have a requirement for HCM changes only extract for interfacing data in payroll system. Oracle HCM is the master employee system and we have a thrid party payr… -
PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject AreaSummary: Some PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject Area Content (please ensure you mask any confidential information): See screen shots of Fl…
-
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us… -
Need table name 'Source: Talent Profile’ information displayed in the Candidate Search HCM?Summary: Please provide the table name in Oracle Fusion HCM that corresponds to the under-Degree 'Source: Talent Profile’ field shown on the Candidate Search page. This … -
Skip Query in Oracle Fusion HCM BPM workflows is not workingSummary: Hi All, We want to skip the approval step if the approver is the CEO. We tried using the below query; however, it is neither skipping the hardcoded person nor w…
-
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g… -
Inquiry on Table for Bursting Email TrackingSummary: Inquiry on Table for Bursting Email Tracking Content (please ensure you mask any confidential information): In accordance with the requirement report, emails ha…