Reports
Discussion List
-
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 193 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 534 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 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 173 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
-
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
-
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the… -
Pencil icon does not appear on grid containing Note ColumnsSummary: I have a user that cannot enter text into a grid containing Note columns. The pencil/Write functionality is not active for some reason for this user. The user i… -
Account Description is as the code in General Ledger Analysis and error when the columns are addedSummary: Content (required): Trying to build up an analysis report but when extracting the account description it is the same as the account code. But in the value sets …Dian Minshan 41 views 1 comment 0 points Most recent by Dian Minshan Reporting and Analytics for ERP -
Dynamic Wording in Word using Planning and related ToolsSummary: Given I have a statement like so (See Quote) in my Financial Statements in Microsoft Word is it possible to refresh the decreased by $5.6 Million using EPM? Not…
-
Document Number in OTBI Receivables - Transactions Real TimeContent I am building an OTBI report using Receivables - Transactions Real Time, and I'm looking for the column for 'Document Number'. Does anyone know if this column is…Brian Todd-Oracle 32 views 1 comment 0 points Most recent by Robert G Wilkinson Reporting and Analytics for ERP
-
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…Jeff Hare CPA CISA CIA 11 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform…Santhosh Bachu 61 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM