Reports
Discussion List
-
Display Person Images on BI ReportContent Hi All, Do you know how to display Employee's image on the BI Report? Images are stored as BLOB files, then how can we display them? Read on to know more details…Sricharan Monigari 106 views 10 comments 3 points Most recent by User_4H1FC Reporting and Analytics for HCM -
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Download PDF DashboardsSummary: Download PDF Dashboards Content (please ensure you mask any confidential information): Hello experts, we would like to download a dashboard as pdf but it seems … -
Show Only Maximum Current Year Enrollment Coverage Start DateSummary: I have an OTBI Benefits report that should show only current year max enrollment coverage start date . The Enrollment Coverage Start Date field has the below co…JHaden3 32 views 4 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Create an Effective Date Parameter for OTBI ReportSummary: Hi. I am sorry if this question has been asked before. I am looking to add a Effective Date Parameter to an OTBI report so when the user goes to run the report,…Jose Guerra 2K views 20 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match…Priyabrata Prusty 625 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
I Combined two subject areas but two records coming with active status but only one activeSummary: Hi Team, We have Combined two Subject Areas but assignemnt status showing as active with two records both are active but diffrence is one is with termination da…AjayKumar Maddipati 41 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BI Output file name along with current dateContent Hi, Can someone help me how to add date in the output file name of BI report while downloading directly from BI catalog? ex: Employee Detailed Report_yyyymmdd.xl…Nivya Mathire 547 views 8 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
DFF - Character limitContent We currently have a flex field with a character limit of 160, it is proposed that this is increased to 1500. Will it be possible to still report in an OTBI analy…
-
Dashboard Prompt Not Working on Logical SQL AnalysisSummary Dashboard Prompt Not Working on Logical SQL AnalysisContent Hi experts, - I have created a report using Logical SQL. Please see attached. - I created a dashboard…Raymund Jerome 203 views 18 comments 0 points Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM
-
Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWVSummary: Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWV Content (required): Exceeded Configured Maximum Number Of Allowed Output Promp…Swati U 478 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What parameters to pass when scheduling TimecardApprovalNotificationBulkReport to get XML fileSummary: Hi experts, We have a requirement to get the XML file from a seeded report - TimecardApprovalNotificationBulkReport. However, when scheduling the report, there'…
-
Is there a table which holds the certificate information within the security consoleSummary: Is there a table which holds the certificate information within the security console for users. I need to see what certificates employees have associated with t…
-
Invalid parameters requested.Summary Invalid parameters requested.Content Hi, Im getting an error "Invalid parameters requested." for one of the values in the LOV which is based on SQL query. Can yo…Damodar Peddakotla 781 views 3 comments 0 points Most recent by User_J7ULB Reporting and Analytics for HCM
-
Headcount is not being populated in Work Measure tableSummary Some employees have rows for HEAD others don'tContent Hi There, Does anyone know why HEAD information is populating for some employees but it is not for others? … -
Connection time out while scheduling BIP reports post 24C upgradeHi All, We are getting Connection timeout issue while scheduling BIP reports. This is something we are experiencing post 24C upgrade. Does this has anything to do with N…Satyabrata Nanda 66 views 2 comments 3 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
PER_POSITION_BUDGETS is showing no data. Need Position Budget FTE for custom report.Summary: We need to add Position Budget FTE in a custom report but PER_POSITION_BUDGETS has no data. Do I need to add any role for this table to do we get this informati…Punnya Vijayan 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
we joined two subject areas but when we apply single country it is woking fine but multiple not workSummary: Hi All, we joined two subject areas but when we apply single country it is woking fine but multiple not working. stlll searching mode ? subject area: workforce …AjayKumar Maddipati 22 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 45 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch attachments from OTBISummary: Hi Expert, Currently, I'm using "Recruiting - Recruiting Real Time" & "Recruiting - Recruiting Event Real Time" Analysis and want to see the attached file in my…Saher 135 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Issue with extract for termination detailsSummary: We are using this extract from couple of months back . It is working for all other employees. Only 2 employees facing issue with termination details , we could …Vishnupriya 33 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Query to fetch 'Report Job Histories' data from 'Manage Job History'Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…jahanavi metta 66 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Manage Enterprise HCM InformationSummary: Hello everyone, I have a report about Manage Enterprise HCM information. Can anyone advise on how to pull the corresponding columns? You can find them by naviga…Chris Carloff 43 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Help with "Guide me" ReportSummary: Hello, I am building a report that fetches information about Grade Ladder, Grade Name, Step Name, and Value. The query itself is not an issue. However, I need t…Matheus Roberto 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to fetch Resignation/Termination withdrawn after last working dateSummary: Hi, There is a requirement to pull all the employees who has withdrawn the resignation/terminations after the last working day need to include pending for appro…Aruna Aounti -Oracle 3 views 0 comments 0 points Started by Aruna Aounti -Oracle Reporting and Analytics for HCM
-
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
Need a report with following fields employee name,# of reportees, # of “reporting levels”Summary Need a report with following fields employee name,# of reportees, # of “reporting levels”User_2025-02-07-09-10-02-492 15 views 11 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Manage Administrator Profile Values - Is there a Report for this?Summary Get list of all Enabled Profile Values - Manage Administrator Profile ValuesContent Hi All Could any of you have a Report for the Administrator Profile Values? W…Mansur Khalil 187 views 8 comments 1 point Most recent by Natwar Singh Rajawat Reporting and Analytics for HCM