Reports
Discussion List
-
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 551 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 21 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 11 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 21 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 …JamesNau_OH 23 views 2 comments 0 points Most recent by NaveenGM_CCC Reporting and Analytics for ERP
-
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 91 views 19 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 87 views 15 comments 0 points Most recent by Balwinder Singh 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 21 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…
-
FCC demo application for client demoDo we have Demo FCC application for a client demo. I imported snapshot form one of the Oracle tutorials link, but it does not have good demo ready data, inserting data t…HarryEPMUser 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
Highlight static variables used in word docletIs there a way to highlight static variables that are used in the word doclet. The user wants to see where are those static variables embeded in the word doclet. I am us…
-
Changed account type as Expense but still at closing balance I am getting data as Closing+OpeningI have changed the account type from Asset to Expense Account Type. How can I get the current year movement data on Closing balance without opening balance addition?KIRTI SETH 31 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.5K views 31 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 421 views 17 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Audit log showing Application administration activity for a standard userSummary: Every month we send a copy of the audit log to the finance team for review and discussion - we also supply them with a script to annotate the log (so its easier…Jeremy Stubbs 31 views 5 comments 0 points Most recent by Alyssa Longo Financial Consolidation and Close