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
-
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen… -
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
OTBI AgentsWe have OTBI reports with more than 25000 rows (Approx 250000). To transfer data, we need to split them up into 10 to 15 agents by employee's name character or Person nu…
-
produce cost centres from 2 area onto one reportSummary: extracting table tables onto one report Content (required): I'd like to be able to validate the date between cost centres show in "Departments" in HCM vs " Cost…
-
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…
-
The scheduled BIP report is not received to gmail accountsSummary: Content (required): We've scheduled the report to be received by the users with specific roles. It is successfully delivered for some of the accounts but we hav… -
Reporting on rejection commentsSummary What is the name of the BI database table that stores the tracking of rejection comments for transactions?Content I was easily able to find / report on the comme… -
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…
-
As of DateSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…
-
catalog managerSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
Count of employees by Business Unit, Location and DepartmentWe need count of employees by Business Unit, Location and Department using OTBI. When we use count function, it shows same count for all business units instead of showin…
-
Count not coming correctAny idea why below XML is showing Column "Count as 2 " value = 2 for all business units. Column "Count1 using assignment " value = 0 for all business units.
-
How can I get "And" instead of "Or" to work with the same column filter?Summary: I have a sales team member column. Each team member respresents a different function on the team. Example: Primary and Overlay. I want to create a report that s…
-
How to query Location changesIs there an audit trail for Location changes that provides meaningful information? Someone made a change to a location and we're trying to determine who made the change.… -
I want to use hth.xml_data_cache.getClobVal() to get the Promotion details like new Position, etcSummary: I want to use the hth.xml_data_cache.getClobVal() function to display the Promotion details like new Position, new Manager, new Salary in separate columns. How … -
OTBI Analysis for Benefit Dependents over 21Summary: I need an OTBI analysis get information for dependents who are 21 years of age in every year. Content (required): I created an analysis based on Benefit Enrollm…
-
Talent Notification QueryHi, Is there are a way to query Talent Notification to check when the Enabled column for Talent Review notification was updated? -
How to pass login user name dynamically in the OTBI Report nameSummary How to pass login user name dynamically in the OTBI Report nameContent Hi Team, We have an OTBI report called Direct Reportees of Manager and it's working as exp…
-
How to control data view in BI reportDescription- We have created a custom role for recruiter and want to show data specific to his/her business unit in the custom BI report. Currently data view/access is a… -
It is possible to track compensation change statements line manager have already downloaded?Summary: Content (required): Hello experts, in the compensation change statements system page (please, see the attached screen) our customer want to create a checkbox wh… -
Infolet access - Learning Records Real TimeHello We build a report based upon the subject area Learning Records Real time and created an infolet. When making the infolet available to the employee, it doesn't give…
-
Filter schedule name based on week start date of timecardSummary: Report has only the schedule applicable to the timecard at time of commencement. Content (required): I have a timecard report that includes every schedule for t… -
Display Custom Message - Error when adding HTMLSummary: When I try and add HTML to the "Display Custom Message" I keep getting an error message (see below) Content (required): Version (include the version you are usi… -
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
Best fit % calculationSummary: Hi Expert, In OTBI do have have a subject area for best fit % calculation? in Talent management module. Thank you! Content (required): Version (include the vers…