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
-
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti… -
person flexfieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
BIP - Completed Learnings ReportSummary: Hello, Has anyone tried creating a BIP report that contains all of a learner's completed learnings at a course level? (Completed, Bypass Completed) Below are th…
-
-
Need to know tables used for storing geographies for use in BI publisher reportSummary: Can someone help me with names of tables that internally store all geography hierarchy information in HCM. I need to use this in my BI publisher report to extra…
-
How can I set the default of a date parameter to the same date in the prior year in Bi Publisher?Summary: Due to leap year, {$SYSDATE()-365$} is no longer working correctly to set the default for a date parameter to the same date in the previous year. Content (pleas… -
Candidate is incorrectly transferred to HR moved to previous phaseWe have an HR report under tools>reports and analytics report name: New Hire and Pending Starts Report - ExternalsNew Hire This report calculates candidates that have be…
-
While scheduling a OTBI report, run time parameters are not coming up in General TabSummary While scheduling a OTBI report, run time parameters are not coming up in General TabContent Hi Team, When i tried to schedule a report using OTBI, there are run …
-
Table containing Attestation details for Activities - Oracle BI PublisherSummary: Need to know which tables store the Attestation details for the Learning module, which is available in the Activities section page. Content (please ensure you m…
-
Query for Role – AOR Mapping ReportHi All, We need a query for "Role – AOR Mapping Report". Can someone help to provide the query of this if anyone has already gone through this type of requirement? The f…
-
Primary Beneficiary DetailsSummary: I need to create an OTBI analysis for to get details about one benefit plan including primary beneficiary details. I used the Benefit- Enrollment Real time subj…
-
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …
-
is there an easy way to extract all the data from a specific table?Summary: Sorry in advance if this has been asked but I have not been able to find a resource to help me. I am looking for an easy way to extract all the data from a spec… -
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t… -
Termination report pulling last compensation of hourly associates but not salaried associatesSummary: Term report pulling last salary of hourly associates but not salaried associates Content (please ensure you mask any confidential information): Hi! I am in need… -
Payroll Results with Details NeededDoes anyone have a query or XLM for a payroll results report that provides the hours and amount by pay element along with the specific pay rate for each element? We are …
-
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
Diversity Report - multiple linesSummary How to report on the latest entry?Content Hi, The report attached works for me apart from 8 employees that are appearing with multiple lines of data. I've spoken… -
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…
-
Null row is occurring in OTBI because of Case statementI am facing some strange issue where null row is getting when i had use case statement one of the attribute as we have multiple phone types and for one of the employee h…
-
BIP report with Excel template output file showing wrong time when compared the value in Data modelHi Al, I am working on a conversion BIP report where I am printing Start Time, End Time in the output file. when I loaded the XML and inserted the fields into the Excel … -
Moved: Compensation Change statementsThis discussion has been moved.
-
Moved: bulk release of compensation change statementsThis discussion has been moved.
-
How/where can I get a glossary/dictionary of language pack translations for all UI text?Hi We are in process of implementing HCM & Learning cloud for 5 countries in Europe. As part of the implementation, we have a couple of custom reports (BIP) to be genera…
-
From which table can I obtain the Manager Overall Rating field?Hi, I want to add the Manager Overall Rating field to a report. Can I do this with SQL? In which table do I find this field? In OTBI, I can achieve this by using the Wor… -
Can’t design the RTF file in Arabic layout when the report exceed 64 fieldwhen the report extracted from system the layout starts from the middle of the excel sheet and technical advised that he can’t design the RTF file to start from the (Cel…
-
Is there way to publish OTBI Reports to Third party RSS FeedsSummary: We are planning to display OTBI reports in ScreenCloud RSS Content (please ensure you mask any confidential information): Is there any way to display OTBI Repor…
-
HCM Table To Fetch BCC Details From Report Job HistorySummary: Need HCM table to fetch BCC details from report job history Content (please ensure you mask any confidential information): Version (include the version you are …
-
Query to find the email recipients of the scheduled BI ReportsSummary: Hi, Is there any Query to find the recipients of the BI Scheduled Report using Job. If I knew the Report name, I can get this details by Jobs History -> Edit . …
-
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIA