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
-
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti… -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Oracle HCM Cloud Web Session Logging and SIEM IntegrationSummary: From the Security team's perspective, there is currently a visibility gap once a user authenticates into Oracle HCM. We can see the initial authentication activ… -
Display a Document of Records Image in a BIP ReportSummary: Hi All We have a requirement to display photos stored in Documents of Record within a BI Publisher (BIP) report. Has anyone implemented this before or can provi…
-
API to create individual compensation plan or Personal ContributionSummary: Hello , We are looking for guidance on the available Oracle HCM Cloud APIs for creating the following plans: Personal Contribution Plan Individual Compensation …
-
Legislation of Absence Type not visible in dropdown in Time Entry Layout Components taskSummary: How to identify which legislation does the absence type belongs to in the time entry layout components task while selecting absence management type? Content (pl…
-
Oracle HCM Reporting - Disable or Hide Parameter Based on Selection of Another ParameterSummary: We have two report parameters, Payroll Name and Consolidation Set, and need to make them mutually exclusive. When a value is selected for Payroll Name, the Cons…
-
ACA Eligibility Process updates Assignment Record with same action/action reason again on run dateSummary: When we run ACA Eligibiliy process lets say on 12/31/2025. It updates Assignment Record with previous/top of stack action and action reason. So if top of stack … -
What entitlement and roles do I need to be able to create and run query using sqls in BI report.Summary: What entitlement and roles do I need to be able to create and run query using sqls in BI report. I can access Person Management from the UI. But I want to creat…
-
Preview Offer didn't show Draft Watermark while previewing the offerSummary: Content (please ensure you mask any confidential information): Dears , I added Draft Watermark to the rtf file and while trying to preview the offer the draft w…
-
Draft WaterMark missing while previewingSummary: Content (please ensure you mask any confidential information): Dears , I am working on adding DRAFT watermark on rtf file , it working offline while testing on …
-
How to fetch when Auto provsioned roles were revoked from the user in Cloud Fusion HCMSummary: Hi All, We need to fetch details of Auto provisoned roles which were revoked from the user. Basically , the role name and when the auto provisioned role was rev…
-
Did Exec Admin Delegation change with the 26C upgradeSummary: Our Exec Admins who have delegation access can no longer schedule check-ins on behalf of our execs. When they log in, as themselves, and go to My Team . Team Ac… -
unable to see the custom manager types in OTBIHi, I'm using 'Workforce Management - Worker Assignment Event Real time' subject area, I've checked the matrix manager dimension as well, but i' don't find any other cus… -
How retrieve a list of BIP report names and paths that use a specific table name?Summary: How to retrieve a list of BIP report names and paths that use a specific table name? I wanted to know the list of BIP Data models used below benefit tables. Tab… -
Build BI Pub for Representatives Details InformationHi Everyone, We are currently building a BI Publisher report to retrieve detailed information about Representatives. The report and SQL query work as expected in our Tes… -
which duty roles would give access to BI Publisher Report which queries these tablesHello All, We want to give access to a custom role to a BI Publisher Report that queries these tables: per_periods_of_service ppos , per_assignment_secured_list_v paam ,… -
Canceled report job is still runningSummary: Hi all, We have canceled a report's schedule job but for some reason the report is still being generated and sent to the users. If we check the Manage Report Jo…
-
Emedded dashboard (through Page Integration) without granting access to CatalogSummary: I need to make a report available to a group of HR users. These users are not HR Specialists per se, meaning they should not be allowed to make changes to perso…
-
How to expose the Context Segment in the OTBI report ?We are using the Descriptive Flexfield "Person Allocated Task Attributes" (Flexfield Code: PER_PERSON_ALLOCATED_TASKS_DFF). This flexfield has Context Sensitive Segments… -
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…
-
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 … -
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 …
-
Table to get special purpose field of input valueHello, I'd like to know if anyone has an idea on where I can find the field of ''Special Purpose' and its value, whether it's a table or a query would be very helpful. I…
-
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)…
-
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 …
-
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…
-
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…
-
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…