Reports
Discussion List
-
In which table I can find this column "Department" ?I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal empl…Hiba Ghoualmia 211 views 7 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
AOR Areas of Responsibilities in OTBIContent Hi All, Can someone help, which Subject area I can find Assigned Areas of Responsibility details in OTBI? Thanks, VijayUser_2025-02-07-19-03-14-525 1.1K views 11 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.Mayara Fulquim 21 views 1 comment 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 47 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B… -
Mutiple conditions applied at the same time in conditional formatSummary: I am trying to use color code for one column, where two conditions need to apply for the conditional format, meaning that both conditions have to be met at the …JohanneAM 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM Infolet Tab unavailableSummary The HCM Infolet tab is missing from the pageContent Hi, I am having trouble in adding an infolet to the HCM infolet tab. The Service Infolet tab is present but I…Ian Rumble 205 views 14 comments 0 points Most recent by SUBHRASISH KANTHA Reporting and Analytics for HCM -
Created new Measure with conditions incorrect result, Workforce Management - Workforce Assignment RTSummary: Hello all, I have created a new measure - Count of Female Managers - FILTER("Worker Assignment"."Assignment Count" USING ((DESCRIPTOR_IDOF("Workforce Management…Ian.Gooderham 11 views 2 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
List of standards reports and infolets in Oracle HCMHello, Is there a list of standard infolets and reports in Oracle HCM that companies can use please ? Thank youHiba Ghoualmia 289 views 4 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM
-
Conditional Formatting in OTBI AnaylsisSummary Conditional Formatting in OTBI AnaylsisContent Hello, I am using conditional formatting to show when a field is NULL by changing the color of the field box. I ha…Shanna Oppenheim 58 views 7 comments 0 points Most recent by Ivony Ann Paula Salango Reporting and Analytics for HCM -
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 340 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist…AjayKumar Maddipati 51 views 6 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Empty Reports on BIP Result files with DATA_DSSummary DATA_DS file removalContent Hello. I have created a daily BIP report that is sent to an SFTP, however the report is not expected to result in records every day. … -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 72 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Getting inconsistent data from event date fields. Can anyone help explain this or how to fix this?Summary: While creating an analytic for the state activation and completion, by job application, it created multiple lines. To solve this, we have in the past been able …Faraz123 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 51 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Count of development Goals analysisSummary Can't add people with 0 Goals altogether with other Assignment fieldsContent Hi Team, We are trying to build an OTBI analysis that lists Person Name, Person Numb…Alvaro Couto 22 views 3 comments 1 point Most recent by Shawn Gertler Reporting and Analytics for HCM -
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 21 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM
-
Need 2 Date Fields having Case or Filter functionality in OTBI ReportSummary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%') and Final Review Date ("Performance Document"."Performance Docu…Pradnya_Pampatwar 42 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…User_2025-01-29-01-34-30-592 192 views 2 comments 0 points Most recent by Becki Willard Reporting and Analytics for HCM
-
ORC OTBI Report issue when we export from outputSummary: Hi Team, we getting below issue when we ty to export the data. Thanks, ajay Content (please ensure you mask any confidential information): Version (include the …AjayKumar Maddipati 22 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …
-
List of Seeded Reports for Oracle HCM CloudSummary: Hello, Is there a place where Oracle list out all of the seeded reports they provide? Content (required): Version (include the version you are using, if applica…Emily Cox 4.4K views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to calculate Age with Person Date of Birth and Effective Date variableSummary: Calculating Age using Person Date of Birth and the Effective Date variable based on a date entered in the prompt. Content (required): I need to calculate Age us…GJ79 595 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Remove Year from Date in OTBI ReportSummary: I need to set up a scheduled report to go out and not reflect the year of the birth dates. I know how to change the format in the Column Format, but once the re…Jessica D 81 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 11 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio…
-
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun…