Reports
Discussion List
-
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 345 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 575 views 5 comments 0 points Most recent by Gokul10 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 33 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in… -
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 225 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 40 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 12 views 2 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
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 21 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
-
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 13 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 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is CRC32 function supported by Oracle fuion BISummary: Is CRC32 function supported by Oracle fuion BI Content (please ensure you mask any confidential information): Version (include the version you are using, if app…Ishtiaque AHmed 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.2K views 11 comments 0 points Most recent by Punam Roy Karmokar-272206 Reporting and Analytics for HCM
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
what is the table that can pull Available absence plan balance.i just want to pull absence plan and balance available for each person in system . Can someone ping me the table name,and is it possible to pull the balance for each abs…
-
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …Anup Karmankar 40 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
sql query to get resignation approval statusSummary: Hello , I need to add column "pending with " in BIP if Resignation is pending for approval with Line Manager then "pending with "column should display "pending …
-
Some of reports when we try to download the report we are getting processing errorSummary: HI Team, Some of reports when we try to download the report we are getting processing error . Export>Data>CSV or Excel Content (please ensure you mask any confi…AjayKumar Maddipati 11 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
SQL query to find the Users that has role provisioned by an role mappingI'm trying to create a query that return the MAPPING_NAME from the PER_ROLE_MAPPINGS table and the USER_ID from the PER_USER_ROLES table to know which USER_ID is associa…Letícia Costa-Oracle 45 views 0 comments 0 points Started by Letícia Costa-Oracle Reporting and Analytics for HCM -
'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'Summary: Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each em…Chelsea H. 9 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 1 view 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM