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
-
Learning Ad hoc Access Group Deleted From UI are showing Active in BIP tablesSummary: I am fetching all the learning items along with access and access group assigned to them. Once I created access using Access tab under Learner tab I am able to … -
Reporting on Uptake of Course across OrganisationSummary: Requirement to work out the uptake of a course and show in graph form Content (required): Hello We have a course that has been created that we expect managers t…
-
Can we change fetch First 250001 Rows Only to any other values?Summary: Can we change fetch First 250001 Rows Only to any other values? Content (required): Can we change fetch First 250001 Rows Only to any other values? It seems thi… -
Number of days an employee works in the departmentHi, In our setup, an employee can work in different departments. For this, I need a SQL query that returns information on how many hours an employee works in a departmen… -
descriptive flexfield in job to be retrieved in query and joined with personSummary: descriptive flexfield in job to be retrieved in query and joined with person. Not able to join with person. Please share some references ffvs.flex_value_set_nam…
-
Performance Issue in Workforce Management - Workforce Trend Real Time subject areaSummary Performance Issue in Workforce Management - Workforce Trend Real Time subject areaContent Hi Team, We have a line manager dashboard where for one tab we are usin…
-
BIP Job History Retention PeriodSummary: BIP Job History Retention Period Content (required): I'm trying to give clear guidance to our customer, and I'm unable to find a consistent answer on this topic…
-
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…
-
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…
-
Is it possible to change time zone on CURRENT_DATE SQL filter?Summary We have noticed that when we use CURRENT_DATE as a filter, the data is pulled using UTC time as the current date. Has anyone else run into this issue?Content Hi …
-
In Approval Notification Assignment number needs to be hidden as Part of workflowSummary: Hi Folks, In Approval Notification Assignment number needs to be hidden/removed as Part of workflow notification. Kindly help me with action plan to sort out th… -
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…
-
SQL to derive the Department names for all the personSummary: Hello we have a requirement where we need to bring the data of the department on the custom attributes created via application composer, however could not be ab…
-
SQL query to extract UDT tableHello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following. Can anyone suggest a …
-
United States Job Information Extensible Flexible Attribute not BI EnabledSummary: 2 of the attributes in United States Job Information Extensible Flexible are not BI Enabled. The flexfield is protected hence no changes can be made. Please see…
-
JOIN Person Real Time Subject Area with Workforce Management - Worker Assignment Event RealSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
DOR Workflow Notification CustomizationSummary: DOR Workflow Notification Customization Content (required): Hi All, We get a requirement like, whenever employee added their bank details in DOR, one approval n…
-
How to fetch list of reports linked to a security role?Summary: Required list of all reports linked to a security role or list of all the reports with their permissions. Content (required): Subject areas or query through whi…
-
A better way to convert HTML entities to special characters in a BI report.Summary: A better way to convert HTML entities to special characters in a BI report. Content (required): I'm looking for a way to convert HTML entities to special charac…
-
Tables to get bursting output and delivery detailsSummary: Tables to get bursting output and delivery details Content (required): Hi All, Is it possible to get bursting delivery details? For example, which user the burs…
-
IS it possible to extract report on total number of self downloadable the report in employees folderSummary: HI Team, in this path Shared>Custom>employee -folder we placed the self downloadable letters so we need to extract report on total number of self downloadable. … -
Permissions for Customized Seeded ReportsSummary: When we're going to customize a seeded report, shall we retain the permission that has been set up in the customized folder? For example: Job Offer seeded repor… -
PGPSummary: Hello, all the times we need to configure PGP the system need to receive the file send us the PGP. Now we are facing a new situation where we need to send to th…
-
We were trying to create a separate Role to Update Folder And Report Permission in BI.Summary: We are trying to provide update folder permission and manage privilege access to a separate role. Even after creating the role and updated it in Manage privileg…
-
Unable to find Organization goals Check Box in HCM tables.Summary: Dear , I want to know in oracle fusion which table I can find "Share this goal with your organization" .I was searched all goals tables but not found in table T…
-
which table can store the bip report permissions detailsHi All, Could you please let me know ,which table can store the bip report permissions details. Thanks For Your Help!! Ravindra
-
Payroll Element Entries - Context Sensitive Displayed Input Values - how to get on one rowSummary: Hello, I am using the SA Payroll Element Entries to try to get an employee allowance report. The issue I have is one of the fields 'Displayed Input Values' is c…
-
How to aggregate all notifications from Oracle HCM Cloud into single daily email?Summary Looking for ways to deliver email that contains all worklist notifications for the dayContent My client is asking if there is a way to aggregate all notification… -
Need SQL query to get absence leave requests which are in denied status.Summary: Hi Team, Can we have a SQL query to get absence leave requests which are in denied status. Thanks, Madhuri.
-
How to get the list of users who has downloaded a specific report in HCM Shared folderSummary: To get the list of users along with time, who has downloaded a report from HCM Folder Navigation : Shared folder --> Pick any report --> Open the report --> Exp…