Reports
Discussion List
-
Could not establish connection. java.net.ConnectException: Connection timed outSummary: Could not establish connection. java.net.ConnectException: Connection timed out Content (please ensure you mask any confidential information): We are trying to …Sai Krisna 16 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
In reports and analytics, from which table I can get engineering change order approver's name?Trying to get this info to build a report for the customer. Table EGO_CHANGE_ACTIONS_B is supposed to show the change events, but independently of the event, it always g…Alberto Redondo 8 views 2 comments 0 points Most recent by Alberto Redondo Reporting and Analytics for ERP -
Dynamic Data field on Interactive DashboardSummary: Dynamic Data field on Interactive Dashboard Content (please ensure you mask any confidential information): I am building a dashboard (in online template builder… -
Automatically update report package next yearWhen we create a report package for a year. What is the best approach to keep it dynamic so that it will work for next year too. The report package has management report… -
Gaps between multiple grid in MR reportI have created multiple grids for the table due to encountering limit errors. However, this approach has resulted in large blank spaces appearing between the grids. I ha… -
Formatting not working in In Line Grid Notes in report previewSummary: Formatting not working in In Line Grid Notes in report like bold, italics, font color change etc. when previewing reports in HTML Content (please ensure you mas… -
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '… -
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 120 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
How to Add a Table of Contents (TOC) to a Book in FCCSSummary: I have created a Book in FCCS that consists of multiple books and reports. I would like to include a Table of Contents (TOC) document as part of this book. Whil…Athithya.N 18 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
Bursting is failing is failing and unable to understand why it is failing.Summary: Bursting is failing is failing and unable to understand why it is failing. There is no recent change in dimension members. Is some facing the same issue? Conten…Divya_Masoodi 26 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Read excel file with querySummary: Content (please ensure you mask any confidential information): In a datamodel I have a query dataset linked with an excel dataset: The excel is used to translat…Stefano_Mazzocca 66 views 16 comments 0 points Most recent by UchihaItachi Reporting and Analytics for HCM -
Pay Period End date Retroactive CostingFor reporting on payroll costing, how are people populating pay period start and end date for payroll actions Retroactive Costing, Estimate Costing or Balance adjustment…Sean-B-01 19 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
how to pass dynamically the flow name and instance Id from HCM Extract to SFP FileSummary: In an HCM EXTRACT, We enabled SFTP bursting need to save the file name with flow instance name and flow instance Id dynamically in SFTP server when we ran the e… -
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting… -
Only access seeded reports and subject areas in OTBISummary: Client wants a role to allow them to access seeded reports and OTBI subject areas but not any fusion tasks. Is it possible? Can you please guide us?Amit Dey 14 views 2 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP -
Base-level account under TRCS_CurrentAddtlManualTotal not calculating correct amountHello Everyone, We are observing an issue in Oracle Tax Reporting Cloud Service where we entered amounts into base-level accounts under the "TRCS_CurrentAddtlManualTotal… -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…Ankurzen 389 views 7 comments 0 points Most recent by Ashok Pavithran Reporting and Analytics for ERP -
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 2.1K views 12 comments 0 points Most recent by Lisa Carter Reporting and Analytics for HCM -
how to add 2 different fonts in same sentence in cell in report Grid ?Summary: how to add 2 different fonts in same sentence in cell in report Grid like we do in Excel? Content (please ensure you mask any confidential information): Version… -
Concatenate Supporting Details and Account AliasSummary: Concatenate Supporting Details and Account Alias into the same cell Content (please ensure you mask any confidential information): I'm looking to concatenate Su… -
Using Formulas to Reference a Grid in different Report in narrative reportingSummary: I created a book containing multiple reports. On the cover page/table of contents page, i would like to reference the period (eg. May 2024) for which the book i… -
Unable to perform bursting because the specified POV members are not found in the bursting query.Summary: We are trying to execute a Bursting Definition but we are getting the error message; Unable to perform bursting because the specified POV members are not found … -
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 44 views 7 comments 0 points Most recent by Anil Sangwan Reporting and Analytics for HCM -
Negative number not coming below zero line in Bar ChartSummary: In Bar Chart, customer wants negative number should look as below i.e. below zero line Client Version: Content (please ensure you mask any confidential informat… -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4… -
not able to view future dated hires in my reportSummary: not able to view future dated hires in my report. I added the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='2050-12-31' but still not showing Content (please ensure…Consultant1 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Excel report is not printing the parameter when used with burstingSummary: Excel report is not printing the parameter when used with bursting Content (please ensure you mask any confidential information): Hello All, I have an Excel tem…Pritam Das 24 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Audit Reports History Retention for Work Definitions – How many days?Hi all, I’m trying to understand the retention period for audit reports history, specifically regarding work definitions / records. I know that audit history is not kept…Tiago Duarte 18 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Manage Audit Policies enabled but output shows 'There are no records to display'Summary: We have enabled 'Manage Audit Policies' for Payables >Invoices (attributes also SELECTED and added) last week. 1) However when we run the "Generate Audit Report…Joel Dsilva 691 views 13 comments 1 point Most recent by Donna Curtis Reporting and Analytics for ERP