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
-
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
PER_EXTRACT_UTILITY performance in reportingSummary: Hi experts, quick question, is PER_EXTRACT_UTILITY faster than querying the actual table in BIP? e.g. we can use get_decoded_lookup to get the Meaning of the lo…
-
What replaces deprecated HCM Learning PVOs in 26.R3.P1 Release for FDISummary: In the FDI Release 26.R3.P1, the following PVOs are being deprecated as a source for data enrichment: HcmTopModelAnalyticsGlobalAM.ContentAM.LearningItemPVO Hcm…
-
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary: Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting ru…
-
How Can We Identify Whether The User Is Logged In Via SSO OR Native LoginHi Team, We have enabled both SSO and Native login for our pod and wanted to know how the users are logging into the system. Is it by SSO or Native login. Please suggest…
-
HCM Profile-> Set Preference-> LanguagesI want table to get data from Profile-> Set Preference-> Languages. and want joins to create relation between profile and language. profile-> Set Preference-> Languages … -
HCMAIAgentBy enabling the Enhanced Representative Agent and Personal Information Assistant AI Agent in HCM would their be additional License cost for the customer. If yes which SK…
-
How to use attachment tab in datamodelHi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from c… -
Looking for SQL to Retrieve BI Report Job History and Deleted Job History in Oracle FusionHi everyone, I have a requirement to retrieve BI Report job history using SQL in Oracle Fusion. I also need to identify or retrieve deleted/removed BI report job history… -
How to get Home and Work Email outSummary: I'm trying to build a report that includes both Home and Work Email. I have sufficient privileges to view and report on this data. Currently I have Workforce Ma…
-
BIP Bursting LimitHi all, Hopefully a very quick one. Is there a limit at all to how many emails can be bursted out of BIP? I can't seem to find any documentation online so wanted to ask …
-
BICC Deprecated PVOs for 26CCould you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test en… -
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development… -
Current Date Agent Set UpSummary: I am using Workforce Assignment Real Time and Workforce Relationship Real Time. An agent provides the data. Because the agent exports rather than pulling the cu…
-
createException: Security violation... permission: 16578Summary: I created a report but a few users receive this error message, why? Content (please ensure you mask any confidential information): Version (include the version … -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…
-
Bulk Agent DistributionSummary: For custom Outlook distributions, we first create the custom report in OTBI to capture the list of team members for Outlook, export it individually, and upload …
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke…
-
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26CSummary: Hi, Can anyone please share R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26C release Thanks, Content (please ensure you …
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull… -
FDI : action & on click on calculated "Without Check-Ins" always redirects to "With Check-Ins" datahave a bar chart visual with: X-axis: Business Unit (from "HCM - Workforce Core" subject area) Y-axis values: Worker with Check-Ins (from "HCM - Check-Ins" subject area)…
-
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette… -
Subject Area for Terminated Employee Last SalarySummary Subject Area for Terminated Employee Last SalaryContent While using "Compensation - Salary Details Real Time" subject area we are not getting terminated employee… -
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o… -
Oracle Fusion HCM Fast Formula Compilation Issue – PLSQL_CREATED = N and Missing Database ObjectsSummary: Hi All, We are currently facing a compilation issue with one of our custom Fast Formulas in Oracle Fusion HCM. I would appreciate any guidance from the communit…
-
How to get the details of action items which are denied?Summary: Need details of the action items which are denied along with their denied date Content (please ensure you mask any confidential information): We have a requirem…
-
Payroll Reports Performance Impact After 26C Introduction of "Quick Pay" TaskSummary: Hi everyone We are experiencing a significant performance degradation in a custom BI Publisher payroll reports after our environment was updated to release 26C.…