Category 81
Discussion List
-
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 260 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM -
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar… -
how I can measure application usage in HCMSummary: Now a days i need to verify if my users are using the app, for example if they are creating new depts, they hire new persons or they are be in some feature in s…User_1VTMP 31 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …User_2025-02-04-08-51-08-912 334 views 3 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM -
Report showing enrollments As Of Prompted DateSummary: Requirement is for an OTBI report showing enrollment detail as of a prompted date and plan(s). For example, what employees were enrolled in Voluntary Life as of… -
Beneficiary missing some dataSummary: Hello! I am using subject area Benefits - Enrollment Real Time to pull out primary beneficiaries. I have a record in file that is missing some data. EMP Person …Sarah D 48 views 5 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo…Janardhan ACS-Oracle 36 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Calling an external image in bursting using tokensHi We need to call an external image in the bursting query. by passing token. Please help in achieving this. Regards, ShanmukhiShanmukhi 14 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve … -
OTBI reports new calculated item based on the result of a previous created calculated item?In OTBI reports is it possible to create a new calculated item based on the result of a previous created calculated item?Thomas Machado-Oracle 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Report Job History RetentionSummary: Hi, How far back can we view Report Job History in Oracle Fusion? Is this the right answer? I want to be able to download the reports like in first picture. I h… -
How to extract on BIP the field Coments from Progress Summury Recruiting (HCM)Hi, I need a help to extract on BIP the field Coments from Progress Summury Recruiting. Could someone help me please? I can't find it in any table https://us.v-cdn.net/6…Abner Gantz 35 views 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Oracle recruiting impacts with moving to seniority v3Summary: We are planning to move to seniority v3 from v2 soon, does anybody know the recruiting impacts please? Content (please ensure you mask any confidential informat…Shina Sagoo 39 views 1 comment 0 points Most recent by Tapan Joshi-Oracle Recruiting, Opportunity Marketplace -
Pull a list of custom OTBI and BIP reportsSummary: Hello everyone, Is there a way to pull a list of custom OTBI and BIP reports? Thanks and REgards Content (please ensure you mask any confidential information): … -
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be… -
Documenting the Technical part of Dashboard customizationSummary: Hello, We utilized the Oracle cloud prebuilt dashboards, added custom formulas, new attributes, groups and documented the technical part of custom changes with … -
Is there any way to pull the employees in OTBI having future hire dateSummary: Is there any way to pull the employees in OTBI having future hire date? -
Need formula for anniversary date on 1st of month instead of day of hireSummary: I need to calculate anniversary dates so that they are the first day of the month they fall in instead of the annual hire date. I have got it partway there but … -
Any reports or Dashboards available for Fusion Applications Performance monitoring?Summary: How to Monitor Fusion applications performance? We are using FAs in more than 30 countries and there are many processes/ integrations/ reports scheduled to run …MandeepGupta 58 views 6 comments 2 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM -
Parent manager 2 job tileFrom the Worker Assignment Real Time Subject Area I could get the Parent Manager 2 Name. How do I get the Parent Manager 2 Job Title ?Trupti Khodke 20 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
DOJ from date and to date , DOE from date and to date parameter not working in BIP reportHello , I have create Date of Joining date parameter and Date of Exit parameter, however when user try to select dates and filter records , records are not getting filte… -
How to build a repot to get all action changes on the EMP recordI am using Worker Assignment Event real time subject area, to pull all the actions that happened on the employee record. When I add action and action reason I noticed th…Trupti Khodke 80 views 14 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM -
How do I add the last absence end date from the last 5 occurrences?Summary: I need to report on the last absence end date on the attached report. It is currently filtered by rolling last 52 weeks and number of absences measure of 5. Is …Mark Stoker 36 views 1 comment 0 points Most recent by Fechete Iustin - Support -Oracle Reporting and Analytics for HCM -
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 26 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 26 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM -
In OTBI - the Position Name by Position Code is not historical - is this correct behaviour?Summary: The Position Name Field in the Position Folder in both the Compensation - Salary History Details Real Time and Workforce Management - Worker Assignment Event Re…Robert Craske 47 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get when candidate moved to next step or status - BI TaleoSummary: I have a report request to show list of submissions indicating submission date and date moved to next step or status. This data extract shall show the submissio…SAMSONODU 28 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM -
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 27 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM -
Promotion and Demotions Report not pulling the intended dataSummary: Promotion filter pulls in Job change code change data as well which creates duplicates when actually there was only one promotion. Content (please ensure you ma…Usif Ahmed 25 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM -
Certain Term'd EEs not displaying in Transaction Accuracy Audit ReportSummary: Using the Transaction Accuracy Audit Report from the Powered Reports and Analytics/Human Capital Management/Workforce Administration folder in the Reporting Cat…CGardner01 7 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM