Reports
Discussion List
-
default List of values based on login user in BI ReportSummary: I am trying to Default Division in List of values based on user login, is it possible?? If I login as someone from Operations, I want only Operations Division t…SAI KOMATIREDDY 11 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Do we have any reference to the payroll run in the project tablesSummary: I am looking for payroll run references in project tables such as PJC_EXP_ITEMS_ALL or any other project table. Currently I am not finding any. Can anyone help … -
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 541 views 6 comments 0 points Most recent by Niru - Startek Reporting and Analytics for HCM -
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.1K views 28 comments 2 points Most recent by Veeru S M-Oracle Reporting and Analytics for HCM -
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…
-
Learning Subject Area and Organisation Structure Reporting PerformanceSummary: Hi, we have an issue where trying to filter on Org Structure for Learning reporting results in the reports either timing out or taking 10+ minutes to run for a …Kevin Robertson 1 view 0 comments 0 points Most recent by Kevin Robertson Reporting and Analytics for HCM
-
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 24 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 89 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 2 views 0 comments 0 points Most recent 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 3 views 0 comments 0 points Most recent 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…Pranat Damani 2 views 0 comments 0 points Most recent by Pranat Damani Reporting and Analytics for ERP
-
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 13 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 216 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 2 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 472 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…