Reports
Discussion List
-
Is there a timing issue between disclosure report and lease liability report?Summary: We sometimes see lease liability schedule variances between the disclosure report and the lease liability report. These variances seem to later resolve. Is ther… -
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 23 views 4 comments 6 points Most recent by Kathy F. Reporting and Analytics for HCM -
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 55 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Why Relative to Prompt for AccountingPeriod offset by -11 is working fine to get Previous year?Summary: FRS report - Doubt on Relative to Prompt for AccountingPeriod offset by -11 Content (please ensure you mask any confidential information): I am running a report…Mahesh Munagala 1 view 0 comments 0 points Started by Mahesh Munagala Reporting and Analytics for ERP
-
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need…
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 1 view 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
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 …
-
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 1 view 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 16 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 214 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 1 view 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 461 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…
-
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 1 view 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… -
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 11 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 904 views 12 comments 0 points Most recent by SurendraPB Reporting and Analytics for ERP