Reports
Discussion List
-
Can we edit fonts on OTBI Analysis Reports?Hi, We are reviewing our OTBI suit and wanted to know whether it is an option to change the font to meet business guidelines - is this a possibility? Thanks! Katie -
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work…Vibha Pandey - Oracle 338 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM -
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Validate employee and Manager hierarchy analysis - How to write?Summary: I am trying to write an analysis in OTBI which would provide an output of Employee and a Managers Level 2,3,4,5 Department. The aim of the analysis is to use as…Scott_Turner_ 35 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th… -
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Reporting in UTC Time Causing IssuesSummary: Hello, We noticed that employees were showing as Terminated in OTBI before the end of the day (11:59pm) of their last day. The UI still shows an employee as Act… -
How to get approved by for Job Requisition ?Summary: I want a query to get approved by in transaction console for job requisitionMartin_Melek 1 view 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…User_2025-01-22-19-28-29-985 97 views 6 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM -
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time…Shant_Sarkissian_WJG 51 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Candidate Risk of Loss and Candidate Impact of Loss field table namesContent HI All, We have a requirement to fetch the succession plan, Candidate Impact Loss and Candidate Risk of Loss details through BIP . I find the "HRM_PLANS " and "H… -
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 324 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
How to know input values supported by any fast formulaContent Hi All, Like we have query to get context supported by fast formula, do we have any similar query or table that can help to fetch input values supported by any f…Avinash 41 views 4 comments 1 point Most recent by Ann Van Roosbroeck Reporting and Analytics for HCM -
Manager not appearing in Termination reportContent Hi, We just recently implemented Oracle Fusion HCM and still trying to work some issues out. One of the issues when I try to pull a termination report that I cre…User_2025-01-23-20-22-05-099 94 views 11 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Signature in the reportSummary We need to store Digital signatures in the Fusion cloud and need to display same signatures in the reports.Content Hi All, Can we store Signatures in the Fusion … -
How to find Notifications setup on a Scheduled Process scheduleSummary: In Scheduled Processes, how you do view/edit Notifications setup on a scheduled report? Content (please ensure you mask any confidential information): Version (… -
OTBI Dashboard-when i click the apply button it not changing the dashbord dataSummary: HI All, I have edtionally added completion date but when i click the apply button it not changing the dashbord data but when i apply the hire date of dates its …AjayKumar Maddipati 32 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
What is the OUTPUT CHARACTER SET can support German umlauts in etext templateSummary: What is the OUTPUT CHARACTER SET can support German umlauts in etext template. Could anyone please provide any information about this. Content (please ensure yo…mohityagyik 84 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
RTF holding on the empty space if the condition is not satisfiedHi, I facing an issue with rtf template where if the condition is not fulfilled it shows blank space and then the next text in the report like below picture Is there som…chpriyanka 244 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
How to Print data in reverse mode through RTF template , Ex: ABCD>>DCBASummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. I found fonts from internet , but those are m…SAKTHI SUNDAR 127 views 4 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for HCM -
Current User/Logged in User Absence Details in OTBISummary Not able to fetch absence details of current user from otbiContent Hello Experts! I'm trying to build a report to get the logged in user/current user absence det… -
User's Roles table to track historySummary User's Roles table to track historyContent Hi All, Can any one please help me out with table name which tracks the history of users and roles details. I want to …nitin Sharma 1.1K views 8 comments 0 points Most recent by Dirk Blaurock Reporting and Analytics for HCM -
OTBI REPORT- ERROR WITH COMPENSATION SALARY REAL TIME DETAILS SUBJECT AREASummary: Hi All, when I try to add the Annualized salary and salary currency to an employee with a changed salary we find the following issue: 1. adding only the annuali…GiovanniD 44 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to develop a report using year-to-date balance dimensions for payroll balancesSummary: We need to be able to generate effective OTBI reports delivering year-to-date information on payroll balances. When looking at Payroll Balance Results in the UI…Len M. 359 views 9 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM -
Oracle Fusion Application - Usage StatisticsSummary Oracle Fusion Application - Usage StatisticsContent Hello, Can anyone please help me to capture usage statistics on Oracle Fusion Applications? I was using one o…SantoshKumarBhairi 140 views 11 comments 1 point Most recent by Shannon_Johnson Reporting and Analytics for HCM
-
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 22 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM