Reports
Discussion List
-
Reporting transaction history in HCMContent Hi all, We are currently looking for a way to report transaction history specifically for terminations. We've found what were using shows the most recent update …User_2025-02-05-20-24-10-848 63 views 4 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…Vinay Hardas 271 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to edit annotation in FRS reports?Summary: Content (required): I created an FRS report, I add a column to display annotations. I have to users with the sames access, but only one can modify the annotatio…
-
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 13 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 33 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 192 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 117 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 543 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…JanardhanaKondaveeti 35 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 178 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM