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
-
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 34 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 49 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 43 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 48 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 81 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…
-
Need to have Bar code on Oracle Fusion HCM BIP ReportsSummary Need to have Bar code on Oracle Fusion HCM BIP Reports - methods used not workingContent Hi, We have tried 2 methods for displaying bar code in BIP report follow…
-
How to link consecutive absences with same absence type together in an analysisContent We are not using OT&L and have an interface bringing in absence hours into Oracle HCM. The absences are stored in 1 day intervals so when we have employees on a …
-
Table name for Comments in a Learning CommunityContent For every learning community, members can comment using the seeded Comments functionality. We have a requirement to report on the comments made by the users. We … -
Deriving IS Manager column in OTBISummary Deriving IS Manager column in OTBIContent Hi ALL, I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssig…User_2025-02-07-19-03-14-525 58 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
How to get SalaryId information from ReportingContent Hello experts, I have noticed that in Compensation subject areas I cannot retrieve the SalaryId information. I need this information to massively correct Salary … -
Get the list of persons included in an Access Group for a Learning OfferingContent Hi everybody, for an Offering in the Learning Catalog I have created an Access Group. I would like to extract from HCM tables the list of persons that are includ…