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
-
Could not able to fetch various seniority dates through OTBISummary Could not able to fetch various seniority dates through OTBIContent Hi Team, We are looking to fetch different seniority dates like VLSR Date, Enterprise Hire Da… -
Ability to report on modified approved future-dated absence entriesSummary: Content (required): Hi - is there a way to report on absences that have been modified by employees ? Example: On 11-Aug-2022, an employee applies for a 2 day ab…
-
How to put the information into one row and limit the duplications?Hi All, I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information …
-
Manage Seniority Dates subject areaSummary Need to know the subject area for reporting the dates in the Manage Seniority Dates action menuContent I'm looking for the subject area that can be used to repor… -
Seniority Dates V3Summary OTBI Subject Areas to Report on Seniority Dates V3Content Does anyone know if the Seniority Dates V3 are available in any OTBI Subject Area? We need to be able t… -
Union for 2 reportsSummary: How can I combine the output of 2 reports into one output Content (required): I have two reports, both using the same 2 Subject Areas (Workforce Management - Wo… -
Usage of BI System RoleSummary: Usage of BI System Role Content (required): Hi Team, We would like to know the usage of BI System Role. Please share your knowledge on the same. Version (includ… -
How to query the organizations in the Organization List of an Organization Security Profile?Summary: How to query the organizations in the Organization List of an Organization Security Profile? Content (required): The Organization List section of the Organizati…
-
OTBI Reports on agents and delivery recipientsSummary: Hi, any reports that can give you the report agents, including the schedule and the list of the recipients (by username or email address)? Thank you! Jenia Cont… -
No option to output format in excel 2007+ .xlsxSummary: Hello! From my online research online (I'm not an MS history expert) - "XLS and XLSX extensions represent popular Excel file formats that were introduced by Mic… -
Looking for a sql query to get the absence plan and corresponding element name associatedSummary: Hi, We have a requirement to get the data of the Absence Plan and corresponding element data using the sql. If anyone has come across such requirement then plea… -
Issue: Unable to find Donation related Entry reason in Absence tableSummary: Unable to find Donation related Entry reason in Absence table Content (required): We can see the Additional Information stored in Adjustement_Reason but when it…
-
Provide access to OTBI report by Area of Responsibility by BUSummary: Content (required): We have a requirement that the user will have only Employee and/or Line Manager Role and they should be able to fetch the employee records i…
-
Unable to get the count in a seeded Dashboard for Absences?Summary: Content (required): In a seeded Line Manager Dashboard ( Shared Folder >> Human Capital Management >> Dashboards >> Line Manager Dashboard ), Under Absences, I'…
-
Sql Query to Fetch the Last Modification Date and Last Modified By Details of SSOSummary: Can any one please help with a sql query to get the last modification date, last modified by, Created by details for SSO configuration. Content (required): Vers… -
Email Address for Implementation Users in FusionSummary: Team, I would like to know the table in which the email address of the implementation users are stored. As they are not tagged to employee record, we will not b…
-
Embed bursting report content in body of email?Summary: Embed bursting report content in body of email? Content (required): Hi all, Hoping someone can advise if it is possible to embed report content within the body … -
How to query if a pending worker to EMP was converted with manual or auto conversion?Summary: Is there a query to determine how a pending worker was converted to EMP (ex: "include in auto conversion" or "quick convert")? Content (required): Is there a qu… -
Need a table or Query to get the IRS Limit values for 401K elements in PayrollSummary Need a table or Query to get the IRS Limit values for 401K elements in PayrollContent Hi Team, Need a table or Query to get the IRS Limit values for 401K element…
-
Turnover- Last 3 monthsSummary: Content (required): trying to add a filter for the last three months but nothing is pulling - I tried several sql expressions and repository variables xml attac…
-
DFF Values Missing from OTBI ReportContent Hi, I had an Analysis report that looked at 2 different DFFs from the Workforce Management - Documents of Record Real Time Area and reported back on the values i…
-
Career Profile Dashboard: Filtering for Performance Tiles and Analysis Not WorkingSummary: We're creating a Career Profile dashboard and would like tiles/drill down analysis to display for employees whose career profile is In progress (1-8 out of 9 se…
-
Drill downs on DashboardSummary: Why does drill down report different numbers to dashboard when its the same report? Content (required): I've created a dashboard report for absence reasons, but… -
How to get SQL query details of BI Report data modelSummary: Hi , We need to identify list of Data models which is using a specific column in BI Report SQL query. We have two option , first is to verify manually all data …
-
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…
-
How to make the shown value of one column depend on the value of another column?Summary: How to make the shown value of one column depend on the value of another column? Content (required): I've made an analysis from the assignment real time subject… -
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, Nivya -
Subject area for a person raceSummary: I need to add team member's race to a report, and I cannot for the life of me find the correct subject area to add! Please help Content (required): Version (inc…
-
How to convert State Code into State name in BI AnalysisSummary Convert state code into description using subject area or table.Content Hi, I am building an analysis to get some information from a Person's payroll run results…
-
Busting OTBI Myths - Using Agents to BurstContent Myth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase comp…Julian Challenger-Oracle 432 views 18 comments 10 points Most recent by Raghavendra Raghunath-Oracle