Reports
Discussion List
-
Superscript “(d)” Rendering Incorrectly as “#d#” in Narrative Report Text Cells (in PDF format)Summary: An issue occurs in a Narrative Reporting (NR) report (in pdf format) where entering the superscript “(d)” in a text cell displays incorrectly as “#d#”. The form… -
Issues in Prepayment Handling in Custom AP Aging Report (As-of-Date Logic – Oracle Fusion)Summary: Incorrect remaining amount calculation in custom AP Aging Report due to improper handling of multiple prepayment applications (Invoice-Level and Line-Level), in…
-
Wrap text in user prompt headingIn the below example is it possible to wrap text for the second user prompt to see it in one go instead of scrolling it?
-
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i…Mayar Mohamed 6 views 2 comments 0 points Most recent by Mayar Mohamed Reporting and Analytics for ERP
-
Oracle Email Bursting QueriesHi Team,We have a requirement to develop a bursting report that should deliver only a long formatted email body without any attachments. The email body needs to include …
-
How to fetch a comma separated string into separate columns in Oracle fusionSummary: We have a column name - "Approvers" from table - "FA_FUSION_SOAINFRA.WFTASK". When we have multiple approvers for a transaction and those will appear in the "Ap…
-
Output Manager Hierarchy in OTBI with fixed column postionsSummary: Can OTBI output all employees with their manager hierarchy in fixed positions (consistent column data)? Content (please ensure you mask any confidential informa…
-
"View History" section doesn't work when update bank account number through Personal Payment MethodsSummary: Hi, We are developing a BI Publisher report to monitor changes in various system attributes, including the Bank Account Number. Enabling auditing was a necessar…
-
Dynamic Hyperlink/deeplink that is more user friendlySummary: I am looking to insert a dynamic hyperlink/deeplink that is more user friendly. The current URL at the bottom of the email is very long and not user friendly at…Consultant Ian 18 views 4 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name …
-
How Would I Replicate These Infolets/Dashboards for LearningSummary: I am trying to replicate these infolets under the Analytics section of an employee and managers view in MyInfo. What would be the best route to go to achieve th…
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…User_2025-02-12-00-53-03-661 211 views 6 comments 0 points Most recent by lbodeddula Reporting and Analytics for HCM -
Report image only visible in pdf not in wordSummary: Hi all, We noticed that when downloading a custom report in word we cannot see the image/enterprise logo attached. Whereas, when downloading the same report in …Silvia Stangarone CAI 3 views 1 comment 0 points Most recent by SankarBalu Reporting and Analytics for ERP
-
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…User_F89L9 443 views 10 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Book Prompt Member AliasSummary: Hello, I created a Book within Planning that is the combination of two reports in Planning. Both reports have a Prompt for a specific Dimension and both are cur…
-
Recommendation on building a universal reportI need to create a report that will be used primarily as an offline data extraction tool (to free up users’ computers from being busy while these extracts are done via S…
-
Unable to extract System Consolidation Journal reportHi everyone, I have admin rights, but I’m running into an issue where clicking Run Report doesn’t generate the Journal Report, it just keeps loading indefinitely. I’ve r… -
Financial Reporting - Showing children from selected Entity in POVDear Community, our client needs a financial report where he selects an Entity in the POV of the report and then sees the number for all respective children of the selec…
-
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1.3K views 7 comments 1 point Most recent by User_GMBW9 Reporting and Analytics for ERP
-
There is time delay to display requested absence information in the tables.Summary: There is time delay to display requested absence information in the tables ‘ANC_PER_ABS_ENTRIES’ and ‘FND_BPM_TASK_B’, Is there any other tables can be used to …AntonyD 8 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…Chandra MAdasi 31 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
The Program Name is not populating in the ERP Project Costing module.Summary: The Program Name exists upstream but did not flow into the Project Costing module. As a result, costs are missing from the Project Cost by Transaction report. C… -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 21 views 2 comments 0 points Most recent by Laraine Cunningham Reporting and Analytics for HCM
-
Cash Flow Roll Forward with YTD LoadsSummary: The client wants to load year-to-date (YTD) trial balance only in quarter-end months (Mar/Jun/Sep/Dec). They also plan to provide a movement-level split of the …Saraiya Daisy Dhanesh 16 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…User_2025-02-11-06-12-35-024 901 views 12 comments 0 points Most recent by SurendraPB Reporting and Analytics for ERP
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…
-
Create Report from Tags and Experience sections in ConnectionsSummary: Content (required): Hello Experts, Is it possible to create a custom report for the fields in the Connections, more specifically for Tags, Experiences, Interest… -
Job Requisition Approval Workflow Template – Approval Comments Not VisibleSummary: Hi Oracle Community, I am working on the seeded Job Requisition Approval Workflow Notification Template in Oracle Fusion HCM and have run into an issue with app… -
Dynamically update formulaIf I am using a formula in a column referencing Row 1. For example in Column B i am using [1]/100. Now row 1 is enabled for zoom, so i want when it is zoomed the corresp…
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …