Reports
Discussion List
-
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 246 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 29 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 15 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 1 view 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 163 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.5K 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 116 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 431 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 1 view 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…Mark Stoker 113 views 2 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
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 56 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 280 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 183 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 84 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 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
user email ID associated with the user name listed in the licenses usage reportsSummary: Hi, Anyone can help me to get the table and column name for the below screenshot im attaching. actually im working on active user role report, i need this colum…Supraja Sunnapu 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to get full length sentence of a label in bar graph for charts function in RTF Template of BIPSummary: We do have feedback questions and ratings against each question. The goal is to display a bar graph in RTF Template with question vs ratings. How to get full le…Harini Sairam 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to SUM G_1, G_2 and G_3 in DATA_DS summary record for ETEXT template?Summary: we have 3 Records as G_1, G_2 and G_3 and need to show the total number of records in each of them have to be sum and display in DATA_DS in E-text fixed length …Vinay Prasad 25 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need to create a report on the bursting job history detailsHi, We have a job which triggers letter to employees. We need to create a report wo whom and all the letter is triggered from job history. Can you help me with the table…Shanmukhi 14 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to correctly write a BIP query in the OAC environmentSummary: Obtain the value list of launch parameters in a BIP report on the OAC environment Content (please ensure you mask any confidential information): Hi when I write…AM HRE 23 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM