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
-
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat… -
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…
-
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…
-
Report footer not showing completely in report outputSummary: Report footer not showing completely in report output. My client wants to display this footer on all the reports. When I run the report then everything in the f… -
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. … -
Learning Access Group Organization Chart Selection Method Details -BIP Table mappingSummary: We have a requirement to develop BIP report for all learning items where we need to fetch the name of selection method for Organization Chart Criteria. We have …
-
How to add Calendar chart in OTBI Analysis under Learning Module?Summary: Hi Everyone, I have a requirement to implement a Calendar Dashboard that has an identifier if an activity is scheduled for that date - e.g. turns green if class…
-
Number of attempts by each learner are not showingHello, I need to get the number of attempts that a learner did on a course. Example below: Offering Title: JV Test 01/18_SP Person number: 001670007 1st attempt - 50 2nd…
-
Recruitment questions in all blocksSummary: Hi , I would like to report on all questions in the pre-screening form for a candidate. The questions for the job requisition appear but not the questions in ot…
-
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…
-
Candidate and Job Application Source-TrackingWe drew the statistics from the recruit to hire dashboard, and need clarification on how these are being collected and what those source mean. We inserted a pre-screenin…
-
how to join pay_tasks_vl table with person number?i wanted to fetch task name from (pay_tasks_vl) for a particular person but not getting how to join this table with person details
-
Using BI Publisher attempting for get Learner - Self Service Setting and if overwrittenSummary: Using BI Publisher tables I am attempting to get default access - learner serf-service setting on a catalog/enrollment and then see if it was overwritten at the… -
Privilege to Perform Location Changes from Manage in SpreadsheetWould there be a way to run a report of all active/inactive locations in Location Details? And would there be a way (with a privilege, AOR, or role) to download the loca…
-
How to display a prompt for Job Code on an OTBI Analysis?Summary: I'm trying to create a guided journey using an OTBI developed. However, I need the report to be prompted with the job code in the assignment area. I can't seem …
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The … -
How to link an assignment to a requisition or to a job offer?Summary: We are in the need to identify if an internal transfer came from a Requisition Content (please ensure you mask any confidential information): We are trying to b…
-
Requisition Staffing agency fields in OTBI do not show any dataSummary: Requisition Staffing agency fields in OTBI do not show any data Content (please ensure you mask any confidential information): Recruiting Real time Subject area…
-
Tax Reporting Unit field on OfferSummary: Where can I pull the Tax Reporting Unit that is listed on a candidate's offer. Understand that the TRU name is on the hr_organization_units_f_tl, however, how c…
-
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does… -
No results using subject area Help Desk - HR Service Request LifecycleSummary: I'm trying to create an analysis using Help Desk - HR Service Request Lifecycle. In particular I need to see the data such as "Previous assignee resource id" or…
-
'The page has no content' error messageSummary: Hi All, We have a reports dashboard that is generated by clicking on a custom tile as per the below screenshot. For new users (sometimes even for repeat users),…
-
-
worker detailSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Date when an applicants enter in a specific state of the applicationSummary: Content (please ensure you mask any confidential information): Hello experts, we are creating an OTBI analysis and we would like to know if it is possible to re…
-
Better alternative for not like operatorSummary: Better alternative for not like operator Content (please ensure you mask any confidential information): Hello , I am trying to exclude certain checklist names f…
-
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co… -
Only the latest active assignment details are extracted in Person Profile Real timeSummary: A worker having multiple active assignments, only the latest active assignment details are extracted in the below subject area Workforce Profiles – Person Profi…
-
How to send a report to a network folderSummary: Is there a way to schedule a report or Agent to send directly to a network folder? Content (please ensure you mask any confidential information): Version (inclu… -
Subject area related to Work Schedule and Work schedule assignment informationSummary: Subject area related to Work Schedule and Work schedule assignment information Content (required): Please suggest OTBI Subject area related to Work Schedule and…