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
-
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… -
query to pull Reporting information calculation cardSummary: query to pull Reporting information calculation card Content (required): Hi All, Greetings! We are looking for a query to pull Reporting information calculation… -
Sort breaking RCOUNT in logical SQL analysisHello, I have a fairly complex logical SQL report combining 5 subject areas. Overall, the information is displaying correctly with no issues. However, I have a need to R… -
Oracle Recruiting Cloud (ORC) Requisition Submission events history trackingSummary: IRC_SUBMISSIONS table holds a snapshot of a last step in process but a complete history of submission processing events is required. Content (required): Is it p…
-
How can we view an employees current department in performance document reporting?Summary: We have a requirement to include the Department Name and Organizational Hierarchy levels in analyses of Performance Document completions. However if an employee…
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi… -
Absence Accrual report in OTBISummary: Hi All, We have a requirement to develop OTBI Report for Absence Accruals. I couldn't able to get the accrual details. Does any one have catalog file or know ab…
-
BIP Report - Dynamic Password Protection For Excel OutputSummary: Is it possible to protect the BIP Report excel output file with Dynamic password? Content (required): Hi Team, I am looking for dynamic password protection for …
-
Person Contact Relationship Marital StatusHello Oracle Community, I am trying to develop a demographic of dependent report by using OTBI subject area: Person Real Time. I am having a challenge to find marital st…
-
BIP Data Model with an Excel Data sourceSummary: I have a BIP data model with an HCM SQL data set/source and an Excel data set/source, which pulls the required data successfully. However, when I refresh the ex…