Category 81
Discussion List
-
Home or Work email address depending on termination statusSummary: Hi I'm building an analysis which contains both current employees and employees who have left within the last 60 days (established using a filter on termination… -
Floater Days not updated with Absence Calendar Details Real TimeHello, I built a report with 'Workforce Management - Absence Calendar Details Real Time' subject area to include Vacations, Floater days; xml attached. I completed Float… -
Fusion analytics report - Oracle pre build columns not yielding correct dataSummary: We are trying to transition the existing OTBI report with subject area — Workforce Management to Fusion Analytics where the column under Fusion analytics - 'Ave…RachitSharma 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BI Publisher RTF Template Error - conditionsHi All, I'm working on an offer letter template where I need to use the below if then statement. It is working as expected by itself. However, I need to use it to replac…Balazs Grajczar 50 views 2 comments 0 points Most recent by Balazs Grajczar Reporting and Analytics for HCM -
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: - …CAMIL_Q 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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. 24AAnita Andrádi 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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): 24AGian Luca Triglia 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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…AshleyT 5 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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…Prashant Prabhakar Fusion 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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 …Ridma Karunanathan 24 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 …Rohan Fernandes 238 views 8 comments 2 points Most recent by Unknown Reporting and Analytics for HCM
-
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…James Leborn 2 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
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…Valerio Curzi 4 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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…Parag Hiremath 75 views 11 comments 0 points Most recent by Chris Carloff Reporting and Analytics for HCM -
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…Sudarshan Uppara 34 views 2 comments 0 points Most recent by Sudarshan Uppara Reporting and Analytics for HCM
-
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 …Shreya Datir 11 views 1 comment 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
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?
-
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…Valerio Curzi 702 views 6 comments 0 points Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM
-
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 …Sachin_Shirke 327 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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…
-
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…Ayesha Iroshani 12 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
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…Manoharan 49 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
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)…THawkins_LGI 76 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Embed OTBI in Requisitions responsive PageSummary: Hi, We are trying to embed an OTBI report that will pull in the Job Code for a particular job requisition into the job requisition page. The attempt was to have…
-
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…
-
Elements - balance feed "as of" date promptSummary: We are using SQL data model to report on various balance feed items for elements. We have hundreds of elements and need to be able to compare configuration as o…Michelle Hughes 11 views 3 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM