Reports
Discussion List
-
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 94 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
The 'termination category' stopped working in OTBI in 24ASummary: The 'termination category' field in the 'workforce management - work relationship real time' subject has stopped working for me in OTBI. I created a report in m… -
Chetana Pawar 121 views 4 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
Context sensitive DFF in LookupSummary: Actually i have done all the setup and Before i'm able to see the DFF value in lookup. My system got cloned from Prod. After performing all the steps as before …
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide…BeachDreamer 11 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…
-
OTBI report to be accessed by differing security profilesWe have a dashboard which needs to be accessed by Line Manager, HR and Individuals. Is this possible to segregate this access in OTBI or will we need to create multiple …Clare Murtagh 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report filter is not working in OTBISummary: Hi we need filter the two departments so When we applied the filter on department is not equal to two department names or dostnot contain also its not working. …AjayKumar Maddipati 12 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
What are all the Privilege required to run the Standard ESS job of the Leasing moduleWhat are all the Privilege required to run the Standard ESS job of the Leasing module Ex: Lease Reports 1.Lease Liability/ Analysis Report 2.Lease Transactions and Balan…
-
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 21 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
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 31 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 51 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 445 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 -
Trigger Running Reports through the APIHello, I would like to trigger the running of Reports (new style Financial Reports) through the API in PBCS and FCCS. There seems to be nothing available, the closest I … -
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 366 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM
-
Is anyone experiencing an issue with attaching the Lease Details Report to a lease?Our accountants have a Lease Accountant role and when they try and run the process to attach the Lease Details Report, they receive the following: The lease detail repor…
-
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_ 31 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM -
System Report in EPCMSummary: Need information on how to create the System report in Enterprise PCM Content (required): I am trying to create a System report (Rule Details) in the EPCM envir…Rajen Patil 61 views 3 comments 0 points Most recent by Bhavani Gajula Profitability and Cost Management
-
{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
-
How to present both actual and rounded value in NRCS reports?Hi, We are replicating Peoplesoft reports in NRCS. In the original reports excel files, we can see values rounded off to no decimal points and when we select any cell, w…Guntuka VenkataKrishna 41 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Creating Bursting of Reports from FCC Reports to Application InboxHi Team, We are trying to burst reports from FCC Reports to FCC application inbox. Is there any way we can burst in inbox? As Currently bursting is possible to only Libr…Tejas Vaidya 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close