Reports
Discussion List
-
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…Sasidhar_Araja 71 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
Table details for ESS Job Display NameSummary: Hi, Can you please suggest which table holds the ESS Job Display Name? I have tried few tables like: request_history_view, ess_request_property but not able to … -
Requisition Approval E-Mail Report Template changes is not getting reflected in output file.Summary: I have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the la…Palukuri 268 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Identifying active agents across the instanceSummary: Is there a way to view all agents currently active in OTBI across both shared and private folders? We have a report being sent via an agent where the recipients…Michael Molea 22 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to use RTF templates if Client is having Google Docs and sheets instead of MS Office productSummary: Our client is using Google products only like Google Sheets and Google docs and not having MS office products such as MS word or excel. How do we edit the RTFs …
-
Need OTBI Analysis/Logical SQL behind Standard InfoletsSummary Need OTBI Analysis/Logical SQL behind Standard InfoletsContent Dear All, How to get the OTBI Analysis/Logical SQL behind the Standard Infolets Ex:Invoices Home …Siva Kumar-Oracle 55 views 5 comments 0 points Most recent by Manishsrf7 Reporting and Analytics for ERP -
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…Dineshkumar.A-Oracle 3 views 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP
-
FRS search members by description starting with, Ending with, ContainsSummary FRS search members by description starting with, Ending with, ContainsContent Our client doesnot have specific values for each row. Instead they have conditions …saravana maneeian subhramaniun 43 views 2 comments 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Prompts are not currently supported for analysis that combine criteriaSummary: Combined two SA i.e "Projects Billing - Revenue Real Time" + "Project Performance Reporting Real time" and want to have 'Project name' as Prompt Value and it is…SBJ_PPM_1210 72 views 2 comments 0 points Most recent by Tomasz Kaniuk Reporting and Analytics for ERP -
LACLS: Dominican Republic (DO) BIP Reports Libro Diario and Libro Major do not render parametersSummary: The Libro Diario and Libro Major BIP reports in the Latin America Cloud Local Solution (LACLS) for Dominican Republic do not work. Parameters do not render. Con… -
Table for Bursting Output ResultsSummary: Does anyone know what table has the results of an individual bursting output from a scheduled BIP report? From the screenshot above you can see that we have one…Lee Eslick-Huff 142 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?Summary: We have a requirement to get Supplier name in Arabic in Payable Trial Balance report. User don't want to customize the seeded report as they are using same repo…SireeshaJaladi 142 views 8 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
How to pull GL JE data for a rolling last 2 periods or last 60 daysSummary: How to pull GL JE data for a rolling last 2 periods or last 60 days Content (required): How can I pull GL JE data from the GL JE Header and Lines tables, so the… -
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, RamuVadde Ramu 62 views 3 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the …YUTA TOGASHI-Oracle 42 views 3 comments 0 points Most recent by YUTA TOGASHI-Oracle Reporting and Analytics for ERP
-
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…Tawfeeq.Khan 11 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 555 views 16 comments 2 points Most recent by Dahlia Gaggan Reporting and Analytics for ERP -
How to create deep links with parameters for supplier qualification moduleSummary: As a business requirement, we should create custom Overview page in supplier qualification module. we built a analysis on the new page and when we click on resu…
-
How to use the "is based on the results of another analysis" filter operatorSummary: We created two analysis in OTBI and put them in a dashboard. The one report drills to the second report via action links. The second report is using the filter …
-
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…Deepika Jain DJ 92 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there a function/package to retain Hebrew Language source text in BI Report output text using SQLI have a Hebrew text file uploaded in UCM. I pass the file from UCM to the Data Set query. The report output display junk characters and does not retain Hebrew character…
-
Can we select a range of member values in the prompts while running a FRS reportHi Team, We have a requirement to provide prompts for running an FRS report, wherein we can select a range of values, like 'From' and 'To' option while selecting account…Srishti Kedia-Oracle 65 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio…Abhilash K - Deloitte USI 17 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…raban 64 views 4 comments 0 points Most recent by SiddharthDang-Oracle Reporting and Analytics for ERP
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 264 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe…