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
-
Talent Review Meeting Report-Security BIPSummary: How can we limit the visibility of the Talent Review Meeting Report so that facilitators can only view the meetings where they are assigned as a facilitator, wi… -
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …
-
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo… -
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo… -
OTBI Export Using Formatted > Excel Row LimitationGood Day, I have a set of data consisting of 90,000+ rows. Exporting via Data > Excel, all rows are retrieving when exported. But exporting using Formatted > Excel, it o…
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can … -
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
User History ReportSummary: Is there any standard report in Oracle Fusion which provides details of when users were added? I know there's a 'User History Report' - but that needs to be run…
-
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t… -
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can… -
Opportunity market place report - Self service PUBLICSummary: Do you have any report available that could help me to provide a listing of all jobs available in opportunity marketplace ? The report should be public (linked …
-
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a…
-
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn… -
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…
-
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you… -
Sql query or Table name for Workforce Compensation plan cycles assigned to planHi team, We are unable to find the table where the "Plan cycles" information stored for HCM compensation module. Could you please provide us the table or sql query to ge…
-
Some job codes drop from report when I add minimum from grade rate valueSummary: I have a report from Compensation - Workforce Assignment Salary Real Time. I added job code (filtered to included >0499), job name, FLSA status and it's working…
-
Profile BIP_CLIENT_REFRESH_TIME_HCM is not working as ExpectedStep1 Manage Administrator Profile Values Search for Profile :BIP_CLIENT_REFRESH_TIME_HCM Profile Value is 1440 Step2 we updated the profile value to 15 at Site level Sa…
-
User Entity to extract Absence plan enrollments of an employeeSummary: I have a requirement to extract all absence plan enrollments of an employee , using HCM Extract. I am looking for a User Entity which can suffice this need. The…
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…
-
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post. -
Report Error- Oracle HCM BIP ReportSummary: Error populates for a HR Admin user with data security that excludes specific HR depts. The report parameters page does not load for these types of users. This … -
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, https://us.v-cdn.net/6…
-
Sickness Absence - Working Days LostSummary: Hi Is there any way to calculate Working Days Lost in OTBI for sickness absence? We are using the Absence Real Time subject area and have Calendar Days Lost cal…
-
how I can measure application usage in HCMSummary: Now a days i need to verify if my users are using the app, for example if they are creating new depts, they hire new persons or they are be in some feature in s…
-
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…
-
Observation Checklist Link not found in Oracle TablesHow is the observation checklist link/URL being created or generated to use for notification? Can it be found in Oracle tables? Where could the link be stored? Is there …
-
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the…
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…