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
-
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 16 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 139 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 29 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 45 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… -
Any way to restrict BIP output file either with Datamodel name or Template nameContent Hi All, When we click on OPEN on BIP report and enter required parameters and then click on apply button it will generate output in Excel format as DatamodelName…
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…
-
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s…
-
Acting Up AllowanceSummary report showing old & new salaryContent Hi, I'm trying to build a report that shows employees that have or currently 'acting up' - I'd like the report to show the…User_2025-02-05-22-44-35-842 35 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
OTBI - Expression needed to filter dateSummary OTBI - Expression needed to filter last day workedContent Can someone help me with an expression for an OTBI analysis? I need to a filter on the last day worked … -
Adding parameters for BIP Report built using OTBI AnalysisSummary How to add parameters within BIP Data Model built using for OTBI Analysis data set ?Content We have built a BI publisher report using a OTBI Analysis in the data… -
In process Termination ReportContent Has anyone developed a report that shows terminations in process and who it is currently pending approval with? Ideally we'd like a report that includes date/tim…User_2025-01-28-07-43-27-066 43 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Termination category blank - how to solve?Summary How to have termination category for active employees with termination as future recordContent Hi, we need to identify active employees that have a termination p…
-
Can we hide Factory delivered folders from Reports and Analytics based on role?Summary We have a requirement to hide all the factory delivered folders except Human Capital Management from Reports and Analytics.Content Requirement is : When login as…
-
Change ordering of values in horizontal axis of graphSummary Change ordering of values in horizontal axis of graphContent We have a simple graph from OTBI but want to change the display order of the values on the horizonta…
-
Master reports for Job, grade, location, department, position, active and ex-employee headcountContent Any Master reports available for Job, grade, location, department, position, active and ex-employee headcount?User_2025-02-06-14-37-05-233 71 views 4 comments 1 point Most recent by User_2025-02-06-14-37-05-233
-
HCM BI Report - table to extract value set data (table type)Summary HCM BI Report - table to extract value set definition (table type)Content Hi, I'm creating a BI report to show Value Set Definition (Table Type) and wonder which…