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

@Agil Please also verify the below documentation about timezones related to data https://docs.oracle.com/middleware/1221/biee/BIESG/configtimezones.htm

@Agil Please navigate to ..\domainhome\config\fmwconfig\biconfig\OBIPS edit instanceconfig.xml using VI editor or use more command or check in winscp and navigate to the location and edit the file with notepad++ and verify <Timezone> tags . Also please confirm the timezone of your database source for which your report is…

@Agil Please login to /analytics,check Right hand side profile icon ,my account ,preferences tab and change the timezone and see if it is fixing the issue. if it is not resolving the issue ,please share more details. Report criteria screenshot and filters applied and timezone of database From oas server ,please check for…

Please you may refer for case when statements usage There are case(if) ,case(switch) statements which you may explore