Reports
Discussion List
-
Count Time Cards Approved by WorkerSummary: Trying to determine how many timecards there are for a worker that make up the Processed Time Cards.Processed Hours from the Workforce Management - Processed Ti…Jason Snipes 23 views 4 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
Using OTBI Analysis, how can we append sysdate (MM-DD-YY) to the filename?Summary: Using OTBI Analysis, how can we append the date (MM-DD-YY) to the filename? Content (please ensure you mask any confidential information): Can we append sysdate…SUSAN SANDIFER 44 views 5 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
How to get the 'Plan Period Start Date' in absence plan balances?I am creating a report that would output each plan's balances by year. But this one sample, for 2023, its calculation started from 2022, it's a bit complex I think. For …notautomni9 360 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Annualized Full Time Salary not in Compensation TablesSummary: Looking for a workaround for CMP_SALARY table not reflecting the actual salary information ()Doc ID 2403581.1) Content (please ensure you mask any confidential … -
Req staffing agent fields in OBISummary There are no equivalent fields to this in OBI so how can I report on this using the new Recruiting universe?Content I was asked to build a report showing our ope…User_2025-01-23-20-17-41-106 61 views 2 comments 0 points Most recent by FuriousSS Reporting and Analytics for HCM -
OTBI scheduling agentsCan we use agents to deliver a url to prompt user to log into the system? We have reports which need to be delivered to recipients with varying AORs. e.g. JML for staff …Clare Murtagh 11 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
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 55 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 96 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 246 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