Category 81
Discussion List
-
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 143 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo…
-
Why does Terminated user access not revoked for reportsSummary: Hi, When we assign add User to any reports/report folder under permission, and that User get inactivated, this user access doesn't get revoked automatically. Do…Namrata_20 12 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
query to get the location based country and restrict the country based on the regionSummary: query to get the location based country and restrict the country based on the region Content (please ensure you mask any confidential information): For ex Regio…Sravanthi Kamatham 177 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 22 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d… -
offer approval notification template to include Requistion Approval History, Candidate CV etc.Summary: We have requirement to Include Links to Requisition Approval History, Candidate CV and Interview Feedback within the Offer Approval Notification template. Is it…
-
How can we pull data of all staff employed between a financial year in OTBISummary: Date Range would be - 1 April 2023 - 31st March 2024 Content (please ensure you mask any confidential information): Version (include the version you are using, …
-
OTBI Data as of yesterdaySummary: Hi there, I am trying to use the historical reporting capability of OTBI by inputting the logical SQL prefix of SET VARIABLE PARAM_EFFECTIVE_DATE='xxxx-xx-xx'; …Ruby Hui 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to align Prompt labelsI am trying to align the Date Between Prompt Labels as the ‘Please select dates’ and ‘Between’ labels not aligned at runtime. Prompt created based on Calendar date: the …
-
Incorrect Absence Hours Calculation in OTBI ReportSummary: Somehow the Absence Hours calculation is pulling in an extra 8 hours of PTO into the day. Content (please ensure you mask any confidential information): We have…SeanWesche 12 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Query functions only if "Connect By Prior" added"SELECT DISTINCT hrao.effective_end_date effective_end_date1, hov_inner.status status1, hov_inner.organization_id org_id FROM per_dept_tree_node_v pdt, hr_all_organizati…C R Anil 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …AjayKumar Maddipati 93 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can we restrict managers doing calibration outside of Performance distribution?Summary: We have Performance Distribution added to a Profile rating model. In Calibration, same information is being used to display Bell Curve. Now, as an HR, if I am d… -
Need to pull working days from Published SchedulesSummary: Hi.. we have a report were we need to pull the working days of an employee from published schedules. We need to know which days are working days and which ones …Alejandrina Vidal 27 views 0 comments 0 points Started by Alejandrina Vidal Reporting and Analytics for HCM
-
Default prompt values not workingGood morning, I created a dashboard prompt that filters the values based on a query and works fine but I'm struggling to set the default values. In fact, even if I set "…
-
Report agents are not working post 24B upgradeSummary: We did 24B upgrade on Saturday and several reports scheduled via agents were not delivered after the upgrade. Below are the observations so far; Some reports th…Ridma Karunanathan 32 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Due date not showing up for specific learning items in Workforce Learning - Learning ManagementI'm creating a custom report and I'm able to find all data. However, for some specific records the due date is not populated. I think this has to do with the fact that t…MaartenDIF 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Facing issue in Headcount by department hierarchySummary: My client wants to view the period end active headcount by level 2 and level 3 department hierarchy. I tried to achieve that using the below catalog attached bu…Shreya Datir 12 views 2 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
In OTBI, when I am using Subject Area, how can I generate XML for the dataI am trying to generate the report using OTBI for a particular subject area. What I want is that I should be able to generate XML of the data so that I can use this in B…
-
Change information in the pop-up notes when adding "Record External Learn"Summary: is it possible to update the pop-up notes "Actual Effort in Hours" when adding "Record External Learn" Content (please ensure you mask any confidential informat…Chris0145 22 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'…Nick Dorfner 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use …AjayKumar Maddipati 101 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
GET_VALUE_SET not returning any value in Fast FormulaSummary: Hi, I am using the Value Set of Table type in Absence Accrual Matrix formula but it is not returning any value in Fast Formula though scenario is valid. Expecte…
-
Looking for Last Contacted field for a candidate in Recruitment Module for reporting purposeSummary: Looking for Last Contacted field for a candidate in Recruitment Module for reporting purpose (Hiring à Candidate Search à Details à Key Highlights Content (requ…
-
How to create a link with dynamic user IDSummary: Content (please ensure you mask any confidential information): We have a button inside the Goals page where the manager can give feedbacks to the employee in an… -
CreateException:Index 6 out of bounds for length 6 in BIP reportsSummary: CreateException:Index 6 out of bounds for length 6 when I add 7th RTF template to the report I am getting below error and I am not able to delete extract RTF an…Gorla Shiva 77 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI analysis - Bar graph in OTBI analysis for acquiring the headcount trend for the past years on mSummary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …Shreya Datir 56 views 15 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?Summary: I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manag…Max W 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM