To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Fusion Service
Discussion List
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…
-
Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi…
-
New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a…
-
Is there a way to compare data models?Summary: We have two custom data models that I suspect may not actually have been customized (but they are in the Custom folder). Is there any way to compare a Custom to…
-
How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …
-
Hi, Can somebody assist how to join external data source into subject area in Oracle Analytics CloudHi, Can somebody assist how to connect to external data source into subject area in Oracle Analytics Cloud - FDI?
-
How to burst BI Publisher reports that use PL/SQL Procedure call?I've used the following PL/SQL code: DECLARE TYPE REFCURSOR IS REF CURSOR; XDO_CURSOR REFCURSOR; L_DATA_CLOB CLOB; BEGIN L_DATA_CLOB := L_DATA_CLOB ||'' ||'SUCCESS' ||''…
-
How to Configure Request Payload for POST Method in BIP DataModelHello Oracle Community, I am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring …
-
How to get same data in two data sets in the same data model without any data model link.We have 2 different data sets in the same data model, and we have a common column in both the data sets but without a link. Can we get same data based on the common colu…
-
How to call a query or data of one particular data model to another data model.We have a requirement to get gross salary details in many BI Reports. We need to know that is there any feasibility to call one data model related data in another data m…
-
Missing HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VIWe don't see HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VI in BICC offering though it is available HCM PVO mapping document. How do we ge…
-
Export Material plan into Excel for all items to review supplies, demands and net inventoryHi there, We are looking for the ability to export the 'Material Plan' view in Fusion into Excel for all items. Issue we are hitting is the 'Material Plan' view does not…
-
FLA to GL tables join to display vendor detailsHi, For an account analysis BIP report, I want to link the FLA table and GL tables to display the vendor details. But I am not able to join Can you assist? Thanks and Re…
-
PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…
-
Need a SQL of employees who are missing costing details on the person/ assignment costing.Employee who are missing costing details
-
Recommended architecture for establishing Print Server in DMZ for Oracle fusionRecommended architecture for establishing Print Server in DMZ for Oracle fusion. Print from Oracle Fusion over the public Internet to an on-premise printer or print serv…
-
Is it possible to add conditions in etext template like when there is no dataSummary: Hi Everyone, We have a requirement not to show ("") double quotes in text output when there is no data returned from the output Can we add conditions in etext l…
-
1Manage version control over OTBI SaaS reportHello. We need to enable version control over OTBI reports in Fusion SaaS. Is there any way to manage version control with Git or another tool? Then, for the reports dev…
-
what is the option to get BIP and OTBI report usage details from Oracle Fusion Reports and AnalyticsWe have lots of custom reports (BIP and OTBI) piled up since years and want to cleaned up un-used reports. We are looking for any audit/usage report which will provide d…
-
COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_valuesHi Guys Does anyone please have a list of what each attribute is in the COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values? Data Source : ApplicationDB_FSCM E.G. C…
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…
-
Actually our dev leads asking for read only access to BI report on Prod instanceActually our dev leads asking for read only access to BI report on Production instance and we need to restrict them to query our salary , compensation, Performance relat…
-
Need to Create a OTBI analysis for Helpdesk reporting on Agents who update the SR severitySummary:How to get the old severity and New severity values updated by a given agent in the report from Help desk subject areas. I do not see this attributes in any subj…
-
Bold letters are not showing in PDF OutputHi , We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, the bold letters in the…
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …
-
Issues in creating hyperlink and passing dynamic input parameter from BI Publisher RTF templateDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…
-
Are there APIs for Fusion Data Intelligence?Summary: The most frequently asked question that I face from customers is 'How do I get my data out of ADW, as I already have a data warehousing strategy?' While during …
-
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…
-
Equivalent Oracle Cloud table columns for the EBS HZ entitiesSummary: Could you please help us to provide the equivalent Oracle Cloud table columns for the below EBS HZ entities? EBS Table Name - Column Name HZ_PARTIES - CUSTOMER_…
-
Oracle Customer Excellence Awards - Nominations are OpenYou’ve done incredible work. Now you deserve the recognition. The Oracle Customer Excellence Awards celebrate the very best of business innovation, showcasing how organi…Elise Hymes - Oracle CX-Oracle 13 views 0 comments 0 points Started by Elise Hymes - Oracle CX-Oracle