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
-
Ability for an employee to run a report from talent profile page with Badge outputSummary: Ability for an employee to run a report from talent profile page with Badge output Content (required): We are in the process of implementing learning module and… -
How to identify the tables updated by transaction in Fusion HCM?Summary: Hi Team, Is there a way we can identify the backend tables affected by a transaction done in application. For example Hiring an employee, in this case how to id… -
Can we report on screening questions responses?Summary: Is there a possibility to report on screening questions in OR? I am not able to find them in the subject area. i.e. the yes or no responses Content (required): …
-
Creating dependent prompt in OTBI analysisSummary Creating dependent prompt in OTBI analysisContent Team, I have created a variabl 1st prompt for "Review Period" with "@{variables.ReviewPeriod}". Now i am trying… -
how to Limit the prompt values based on the result of the analysis?Content I'm creating a validation report in OTBI which contains Employment data of contractors. The requirement is to be able to prompt on Business Unit. I want the list… -
OTBI Prompts-How to restrict the values of other fields based on the values selected in other fieldsSummary: Hello, is it feasible with OTBI prompts to restrict the values of other fields based on the values selected in other fields? Example: AMNS India BU = Department…
-
HCM User Interface to OTBI Subject Area MappingSummary: Hi all, I am always grateful to the invaluable assistance, insight and support of the customer connect community. I have no idea if this will be of use and this…
-
How can I locate the new MCR fields for the Responsive UI?Summary: I am looking for the new fields Role_Identifier and Teacher Reference to add to the Responsive UI, but am not sure how to find them Content (required): Are the … -
Use of MAX function to get current Tax CodeSummary: I need to tweak a repot which shows all the tax codes under one employee with dates against them, however I just need the current tax code that is applied. Cont…
-
Termination Date less than and greater than 3 months of current dateSummary: I'm trying to work out how to write a formula for a Leavers report that will bring back everyone who has left the department in the last 3 months and projected …
-
SQL to extract for every employee the list of content item added on talent profileSummary: Content (required): Hi team, Can you please share an SQL that extracts for every employee the list of objects in Talent profile? It's very important to have Des… -
Reporting transaction history in HCMContent Hi all, We are currently looking for a way to report transaction history specifically for terminations. We've found what were using shows the most recent update …User_2025-02-05-20-24-10-848 64 views 4 comments 0 points Most recent by User_2025-02-11-05-19-35-410
-
OTBI Agent ScheduleSummary: We encountered an issue today with a monthly report that is scheduled to run at 7 AM EST ran and delivered the report at 2 AM. Have anyone encountered this issu…
-
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
Need link for questionnaire template and subscriber for LearnSummary: Hello everyone, I need to find questionnaire template and the subscriber it is linked to. I was able to find 4 tables related to questionnaire and subscriber. I…
-
Most recent status of candidates along with reason of rejection if anySummary: In recruiting, when creating a report with most recent phase and state of a candidate job application along with rejection reason if any, the report generates d…
-
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…
-
Performance Document Eligibility disappears in the new year/ Where to go for data related questions?Summary: Performance Document Eligibilities are disappearing in previous years. Where can we go to find reasons why the data is disappearing from reports? Content (requi… -
Getting Invalid URL Error while adding the BI report URL as embeded content in the dashboardSummary: I am trying to add the existing BI report to in the dashboard.Though i ma providing the correct BI Report URL while adding embedded content i am still getting t…
-
Need to compare 2 columns in an OTBI pivot tableSummary: I'm wanting to find out if this requirement is possible within OTBI. I have 2 dollar amounts 1 for each date paid. I need to compare the 2 amounts and look for … -
How can I exctract Person Address ID field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Address ID field to overwrite employee home addresses by HDL. Is it possible to find this f… -
Wrap text issue in RTF templateSummary: Content (required): As per the client requirement, I am creating a BIP report. The output of this report should be available both in excel and PDF formats. So I…
-
Which is better: "Filters and Variables" vs "Results of another analysis"Summary: Are hidden dashboard prompts better than getting the results of another analysis? Content (required): When building dashboards, we occasionally have a need for …
-
OTBI usage dashboardSummary: Identifying OTBI usage for performance monitoring Content (required): Is there a seeded OTBI Usage Dashboard? Have seen below post and wondering if Oracle alrea…
-
How to read the info from the Calendar?Summary How to read the info from the Calendar?Content Hello, do you have any query that is able to read from the Calendar under Work Schedule Assignment? Many thanks to…
-
Reporting Name at Manage Department PageSummary: We are looking for Query to fetch Reporting Name at Manage Department Page,as marked in screesnhot below Content (required): Version (include the version you ar…
-
Employee Referral ReportSummary Looking for an employee referral report that will run on a condition that current date is 6 months after hire dateContent We have a DFF that tells us if someone …
-
Any method to search for a keyword usage in the OTBI Reports or HCM ExtractsSummary: Any method to search for a keyword usage in the OTBI Reports or HCM Extracts Content (required): Hi All, We have the requirement to identify the reports and int… -
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Change type of font in RTF templateSummary: Formatted text within an RTF template authored in Microsoft Word does not persist when rendering using Oracle Analytics Publisher Desktop Content (required): Th…