thanks for your support, it seems it is working now ... what i only did is adding the schema name in each table i added, such as when add STTM_CUSTOMER admin tool is not taking the schema name with it so i just renamed the tablet to be fcubs.sttm_customer. thanks for your support, Best Regards, Bassam

Dear Gianni, please check below SET VARIABLE QUERY_SRC_CD='Report';SELECT 0 s_0, "FCUBS"."STTM_BRANCH"."ALLOW_CORPORATE_ACCESS" s_1 FROM "FCUBS" ORDER BY 2 ASC NULLS LAST FETCH FIRST 65001 ROWS ONLY State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000.…

Hi Gianni, thanks for your feedback.. I am using the same RPD file and the only thing i change is the user, when using the schema name and password it works perfectly while using the reports the answers are not working. knowing that i can add tables to the RPD while using the reports user but i cant update the rowcount of…

Hi Joel, Yes i am able to connect to reports in sql developers and able to write direct query analysis but can't use the answers features (drag and drop) Best Regards, Bassam

Hi, in /middleware/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPSinstanceconfig.xml under view there are only the following: <Views> <Pivot> <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery> <DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>…

Hi, no i didn't set it up and as i know it uses HTML5 instead of flash , but while loading page it asks to enable flash to load

I uploaded the diagnostic files to the following link, i would highly appreciate checking and advise. http://https://drive.google.com/file/d/11LVE3YOzkdK0WBgXncm69Ir-3qJefxC5/view?usp=sharing

yes already did, checked with IE , firefox and chrome and enables flash.

unset DISPLAY was working for me !!! but now I dont know why it is not working anymore I applied patch 29112070;OBI BUNDLE PATCH 12.2.1.3.190416 still the same, please anyone can advise?

thank you a lot, it is working now, i used my domain email address on 587 and it is working now

Hi, i download the certificate from the below link and followed as mentioned https://blogs.oracle.com/oracleworkflow/configuring-notification-mailer-using-gmails-smtp-and-imap-servers-using-new-cer… but not able to import the certificate, also when i am trying to use smtp port 25 without any security it is giving me :…

Hi Christian, smtp.gmail.com 465 my gmail address my gmail address password SSL/TLS where I enabled access to less secured apps from my gmail and disabled two way verification

you are awesome, thank you a lot, as you mentioned the bug is the same .. i just changed the location of the fonts and all is OK now as mentioned in the bug description: - On OAC environment, font files exist on /bi/app/fmw/oracle_common/internal/fonts directory. But in fact, JavaHost seems to seek the location of…

Oracle Business Intelligence 12.2.1.3.0 ... i found the bugs in the portal but not for this version

thanks for your feedback, OBIEE analysis

My Issue was solved by creating Dashboard Prompt and put BRANCH_CODE='@{BRANCH_CODE_V}{}' . where BRANCH_CODE_V is added inside DASHBOARD PROMPT. hope it will help ..

Thank you, where i should set the variable then can you please advise i tried to search but didn't a clear steps . for the other part what other the DDR you prefer the drag and drop or the analysis simple sql statement? Regards,

worked for me , thank you