Reports
Discussion List
-
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 31 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 11 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 31 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 553 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 26 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 1 view 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. 31 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 15 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 22 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 -
Concatenate Supporting Details and Account AliasSummary: Concatenate Supporting Details and Account Alias into the same cell Content (please ensure you mask any confidential information): I'm looking to concatenate Su… -
Hierarchical Prompt for dep tree with OTBISummary: Hierarchical Prompt for dep tree with OTBI Content (please ensure you mask any confidential information): Hello experts, we have configured in OTBI a report wit… -
Guidance for copying seeded report for customizationSummary: As someone new to OTBI, I'm hoping to copy a seeded report (Payables Trials Balance Report) to run for specific vendors. I've copied the report, but don't know … -
Customize Tab names for reports downloaded using "Print All" optionIs there a way to control/configure tab names for the excel reports downloaded using "Print All" option. As of now, it is displaying report name and 3 characters of the … -
Read excel file with querySummary: Content (please ensure you mask any confidential information): In a datamodel I have a query dataset linked with an excel dataset: The excel is used to translat…Stefano_Mazzocca 92 views 19 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Inputs Needed for BIP Folder Setup.Summary: Inputs Needed for BIP Folder Setup. Content (please ensure you mask any confidential information): By mistake, we removed My Folders in the lower environment. W… -
In reports and analytics, from which table I can get engineering change order approver's name?Trying to get this info to build a report for the customer. Table EGO_CHANGE_ACTIONS_B is supposed to show the change events, but independently of the event, it always g…Alberto Redondo 22 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…Venkatesan 42 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Has anyone created a costing by job report using the Payroll Run Costing Real TIme subject area?I need a report to show costing by job for last year. I've written one but can only get it to work for one person at a time, it does not produce results when I try to ru…