Reports
Discussion List
-
Refine ExtractSummary: Hi , I am developing an HCM extract where I need to have 2 parameters in the extract. I have never worked on the refine extract and need input on the same. Than… -
Performance Document Eligibility disappears in the new year/ Where to go for data related questions?Summary: Performance Document Eligibilities are disappearing in previous years. Where can we go to find reasons why the data is disappearing from reports? Content (requi… -
Can you connect Oracle ERP to Repository / Reporting Web Studio?Summary: Client is trying to create an automated data load reconciliation report at hash totals. As the DM cannot extract data at dynamic calc members, we are looking in…Ryan Heyvaert 21 views 5 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close -
Getting Invalid URL Error while adding the BI report URL as embeded content in the dashboardSummary: I am trying to add the existing BI report to in the dashboard.Though i ma providing the correct BI Report URL while adding embedded content i am still getting t…minati_behera-Oracle 11 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM
-
Need to compare 2 columns in an OTBI pivot tableSummary: I'm wanting to find out if this requirement is possible within OTBI. I have 2 dollar amounts 1 for each date paid. I need to compare the 2 amounts and look for … -
How can I exctract Person Address ID field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Address ID field to overwrite employee home addresses by HDL. Is it possible to find this f…Valerio Curzi 31 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Wrap text issue in RTF templateSummary: Content (required): As per the client requirement, I am creating a BIP report. The output of this report should be available both in excel and PDF formats. So I…Prajna Hegde 1.3K views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
Which is better: "Filters and Variables" vs "Results of another analysis"Summary: Are hidden dashboard prompts better than getting the results of another analysis? Content (required): When building dashboards, we occasionally have a need for …
-
How do I manage, see, & edit existing scheduled BI Reports I set to run monthlySummary: I have 5 BI Reports that I've scheduled to run every month. I used to be able to see/edit the list of my scheduled reports in the "Report Jobs" link in the left…Jocelyn Layos 189 views 10 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for ERP
-
How to maintain a single drop-down option(page dimension) for multiple grids in HFR?Summary: We have created a HFR report with three grids. Each grid has the same dimension in page POV with same range. Is there any option which will allow us to have a s…
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 22.02What’s New in EPM Cloud Narrative Reporting and Reports Release 22.02 Please refer to the February 2022 What's New Guide to understand the new features included in EPM C…Dave Roberts_-Oracle 21 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting -
Reporting Name at Manage Department PageSummary: We are looking for Query to fetch Reporting Name at Manage Department Page,as marked in screesnhot below Content (required): Version (include the version you ar…Priyanka More-Oracle 191 views 2 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Employee Referral ReportSummary Looking for an employee referral report that will run on a condition that current date is 6 months after hire dateContent We have a DFF that tells us if someone …User_2025-01-28-20-43-56-568 119 views 6 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM -
Smartlist Members are showing junk values on parent level in reporting cubeSummary: Smartlist members showing Junk values at Parent level in Reporting cube. Looking for a technical solution to curb aggregation of Smartlist members across dimens…
-
Any method to search for a keyword usage in the OTBI Reports or HCM ExtractsSummary: Any method to search for a keyword usage in the OTBI Reports or HCM Extracts Content (required): Hi All, We have the requirement to identify the reports and int…Parag Hiremath 31 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Saved Linked Objects in Management ReportsA question to the community - does anyone know when management reports in Planning Cloud will support adding saved linked objects like we can in FR? We have a customer w…
-
FR Report Que : Display Yeartotal on FR report and allow user to expand only if rqdSummary: We want to develop FR report in excel format such that the report opens at Yeartotal level and then allow the user to expand to month level only if the user wan…
-
How are you managing OTBI AgentsSummary: We have some analysis/dashboards that we want to schedule and send out as specific times using agents. Question is there any best practices around the managemen…amy hardtke 11 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
OTBI Edit Column Formula for YYYYMMDDSummary: Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Manageme…User_2025-02-11-05-19-35-410 533 views 7 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
HCM Extract| Balance ValueSummary: Hi, I need to fetch balance value for dimension YTD. I created the balance group and HCM extract(Followed the attached PDF). But it is not working as expected. …
-
Need Report for Number of times hire-date changed and all hired dates changed(in one field)Content Hello , We need the report of, Number of times hire-date changed and all hired dates changed(in one field). Is it possible in BIP? If yes, pls share me the sampl…Janardhana Kondaveeti 36 views 7 comments 0 points Most recent by User_2025-11-28-00-22-13-803 Reporting and Analytics for HCM -
How to build a HCM extract to generate HDL files.Summary: As per the business requirement, I need to build a HCM extract to generate the CalculationCard.dat file. I need to build an extract which can give me balances y…
-
BIP Report to pull only terminated employeeContent how can we pull only terminated employees who does not have any active record as of sysdate -30 Example: Employee terminated as of yesterday and rehired as of to…Kavya Sreenivasulu 175 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Footing errorsContent In FCC financial reports there is option to set rounding. The problem is that after rounding, sum of accounts balances is different than parent value which inclu…User_YZ4FW 118 views 4 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…
-
Time Stamp Diff based on User Entered Date ValueSummary: Time Stamp Difference function calculating with user prompted date value Content (required): I am using the following function to calculate years of service. I'…Jennifer Wiggs 41 views 8 comments 0 points Most recent by Jennifer Wiggs Reporting and Analytics for HCM
-
Extract should have two Parameters 1. Expense End Date 2. Payroll NameSummary: Need input on how to add parameters in HCM extract. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Arti P 1 view 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM