@User_801US Please confirm the product you are using .Is it obiee ,oracle analytics server?please share the version of product Login to wls console ,left hand side please expand services and click on data sources . example: click on biplatform_datasource ,monitoring tab and testing and test the connection.Please verify for…

@Georgina Sawyer Could you please share more details. Expenses and corporate cards comes under which module Erp,scm ,hcm or cx from fdi product From fusion OTBI analytics ,Is there any sample ootb report .If yes please share the report criteria or please go to advanced tab and share the logical sql to verify the real time…

@SERGIO BARRETO please access fdi oax url ,enable features ,general available features and enable SME Options for Data AugmentationEnable semantic modeling options in Data Augmentation – Dimension, Extend Entity, and Fact.please check if you could be able to see dim ,fact etc.,

@User_PWOBY Please refer documentation on exists operator From the syntax we use exists along with sub query.If sub query returns atleast one row then condition is met and also sub query will be run for every row in outer query's table. when there are tables with huge volume of data there will be performance issues and…

Hi @Subhakara Netala-Oracle ,During concatenation ,As report is failing due to exceeded characters due to varchar2 datatype ,there is one more datatype with clob datatype.Please refer CLOB Data Type section from below documentation.

@User_PWOBY The query is manual query which is executed at db (sql server) and if db supports the exists clause then query will run fine. In oas desktop ,please try use portion of small queries from the whole query and identify which portion of query is causing the issue . As you suspect exists clause ,as part of testing…

@Sanmati Patil-Oracle Please post fusion related queries in below forum for further assistance.

@Sanmati Patil-Oracle please clarify if the queries you are looking for are related to oracle Fusion applications system or Fusion analytics warehouse/Fusion data intelligence product ?

@User_PWOBY Please clarify the database for which the query is sourced to? in the query Is there a with clause ? please note down the credentials configured to run this manual query at dataset and open sql developer or toad and create a sql developer connection and check if the whole query is executing without any errors?…

Hi @Kirk Li, Could you please use reload data on the dataset created by dataflow and open old workbook ,replace existing dataset and check the issue. Also once try it out in-cognito tab and check the issue of adding new fields . As a workaround ,create a new workbook and copy the viz from old workbook to new workbook for…

@SERGIO BARRETO From otbi analytics , please access bipublisher or append /xmlpserver instead of /analytics and create a bip data model based on the query and in the query please write hz_parties table with where clause filters .Then use this report as a source for faw instance. Use data augmentation to point to bip report…

@Kirk Li Please open the dataset created by dataflow and click on join diagram.Is it having one dataset or multiple datasets .The error indicates there is missing join relationship between datasets.Please verify the joins. From the data flow ,you had created caculated column based on two base columns such as quantity and…

Hi @User_WRABO , you may also please try other options like using filter function for difference and % difference. example: filter(cast("Financials - AP Expense"."Facts - Analytics Currency"."Expense Distribution Amount" AS DOUBLE) USING (CAST("Financials - AP Expense"."Time"."Fiscal Period" AS INTEGER)=CAST("Financials -…

@SERGIO BARRETO From oac dataset ,we are querying direct fusion tables which will not be allowed by otbi analytics.Please check the oracle applications connection and we use otbi analytics url. Otbi analytics has it own rpd datamodel and it will not allow even direct simple query. From otbi real time subject areas which…

@SERGIO BARRETO Please you may try below alternative approaches and see if it works. There is a bank account attribute in ap payments subject area.please check if this data related to bank account helps to some extent. 2.Other alternative options like creating a otbi bip report based on fusion bip tables which holds…

Hi @AM HRE , Suppose you have a table that does not have primary key column to uniquely identify each row ,then we use two columns to bring uniqueness to each row. we can define these two columns as additional keys in physical table of oac semantic modeller And also if you want to join two tables other than primary keys…

Hi @User_B6HPR ,Please check the screenshots below to use last_day ,extract month in the dataset. last_day: output: extract month: output: The datasource for the above test case is ORACLE. As these functions are db functions ,for mssql database you may need to use equivalent functions related to last day and extract…

@Vismay Barot This is faw instance and system settings page is not accessible.This is as per design.please refer below doc id FAW|FDIP|FDI|NSAW: How To Access OAC System Settings? (Doc ID 2915472.1)

@Vismay Barot could you please clarify if you are using faw/fdi instance.From oac dv/ui url of fdi instance ,check for instance name and see if it has oax keyword in it.

@SERGIO BARRETO Please check below documentation and click on See Viewing Your Service Limits, Quotas and Usage For ocpu ,please follow change capacity tab