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
-
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug… -
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo… -
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this … -
Highlight a change within an AnalysisSummary Highlight a change within an AnalysisContent Hello, I have an bonus change report and I want to be able to highlight when the bonus percentage changes. Anyone ha… -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…
-
Joining iby_ext_bank_accounts_ audit table with the person recordSummary Joining iby_ext_bank_accounts_ audit table with the person recordContent Hi All, I am trying to create the audit report for the Bank Account Changes and want to …
-
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w… -
Round a summed total?Summary Round a summed total?Content I have an OTBI analysis and on a column it does the aggregate sum - so summing each value based on how I have it grouped in the resu… -
Precedence of security roles for custom BIP reportsContent If we have 2 roles attached to the BIP report, one of them should have Read, Traverse access and another one should not have access what would be the precedence …
-
OTBI - Date prompt from and to dateContent Hi Team, I am using a date prompt between from and to date. Issue is that during negative testing - user is trying to check if the system gives error for From da… -
Termination analysis does not bring all records when dynamic dates are usedSummary When a hard coded dates are used in the analysis or date is entered through the prompt selection, it works fine. However when the range is determined dynamically…
-
How to read Context Segment DFF and associate it to employee record?Summary How to read Context Segment DFF and associate it to employee record?Content Hello, I have information stored in the assignment attribute 2 of the PER_ASG_DF DFF …
-
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. … -
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…
-
Analysis of platform usabilityContent Hello experts Does anyone have any query analysis or report that enables us to see system data like. Users who are accessing most the POD (LOGINS) Which Modules … -
Time Card approver details for multiple AssignmentSummary Require Approver details for each assignment hours in Tiime CardContent Hi Team, I have a requirement to get the approver details for each assignment hours in th…User_2025-02-04-13-27-19-123 22 views 2 comments 0 points Most recent by User_2025-02-04-13-27-19-123
-
Time Card issues -Actual Period start Date DBI from Time & Labor.Content Hi Expert do you have any idea to fetch Actual Period start Date in Time & labor . I have created a new hire "XXXX" with the hire date of '02/23/2021' ( same dat…
-
How to get Level (distance from CEO) in a BI reportSummary How to get Level (distance from CEO) in a BI report (i.e. CEO direct report is Level 1)Content Hello, do you have a query that extract the level? The level is th…
-
Need details on right place to get each salary component exact value but not adjustmentSummary Need details on right place to get each salary component exact value but not adjustmentContent In current configuration, monthly salary basis is configured with …
-
Impact of creating a Customer specific custom folder in parallel to seeded Shared/Custom folder inSummary what are the impact of creating new folder parallel to seeded Shared/Custom folderContent Hi Team, Do you see any impact, if we create a new custom folder direct… -
Query underlying UCM tableSummary Query underlying UCM tableContent Is there an available table or view that gives access to the UCM? I don't care about the actual attachment and the contents wit…
-
Parameterized Bi Report Within A Dashboard Is Not WorkingContent Hi Team, Greetings of the day!! I have created a dashboard with BI Report having one parameter. The report is working as expected with the same parameter but in …
-
Pull data between 2 dates using Subject AreasSummary Pull data between 2 datesContent Good Evening, Has any one had luck with pulling historical information in between 2 dates? For example, we had someone who was o…
-
how to create an OTBI Report to extract Employee details who do not have Line Manager RoleSummary OTBI Report to extract Employee details who do not have Line Manager RoleUser_2025-01-29-02-01-53-212 62 views 7 comments 0 points Most recent by User_2025-01-30-20-59-13-989
-
Job DurationSummary Provides the duration of the workers in a specific jobContent This analysis provides the duration(in days) of the workers in all the jobs that they have held so … -
Learning Assignment Event TypeContent Hello Experts. I need to do an Analysis that gives me if the course assignment is Required or Voluntary. I was Unable to map it into the Workforce Learning - Lea…
-
OTBI for enrollment in OLC - Selection of one Department in One locattion and All Departments in AnoContent Hi there, I am using OTBI report for enrollment in OLC. I need to create a report that includes - All the Departments in Location A and - One Department in Locat…