@User_3JONA , Welcome to the Oracle Analytics Community! Do you need a KFF at all, can you just use a SQL Lexical substitution: Create a Lexical of type “Where” Lexical Name: TOWN_WHERE Flexfield Type: SQL Lexical Type: Where Operand: leave blank Metadata Type: Static Text TOWN = :TOWN_SELECT SELECT TOWN, STRNUM,…

Upvoted!

@User_7AIAG , this is a very good question and there are few options to mitigate this situation. Option 1: Recreate the user and roles in the lower environment After the refresh, you manually re-create the user in the test environment and assign them the Service Administrator role again. This is usually the standard…

@Poo_ja @Frank.Steinjan , Welcome to the Oracle Analytics Community! As per my understanding, BI Publisher’s QR code support cannot embed a logo inside the QR code itself.

@User_BR9YB , Welcome and thanks for your question in the Oracle Analytics Community! It is very important to understand how fusion OTBI security really works OTBI security has two layers (BI Platform access and Data access), and both must pass for the user to access the reporting data. BI Platform access (technical) is…

Here is the format for a deep link URL: Copyhttps://<host name>/faces/deeplink?objType=<objecttype>&action=<action>&objKey=<name1=value1;name2=value2...> The URL contains several parameters and their values. These are some parameters you can use in a deep link URL: Parameter Description object type The identifier of the…

@Alexandra Pickett , Welcome to the Oracle Analytics Community! Looking at the above comments, you are on the correct path. It seems somehow the deeplink URL is not being constructed properly. Here is the example of a deep link URL https://<host…

Here is the screen shot from my env, Hope it helps!

@Ameya_J , Welcome to the Oracle Analytics Community and asking the question in the forum! OTBI does NOT have a Process Monitor style history with retrievable past outputs. But did you explore Report Job history functionality, it will give you Job Name, Report Name, Owner of the Job, Status of Job, Start time, End time. I…

@Alexandria Toothman-Oracle , thanks for coming up with such a great video, very useful for the community. Appreciate all the effort!

@Syed Hassan Tufail-Oracle , As Bhaskar mentioned, it is good to start a new post with as much as details possible in terms of the product version/module/release and difference between data sets etc. Thanks

Also, follow this runbook immediately after P2T: Re-enable OGL Revalidate ODA configuration mapping Re-test OAuth / IDCS trust Validate ODA embedded entry points Smoke-test key ODA intents Spot-check custom OGL guides Reassign roles if missing Hope it helps!

@Mel G , as mentioned above by Bhaskar, it is best to ask the question in the more focused forum dedicated to ODA. But as a general guideline about Oracle Fusion refreshes, if your PROD and DEV environments are on different Fusion quarterly releases (e.g., PROD on 25D, DEV on 26A) then OGL step selectors may break or ODA…

@Rakesh Chhoria-Oracle , Nice one!

@ManikSethi , very impressive, nice going. Keep it up!

@Jaydeep Puranik-Oracle @Abdul R Shaik-Oracle, very impressive, thanks for sharing!

@diego m schenquerman , Welcome to the Oracle Analytics Community! This is a very generic requirement and lots of information is already available. Nice thing about is that it can be done in the Sandbox and then can be published once you are happy with the configuration. Here is the latest oracle doc that has a very nice…

@Srikar Pusuluri , I just confirmed these indeed belong to Inventory and as far as the Consumption Advice Report is concerned, it basically used in the scheduled process. It is used to create consumption advices from consigned inventory-related transactions. When to Use A consumption advice is a periodic summary report of…

@Srikar Pusuluri , Welcome to the Oracle Analytics Community! These reports are located under Shared Folders/Supply Chain Management / Warehouse Operations/ Inventory. Please confirm.

Also, this forum is specifically for the Oracle Analytics, OTBI, BIP, FDI etc in terms of tools and it is okay to ask questions which are more related to the tools/technology etc, you should put the question in the Oracle Customer Connect for the Fusion Product related functionality. For example, in terms of Payables,…