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
-
Calendar PromptSummary I would like to add a calendar promptContent Hi, I have added AsOf date prompts to various reports and here I would like to include a between date prompt using t…User_2025-02-05-22-44-35-842 72 views 5 comments 1 point Most recent by User_2025-02-05-22-44-35-842 -
OTBI Matrix Manager ReportSummary OTBI Matrix Manager ReportContent Hi Team, We are working on a OTBI report where client want to add all matrix managers and should extract all manager in single …User_2025-02-01-03-43-13-079 118 views 2 comments 2 points Most recent by User_2025-02-01-03-43-13-079
-
Looking for solution to "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#4Content Hi, I have a requirement exactly like "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#407101". I am not able to resolve it using MAX()…User_2025-02-06-14-37-05-233 34 views 2 comments 1 point Most recent by User_2025-02-06-14-37-05-233
-
How Extract flexfield attributes of departmentContent Hello Guys, I need to extract the flex-field attributes of department, but by using this query I don't find any things. Moreover, I have a lot of duplicate rows … -
Parent manager blank for terminated employees.Summary Parent manager blank for terminated employees, how to retrieve manager hierarchyContent Hi all, we are facing some issues with OTBI report, we are using Parent M… -
Recommend to RehireSummary Termination - Recommend to RehireContent Hi, Where can I find the 'Recommend to Rehire' flag value to report on? For context, when someone terminates a dropdown …User_2025-02-05-22-44-35-842 74 views 6 comments 2 points Most recent by User_2025-02-05-22-44-35-842
-
Role related issue while running a BIP report via HR Dashboard in HCM CloudSummary Role related issue while running a BIP report via HR Dashboard in HCM CloudContent Hi, I have a BIP report developed which is working fine as is when checking da… -
Audit report for individual compensation dataSummary Audit report for individual compensation dataContent Hello, we are trying to run the Audit report (https://docs.oracle.com/en/cloud/saas/global-human-resources/1…
-
Graphs in OTBISummary Can graph with data count be created in OTBIContent Can we create a graph close to how it is shown in the image in OTBI? -
Unable To Export To CSVSummary Enable CSV is enabled in the data model, but am not able to export to CSV.Content We have an existing report that the business would like to be able to export to…
-
Payroll - Element Entries Unable to View Element NameSummary Unable to view the element nameContent I'm using the Payroll - Element Entries Real Time Subject Area for my report I've chosen various dimensions for the report…
-
how to restrict an analysis to 1 assignmentContent In our HCM setup we can have people with multiple assignments which are active. What I want to do is get the most current/latest assignment. The primary flag doe…
-
Error while joining two subject areasSummary Error while joining two subject areas (No fact table exists at the requested level of detail:)Content I am trying to fetch list of roles that a worker has along …
-
OTBI Prompt: User Selects Operator "Between"Summary If you allow users to select the operator for a date prompt, the value "between" is not available.Content We have a requirement to allow end users to select the … -
Element Entry for Each WorkerContent Hi Guys, I have to create a report that allow me to extract the Element Entries associated to each worker. But I have a problem, when I Add the "Worker"."name" c…
-
Shared mailing addressesSummary Require a report to show employees that have the same mailing addressContent Is it possible to generate a report that shows 2 employees residing at the same addr…User_2025-02-04-08-51-08-912 17 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912
-
No data in Human Capital Management - Approval Notification Real Time after Sep-2019Summary No data in Human Capital Management - Approval Notification Real Time after Sep-2019Content Hello I am trying to write a report to show the approval date for sic…
-
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…User_2025-01-29-02-09-34-137 140 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani
-
Instance name - TableSummary Instance name - TableContent Hi Team, I want to know the Instance details available table or DBI or UE. We are using email options in the extract to send the out…
-
Request to have Single Screen SOE with ability to navigate between pay checksSummary Ability to view Regular and supplemental run payments in single screen instead navigating to multiple screensContent Use Case: The customer processes quite a few…
-
Deriving column value based in ROLE.Summary Deriving column value based in ROLE.Content Hi All, Need HELP I'm creating report in OTBI and in report there is field call"Is Manager" and logic for this field …
-
SQL for report columnsSummary SQL for report columnsContent I want to be able to query an analysis and get a list of columns that are used in that analysis.
-
Is it possible to have email recipient in Agent based on Area of Responsibility?Summary I am creating an email notification for New Hires with benefits enrollment details using Subject Areas and I would like to have the email recipients based on the…
-
Benefits - Events in Started StatusSummary Report of events in Started StatusContent Hi All I am trying to run a report of employees who have life events that are in Started Status. I am getting multiple …User_2025-02-01-05-13-28-270 30 views 6 comments 0 points Most recent by User_2025-02-01-05-13-28-270
-
Avoid Drill down on pie chartSummary How to avoid drill down on pie chartsContent Hi folks, I tried to do some configuration in order to avoid drill down on pie charts (on column properties, see att…
-
How to I achieve DD-MON-RRRR in output of BI publisher report for a dateSummary How to I achieve DD-MON-RRRR in output of BI publisher report for a dateContent Hi, I transform my date column in the required format using TO_CHAR(effective_sta…
-
Need table Name for Job Statuses on Data exchangeContent Hi All, We all see our HDL job statuses on the Data exchange under my client groups->Data exchange. Can anyone please let me know if there are any table names av…
-
Can we limit the selection from the LOV in BI reports?Summary I want a functionality of my report to behave in a way where it should give me an error if I select more than 4 values from the LOV of 8 values.Content Hi, I wan…
-
SQL Help required - pulling manager for rehiresSummary Query was built to pull in Areas of responsibility - Manager details but for rehires, it seems to be picking up their previous recordContent I have been trying t…User_2025-02-04-08-51-08-912 46 views 5 comments 1 point Most recent by User_2025-02-04-08-51-08-912
-
BI Table Name to fetch Data Type under Column Assignment of Global SegmentContent Hi Team, I am trying to fetch Data Type under Column Assignment of the Global Segment Details. Please let me know the backend table name which stores that. Thank…