Reports
Discussion List
-
Lease Amortization Schedules Extract - How to create an IFRS schedule based on ASC842 schedule?Summary: Our client only has ASC842 schedule enabled and would like to have an IFRS schedule. We would like to utilize Lease Amortization Schedules Extract to create the… -
Display member name instead of alias in causality for exceptionIn the causality for exception use case, currently i am getting the member alias names for the top contributors. I also tried changing the same for the account to point …
-
custom US Cheque Report repositioning when printed to a copierHi, I have built a custom US Cheque Report based upon Oracle's seeded US report. I am having issues after a test payroll is ran and converted to pdf and at that point th…
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…Clifford Trett 346 views 15 comments 4 points Most recent by Namrata_20 Reporting and Analytics for HCM -
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 706 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM -
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g…Consultant Ian 51 views 6 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us…
-
Is there an easy way to pull all the notifications enabled in the systemSummary: Is there an easy way to pull all the notifications enabled in the system. Content (please ensure you mask any confidential information): Is there a way we can p…AnushaGarikipati 24 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
how to send the zip files and PDF files as attachments in the email through the bursting bip reporti have requirement to send the zip files and pdf files as attachments in the mail through Bursting report, is there a way to do this? please let me know
-
How to Review Future Scheduled Lease Liability and Amortization AmountsI would like to ask about the Lease Transactions and Balances Report in Oracle Fusion Lease Accounting. Our understanding is that this report outputs only the amounts fo…
-
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc…Vishal Purohit 38 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
FCCS Reports in Books does not show POV.Summary: Some of the reports are missing in EPM books. debugging more I realize some reports does not show POV in books. Not sure why it is happening to some of them. I …Divya_Masoodi 15 views 1 comment 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…Anup Karmankar 106 views 5 comments 0 points Most recent by Vijayhcm Reporting and Analytics for HCM
-
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 33 views 4 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
Tables with employee cost center, manager, assignment, and job title historySummary: We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables …nmdp-andrew 616 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
REST APIs or SQL Queries to fetch the Fusion SAAS BI Report's list from "/Custom" FolderSummary: We have a requirement to fetch all Data Models & Report from "/Custom" folder in Fusion SAAS. Content (please ensure you mask any confidential information): Loo…Pradeep Kumar-Oracle 96 views 7 comments 0 points Most recent by MarcD-Oracle Transportation Management -
sql query for Alternative Balance for PHPSummary: Need to calculate GL reporting Balance and GL Alternate Balance USD and in PHP. mentioned ACCOUNT_BALANCE query below. Content (please ensure you mask any confi…Rupesh Marrikommadinne 4 views 0 comments 0 points Started by Rupesh Marrikommadinne Financial Consolidation and Close
-
Account Holder field not available in OTBISummary: Account Holder field not available in OTBI Content (please ensure you mask any confidential information): Hi experts, we are creating an OTBI report to retrieve…Oriana L. 61 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
REST APIs or SQL Queries to fetch the Fusion SAAS BI Report's list from "/Custom" FolderSummary: We have a requirement to fetch all Data Models & Report from "/Custom" folder in Fusion SAAS. Content (please ensure you mask any confidential information): Loo…Pradeep Kumar-Oracle 17 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
ASO performance at 32MB cacheSummary: ASO performance at 32MB cache — structural work done EPBCS app with BSO entry → ASO reporting via data maps. Looking for input from anyone running similar scale…
-
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…Mamdouh Ahmed 24 views 4 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP
-
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…Jill Stanton 31 views 8 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP