Get Started with Redwood for Oracle Cloud HCM Begin Now
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 Report: How to auto scale a graph in percent to 100Hi everyone, I would like to ask if anyone has a similar report where you were able to plot column values as percentages and scale the graph to display 100%. Columns: - … -
Where to find OTBI subject area for Job responsibilityWe're creating a report in OTBI for Model Job Profiles, however we couldn't find "job responsibility" section in the subject areas of OTBI. 24A
-
Report for onboarding buddySummary: In which table can I find the oboarding buddy? I need a query to extract it in a report BI. Version (include the version you are using, if applicable): 24A
-
Is there an option to redact information, including PII data, in Cloud attachments?Summary: We have a requirement to redact information, including but not limited to PII data, in attachments that may be requested by outside sources. Are there any capab…
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…
-
etext issue for multiple child tag printing with master record multiple timesSummary: Hi All, Need your suggestions on how to solve the below requirement: We have a created HCM Extract to deliver data to a third party Benefits provider The XML st…
-
Salary pay rates are incorrect for some employeesSummary: The OTBI report is showing incorrect pay rate data for some employees for HRA EX and Notional Special Allowance components. We cannot identify why this data is …
-
How to wrap text in BIP report with excel outputSummary: Is there a possible way to wrap the text in BIP report? In the current setup, the description in the field is too long to fit within the cell, making it difficu…
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …
-
Is there any table that stores the transaction of the Transfer Direct Reports transaction?Summary: Which table stores the transaction or transaction history of the Transfer Direct Reports transaction in Fusion? Need to pull the one who initiated or do the Tra…
-
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do … -
Oracle BI tables to retrieve individual compensation plan nameSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom report. Do you know the BI table to retrieve Individual Com… -
LRU Registration ReportSummary: LRU Registration Report Content (required): Hi Team, Greetings! We have the details for LRU (Legal Reporting Unit) Registration defined under "Manager Legal Rep…
-
How Can We Identify Whether The User Is Logged In Via SSO OR Native LoginHi Team, We have enabled both SSO and Native login for our pod and wanted to know how the users are logging into the system. Is it by SSO or Native login. Please suggest…
-
In what table can I find Box_Assignment Column from Talent Review?Summary: In the Oracle Fusion Cloud HCM Talent Review module, wherein the Tables and Views for HCM can I find the value for the Box Assignment? Content (please ensure yo…
-
XML-2200 Error while parsing XSL fileHello everyone, I would like to ask if anyone has experience this error in BIP Reporting? The issue was encountered after migrating the report to another environment. Th…
-
Are there any out of the box reports that would tell me if a Second Pass email was triggeredSummary: Looking for an out of the box report that would tell me if Second pass emails are being sent to applicants. Content (please ensure you mask any confidential inf…
-
Bar graph using BIP reportI have a bar graph in my BIP report , but the values are coming in decimal. In the Data model it is coming without decimal. Is it possible to have the values display on …
-
HR Dashboard - Length of Service Diversity - What date is used?For the Headcount tab in the HR Dashboard, what date is being used and where is this information pulling from?
-
Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleSummary Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleContent Getting below error while accessing Recruiting - Recruiting Real-Time… -
Is it possible to track who changed user roles and when it happened in Security Console?Summary: Content (required): Hello experts, is there a way by OTBI or SQL to retrieve who changed user roles in security console and when it occured? Thanks in advance f…
-
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 … -
Headcount is Overstated in Pie Charts when using EthnicityHello everyone! I would like to make a pie chart to show the percentage of each of our candidates by ethnicity. The problem is this: When candidates select multiple ethn…
-
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…
-
Benefit analysis with benefit plan decline detailsSummary: I have created an analysis following the steps provided by the below post to get details of a benefit plan if any one declines the benefit enrollment. The analy…
-
Query to Display the Roles with their Data Security Profiles NameContent Hi Team, Has anyone created any report to display the List of Roles along with their assigned Data Security Profiles. Regards, Harish Vummidi Version 21C -
Unable to see data in xml_data_cache column of HRC_txn_data table.Summary Unable to see data in xml_data_cache column of HRC_txn_data table.Content Hi Team, As we know, Data_Cache column is deprecating from 21A and new column xml_data_… -
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…