Reports
Discussion List
-
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 322 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 704 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 356 views 9 comments 0 points Most recent by Converse_with_OraEnthu 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 40 views 6 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Balance Feed Usage DetailsWe are conducting a review of all balance feeds and associated elements and element classifications, in a effort to ensure we have all elements mapped to the appropriate…
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 1K views 2 comments 0 points Most recent by Janhavi Kulkarni-Oracle Reporting and Analytics for HCM
-
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
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 22 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 39 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 14 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 (…
-
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 37 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 560 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 30 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 2 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. 33 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 13 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 23 views 4 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP