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: 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 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: 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… -
per_bipntf_flex.getDFFAttributesFromCompare DOR DFF columns in notificationSummary: Need to show all the columns of DOR irrespective its updated or not Content (please ensure you mask any confidential information): We have business requirment i… -
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca… -
Terminated employee still visible as incumbents in position, how to free the vacant positionSummary: Terminated employee still visible as incumbents in position, how to free the vacant position Content (please ensure you mask any confidential information): Vers… -
Need XSD for XML Content Obtained After Decoding runReport reportBytes(BIP ExternalReportWSSService)Summary: Need XSD for XML Content Obtained After Decoding runReport reportBytes (BI Publisher ExternalReportWSSService) Content (please ensure you mask any confidential … -
Process to identify the list of scheduled reports which are not having bursting logic for RebrandingHi, We are currently undergoing a rebranding initiative and need to update email addresses used in reports. We have already reviewed reports with bursting logic. We now … -
Display Report Value Text as Alternative TextSummary: I am creating a report using the subject area of Workforce Management - Checklist Real Time. The column of Status within the Checklist Task Details folder has a… -
What is the back end column where component values of a worksheet plan are storedSummary: In what back end tables-columns are the values of columns: "Budget Percentage - Employee - Component 2" , "Percentage of Eligible Salary - Component 2" and "Bud… -
Sample report: Recruiting historical dashboard - open requisitions on month endSummary: The attached sample OTBI analysis will give you the total number of open requisitions at the end of each of the preceding 12 months. The report will not include… -
What tables stores the status for Check-In documents?Summary: Content (please ensure you mask any confidential information): I searched in hra_check_in_meetings but STATUS_CODE is always null. Version (include the version … -
-
Does anyone have a report that shows when an employee hasn't worked on a day they were schduled?Summary: We have a need to be able to report when an employee is scheduled to work, but doesn't have any hours for the day. It would need to include logic for absences i… -
Field SUBJECT_ID of hrq_qstnr_participants table: what does this ID represent?Summary: Content (please ensure you mask any confidential information): I tried PERSON_ID, EVALUATION_ID, ASSIGNMENT_ID, CHECKLIST_ID but still nothing Version (include … -
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… -
Set work schedule assignment flag to default "Yes"Summary: I need to modify the Primary Flag dropdown values on the Work Schedule Assignment page. Currently, the dropdown displays Yes and No options. The requirement is … -
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc. -
Not a Question: Dynamic Date Parameters in BI ReportContent This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes … -
26D Quarantine Reports System UpdateSummary: The new process in 26D that quarantines reports with a 50% failure rate over a 24-hour period does not specify whether the user will still be able to view and u… -
Restrict Recruiters from Rehiring Ex-Employees When "Rehire Recommended" = NoSummary: We have a business requirement to prevent recruiters from hiring former employees if the Rehire Recommended flag was marked as No during termination on the Work… -
BIP Report: How to set different decimal point based on countrySummary: How to set different decimal point based on country Content (please ensure you mask any confidential information): Is it possible to change the decimal point on… -
How Can We Link a UCM Content Server Data Set with a Secured SQL Data Set in BI Publisher?Summary: We are unable to link a UCM Content Server-based Data Set with an SQL query-based Data Set for role-based employee filtering. Content (please ensure you mask an… -
Report on Time zone Setting in Set PreferencesSummary: Is it possible to pull a report on the time zone setting within Set Preferences > Regional > Time zone Dropdown for a set of users? If it is possible to pull th… -
Disciplinary and GrievanceSummary: I have a report meant to capture both active and inactive records for a specific value in the subject area of personal real time. Because the criteria is set to… -
OTBI Folder DisappearanceSummary: Is anyone experiencing folders disappearing in the catalog? I pulled a report to see what happened to the folder, and there is no record of it being moved or de… -
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… -
Last Modified Date for Approval Rule SetSummary: For audit purposes, we are required to capture the LMD for a Rule Set. It seems the last update date on hrc_arm_approval_options does not update when the config…
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
Custom Approver Logic in BPM – Validating User Email/Access via BIP or Alternative ApproachSummary: In Oracle Fusion BPM, approval routing is typically based on predefined rules such as user, supervisory hierarchy, AOR, or role. However, we have a requirement … -
Tables for Document Type Security Profiles: report on profile-to-document-type assignments(OTBI/BIP)HCM Cloud > Core HR (or Security) Navigation of the setup: My Client Groups > Show More > Security Profiles > Document Type Security Profiles (Tasks: Manage Document Typ… -
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't… -
Visibility on per_person_secured_list_vSummary: Content (please ensure you mask any confidential information): What roles/setup are needed to be able to see rows on per_person_secured_list_v? Version (include…