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
-
Get the "Related Materials" attachment in Learning reportSummary: Content (required): hi there, I have a learning report but want to capture also a link to the related materials on the Offering level. see image. is that even p… -
Is there a way to export HCM organizational charts?Summary: What are the options to take HCM organizational charts and export them in some type of format that could be used in a PowerPoint? Content (please ensure you mas… -
Hide catalog and home options to usersSummary: Hide catalog and home options to users Content (please ensure you mask any confidential information): Hi Team, I have a requirment, in my organization under me …
-
Can we use Line Manager Dashboard to build HR Dashboard by removing securityWe want to build HR Dashboard, however most of the metrics are already available in Line Manager Dashboard. So can we re-use Line Manager Dashboard by removing security …
-
Multiple External Identifiers in OTBI would like in separate columns and to include null valuesContent Our organization has multiple External Person Identifier Types that we need to report off of (Taleo ID and Oracle Transportation Management Number). As opposed t…
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there … -
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
document recordSummary: If I upload documents to document records, I want a report to show me the details of the document as entered into Oracle, the ability to filter by document type…
-
Person security profile to restrict hourly employees in BIP reportsSummary: We have created a data role and person security profile created to display only Hourly employees In person security profile provided -- secure by AOR -- Respons…
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF … -
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…
-
Remove NULL option in a PromptSummary: Content (required): hi there, I have a prompt that filters the employees in a learning dashboard report. I get also at the top the NULL option. How can I exclud…
-
OTBI external identifier not appearing when Department is selectedHello I am trying to get a specific external id type through OTBI. I've managed to do this using MAX (there are multiple types), but when I add the Department, position … -
how to loop through a value set from a fast formula to get multiple valuesHi All, I have requirement to get multiple rows from a value set from a loop and then add up all the returned values from the value set in the fast formula. how can this…
-
How to fetch the Initials of the employee using OTBI?How to fetch the Initials of the employee using OTBI?
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1… -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…
-
Pulling Goal Success Criteria without the HTML TagsSummary Is there a way to pull goal information without the html tags?Content Hello, I am looking to report on the Goal Information from HCM Fusion Release 11. When we p… -
For Goal notes report as well the description is in HTML format in the report.Hi Team, We are trying to pull a goal report along with long description and it is pulling the text in HTML format. Is there a possibility to get normal text for descrip… -
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …
-
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…
-
Can I make the parameters more dynamic so they show only values relevant to the management hierarchySummary: Can I make the parameters more dynamic so they show only values relevant to the management hierarchy in line manager dashboard? Content (please ensure you mask …
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da…
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 63 views 12 comments 0 points Most recent by Jenna Savage - Hunter Douglas
-
Query for finding Assignment number from Calculation Card under Associations.Summary: Need a query through which we can find assignment number from calculation card under association. Content (required): Hi All, Can anyone please share the query … -
Query to fetch DFF's used across modules in a PODSummary Query to fetch DFF's used across modules in a PODContent Hi Team, Please help with this: Please share query which shares all DFF's used across modules in a POD l…