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 add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp… -
How to trigger notifications to the Mobile Numbers instead of Email IdSummary: Hi Team, We know that the notifications will be triggered to Email IDs through bursting and the customer asks to trigger the notifications to the employee's mob… -
bip query is very slowSummary: I have written a BIP query which runs fast in SQL Connect using one bind variable. When placing the query into a BIP report there are no issues but the query so…
-
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At … -
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…
-
Importing Oracle JET Visualizations in OTBIWe have an ask from the Customer if we can import Oracle JET Visualizations in OTBI https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=home&demo… -
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…
-
Query to retrieve employee Job nameSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample SQL query retrieving the employee Job name visible in the ass…
-
Error when copying a report shortcut to another folderSummary: We are trying to setup a folder containing shortcuts to reports that are located in various folders across the OTBI tool, in order to simplify access to commonl… -
Succession Plan Report IssueHello there, We are trying to create an OTBI Report on Succession Plan Details .We have attempted to use all related subject areas for succession plan , but we keep enco…
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…
-
Termination Approval Process ReportHi… does someone have a report, either an OTBI or BIP, that captures the full termination process with comments, who it is/was assigned to, and status. We are having iss… -
Matrix Managers field onto a reportSummary Need to pull Matrix Manager field onto a standard OTBI reportContent Need help to understand how can I pull Matrix Manager field (Type as Matrix Manager in myHR)…
-
Payroll-Personal Payment Details Real Time - no data being returnedSummary: Trying to build a report showing employee bank account details from SA 'Payroll-Personal Payment Details Real Time' - I have the required roles (Payroll Mgr etc…
-
If a EFF does not have a value is there a way to pull it into reporting?Summary: We have some positions that have Extensible flex fields entered for Background checks and Licenses - but some of the positions do not have this yet (so essentia… -
SQL query to retrieve a common lookup description at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom common lookup. We need to extract at the employee level the lo…
-
Multiple Assignment ReportSummary: Does anyone have an XML or data model that captures employees with two (or multiple) active work assignments; showing job, department and manager details. Conte…
-
How do I remove notes formatting in reportI have a reprot that pulls notes information which users can format. How do I change the output to where the special characters do not show up on the report?
-
Oracle Recruiting - DeepLink to Candidate general profileContent Hi Team, Is there a way to have a deeplink for candidate profile (general profile)? Thank you, Shikha Version 20D -
Why are there different formats of the Transaction Analysis Duty role codes?Summary: Some Transaction Analysis Duty role codes follow this format: "ORA_FBI...DUTY_HCM" and others this format: "FBI…DUTY". Is there any significance to the role cod…
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Participant Feedback - Questionnaire Responses duplicationSummary: Dear Team, We have a Performance template which has the Participant feedback included and would like to capture the responses provided by the Participants in th… -
HCM Position HierarchySummary: Hello, I created an OTBI using Position Real Time subject area but I am not able to get the desired results. Example, I have below position hierarchy Position1 …
-
function to return fast formula return variabledo we have any function / package in hcm that we can use in BI query to retrieve the return values from a Fast Formula. Like we have one for value sets (pay_ff_functions…
-
Building a custom report for pay ratesSummary Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.Content The tables hol… -
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
HOW TO DELETE INACTIVE USERS IN fUSIONSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…
-
Difference between Headcount and worker count in fusion analytics dashboardsSummary: Why are there two extremely similar workbooks (for many metrics) which include Person Count and some which do not. Their descriptions show the only difference i…