Reports
Discussion List
-
how to get the Annualized salary of terminated employeesSummary: I just need basic details like thePerson number, Name etc of terminated employees with their annual salary. How do I get this in the OTBI report ? Content (plea…Trupti Khodke 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Recruiting Offer > Message Notification OTBI FieldGood Day Experts, Is the 'Message Text' field in recruiting module in fusion available in OTBI Recruiting Real Time subject area? Navigation from fusion is Offer > Actio…
-
Embed BI Publisher report without Fusion HeaderSummary: Hi - I am trying to embed a BI Publisher report into a page for our Learning admin to use but when I embed the report using the link provided within the catalog…
-
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 33 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…Domenico P. 121 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 241 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…Mallikharjun Purilla-Oracle 22 views 2 comments 1 point Most recent by Hello123 Reporting and Analytics for HCM
-
Active department not found in reportHi, We are using the department level to differentiate between departments (divisions, sections, units). We have created a new tree version based on the new requirements…Catherine Abi Samra 14 views 2 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Need to report on Employees work schedules and patternsContent Hello, We need to be able to report on employees work schedules and patterns so we can create a report that looks like a calendar and show the days that employee…
-
Not available Inbound Interface type HCM Extract in oracle fusion hcmSummary: Not available Inbound Interface type HCM Extract in oracle Fusion HCM. We need to read element details and reload through HDL process. Content (please ensure yo…Raju S-Oracle 11 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
Extract Rollback using SOAP serviceSummary: Unable to rollback extract using Flow Action Service Content (please ensure you mask any confidential information): Hi, I am using Flow Action Service With Perf…Shanmugaraja_Karunamoorthy 2 views 0 comments 1 point Started by Shanmugaraja_Karunamoorthy HCM Extract -
Tips, Suggestions of migrating Taleo Reports to ORacle REcruiting CloudSummary: We have taleo reports which we want to create also in oracle recruiting cloud. I Would like to ask what are the possibilities of migrating besides manually crea…
-
BI report: how to differentiate between learning outcomes and prerequisitesHello, is it possible to differentiate between learning outcomes and prerequisites? which table can we use to retrieve learning outcomes and what table for prerequisites…Alessandra T. 4 views 1 comment 0 points Most recent by Elaine Berrick Reporting and Analytics for HCM -
What table that holds actual work schedule of employee ?I want a query that gets the actual work schedule of employee in this screen
-
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…JHaden3 162 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.…Jianzhong Tian 1.4K views 3 comments 7 points Most recent by User_B0AIN Reporting and Analytics for HCM -
Is it possible to report on Number of Positions requested, approved, rejected, pending?Summary: I have a requirement to design a Dashboard designed to track the overall timeline to 'Hire an new employee' from the time the initial position is requested/amen…Antonio Moldovan 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue with Report Changes Not Reflecting After Clicking SaveWe encountered an unexpected behavior with one of our reports. We made some updates to the bursting, clicked the save button, but when we checked the bursting again, the…Michael Angelo Lucena 111 views 4 comments 0 points Most recent by Thri Gaadi Reporting and Analytics for HCM
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 429 views 5 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
my FRS is showing duplicate accounts on reportsSummary: Reports were correct when created but now have this issue of duplicating and categorizing accounts under cost of sales but still appear in the correct category …SaintNick 4 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…PriyaPenugonda-SC 763 views 5 comments 0 points Most recent by Gokul Reporting and Analytics for HCM -
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a… -
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am… -
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 54 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do I report on only the most recent assignment (active or terminated)?Summary I need to build a report of all employees and only want the most recent assignment to appear on my report.Content Hi all, Does anyone know how to report on all t…Matthew Grillo-95429 272 views 11 comments 1 point Most recent by Balhaji Reporting and Analytics for HCM
-
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…Shilpa Varghese 167 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
Primary key PVO legal entity / legal entity registration numberHi, Can I join these 2 tables using the 2 primary keys ? Will my legal entities match the registration number in a report ? Regards, LaurianeLauriane Massin Whitaker 11 views 2 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Getting correct calc_breakdown_id from pay_action_contextsTeam, We have developed one HCM Extract and having balancevalue field. This field gets value from Rule (Fast Formula). We have written the fast formula and calling one v…Manoharan 67 views 0 comments 0 points Started by Manoharan Payroll and Global Payroll Interface (GPI)
-
How to adjust the alignment of the bar graph for charts function in RTF Template of BIPSummary: Hi Team, The goal is to display a bar graph in RTF Template with question vs ratings. How to adjust the alignment of the bar graph for charts function in RTF Te…Harini Sairam 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM