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
-
Link a report to a button near to the All-in-One evaluationSummary: Content (please ensure you mask any confidential information): Hi experts, I need to add a link that redirect me to a dashboard. Is it possible to achieve it th… -
OTBI subject area for Job responsibilitiesSummary: Looking for the subject area to report on job responsibilities and weights associated. From the job profile Content (please ensure you mask any confidential inf…
-
Where can I find the table for phase and state submission date?Summary: Table for phase and state submission date. Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex… -
Which action for a DEEP LINK can I use to manage a REQUSITION in DRAFT status?I need to create a custom notification with a link that leads to the detail of a requisition that is in draft status. I've tried with this deep link: //fndSetup/faces/de…
-
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will …
-
We have a requirement to fetch salary component calculation columns in OTBI and a stat graph.Summary: We have a requirement to fetch all these calculation columns in OTBI as we have partially developed the solution in BIP, but client want this in OTBI so can we …
-
Grade MidpointSummary Joining Worker Assignment Real Time to Grade Rate Real TimeContent Hi, we're currently building reports for use in UAT ahead of upgrade to Cloud next year. I've … -
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…
-
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …
-
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag…
-
Comparing columns from two different Analysis areas.Summary Comparing columns from two different Analysis areas.Content I am attempting to grab Job Codes for employees and the grades for the jobs. In the analysis i am usi…
-
Joining Grade/Grate Rate with Job and PositionSummary Joining Grade/Grate Rate with Job and PositionContent I am looking to report Midpoints for Jobs and Positions. Is there a way to join "Grade Rate Real Time" Subj… -
Report - Hourly/Salaried vs Rate Value for the GradeSummary Looking to crate a report to get Hourly/Salaried vs Rate Value for the GradeContent From Person Management - Get If person is Hourly or Salaried. Then navigate t…
-
Issue with Grade Rate Real Time Subject AreaSummary Grade Rate value is not returnedContent We had a requirement to display all workers who has a current salary not equal to the current grade step rate value i.e, …
-
How to restrict based on previous Backout statusSummary: Hello All, I'm currently working on restricting the custom BIP notification based on below scenario. If an employee benefits is backed out and reprocessed again…
-
How to report on missing Costing of Positions?Summary: Content (please ensure you mask any confidential information): I'm trying to find a way to report on Position Costing that is missing. In the 'costing of positi…
-
Pending Approver when a transaction is claimedSummary: The transaction detail analysis as well as the SQLs do not provide the information of the current approver when a transaction is claimed in case of parallel app… -
Leader Dashboard for Oracle Cloud HCM 22CHello, Any guidance on where I can find the Out of the Box documentation for the Leader Dashboard for Oracle Cloud HCM, 22C? Thank you, Tanya
-
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic…
-
Scheduling a BIP Report for Biweekly...Summary Bi-Weekly schedulingContent HI All, I was wondering if there was any way to easily schedule a report to be run bi-weekly. We have some reports that need to be ru…
-
Parameter definition in reportI will use the last_update_date parameter in the report I prepare. But I want to use the last_update_date column in more than one table in a single parameter. For Ex: pe… -
manager hierarchy analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Standard template Compensation Change statements notificationContent Hello experts, I need to change the notification template the employee receive when Compensation Change Statements is available in Person Information> My Compens… -
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…
-
Only display the row with the earliest seniority dateSummary: Hi I'm creating a basic staff list which has seniority date on (some of our staff have protected service from a previous company) and I need to be able to show … -
how to get latest anniversary seniorSummary: How to get the most recent date to show on an employee transaction Content (please ensure you mask any confidential information): In OTBI, using the subject 'Wo…
-
BIP report job status - difference between 'failed' and 'skipped'Summary: BIP job status - skipped and failed - what do these mean Content (required): We have a number of BIP report jobs running to send out letters / notifications to …
-
How to join cmp_stock_details & hrc_integration_key_mapSummary: We are trying to create a report for fetch source system ID used for loading stock but No joins are available to join cmp_stock_details & hrc_integration_key_ma…
-
How to add the EEO 4 field from Job to a OTBI report?Summary: Adding EEO 4 field to a OTBI report Content (required): Hello - how can you add the EEO 4 field to a OTBI report? I am able to locate the EEO-1 field but not EE…