Reports
Discussion List
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 22.12What’s New in EPM Cloud Narrative Reporting and Reports Release 22.12 Please refer to the December 2022 What's New Guide to understand the new features included in EPM C…Dave Roberts_-Oracle 31 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting -
Add 2 Report Measures: Dept Active FTE and Vacancy Rate %Summary: I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept… -
Is there a limit to the number of columns in a data modelHello, I’m attempting to create a report using a SQL based data model. It has about 90 columns but when I run the report it leaves off the last 2 columns. Is there a lim… -
Non-Aggregating Statistical Accounts and Weighted Average in Sparse DimsOk Team... We have a variety of Workforce statistical accounts that we want to report out of an ASO Cube (we technically push the data from WF to FS, then report out of …
-
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have …AjayKumar Maddipati 31 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …Brian Todd-Oracle 983 views 2 comments 0 points Most recent by Suhitha K-Oracle Reporting and Analytics for HCM
-
Need to Restrict Employees of a Tax Reporting Unit(TRU) in ExtractSummary: We need to copy a seeded report, Run Third-Party Periodic Tax Filing Extract, and add an object group that will allow us to run the report for specific TRUs (we… -
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 171 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…AjayKumar Maddipati 51 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
GL Value set DFF's are not available in SmartView/ FRSSummary: GL Value set DFF's are not available in SmartView/ FRS. Please let me know is this standard functionality. My client want to track this. Let me know we have ano…User_2025-02-12-18-40-30-943 92 views 2 comments 0 points Most recent by User_GRG5N Reporting and Analytics for ERP -
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N…Aloka Bhattacharya 55 views 6 comments 0 points Most recent by Shampi Reporting and Analytics for HCM -
Secured List View - How it works in a BIP ReportSummary: Hello, Is there any documentation or white paper on how secured list view works in a BIP report? Content (required) We used secured list view in our BIP query t…Hazel De Castro 661 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
which subject area we get father/husband names in OTBISummary: Hi Team, we need data employees of father and husband names so could please assitance on. Content (required): Version (include the version you are using, if app…AjayKumar Maddipati 42 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 41 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
How do I run a report on average age of employees?Summary: I need to run a quick report on the average age of employees in the whole organisation and per Legal Employer. Content (required): I have the report with employ…User_2025-03-10-21-26-28-299 32 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Future Dated HiresSummary I need a report from the OBI that will give me a list of employees that have been boarded in Fusion, but haven't started yet.Content I've attempted to load the t…User_2025-01-23-22-36-14-742 155 views 11 comments 0 points Most recent by Matty S Reporting and Analytics for HCM
-
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Is there onboarding form edited by Acrobat Pro? required timestamp from pdf editor?Summary: HI all, we are trying to get time date and timezone format in onboarding forms in pdf editor. the example of time zone format is 2022.08.03 09:55:19 -04'00' . A…
-
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 84 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Huge number of Contracts impact on reporting/performanceHello team, We are evaluating options where there will be around half a million contracts created in the system to perform billing from Projects each year. I need pointe…
-
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 21 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 112 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 203 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Project CostingSummary: Project Costing Content (required): We have added our subsidiaries business unit to Project Costing, however, when Create Accounting for Labor Cost is generated…
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be…