@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,…

@Arnab Das , Welcome to the Oracle Analytics Community! As mentioned above there is a definitely limit in terms of maximum rows as well as there are few ideas already logged to increase it. In terms of the issue reported, it will be best to debug it and understand that there are few options how to triage it. I am going to…

Actually, I have a question about CEAL team, how is it different from Oracle Analytics Product team?

@Archana Singh , Thanks for providing the opportunity to get the answers!

Upvoted!

@Anitha Ramarao-Oracle , very well-organized, thanks for sharing. Appreciate all the effort you have put in this workbook.

Hi @TrevorM , Welcome to the Oracle Analytics Community and asking the question in the forum. OTBI subject areas can only be combined if Oracle has defined conformed dimensions between them. In your case, looks like there is no common dimension in terms of Project Number from Procurement – Purchasing Real Time with…

@User_WJ43I , I am glad to see it worked for you. Appreciate if we can document the changes here, it will definitely help someone in the future. Thanks

Yes, hope it works for you.

@User_WJ43I, sure, let us know how it goes. Also, as per community guidelines, please mark the Answer as Accepted Answer so that it can be easier for community members to find replies that might help them in a similar situation. Thanks

@User_WJ43I , If I understood the question, the underlying issue is that your revenue fact at project level is being joined to task-level hierarchies, and when you join both facts using project_id+task_id, project-level revenue rows don’t have tasks to join, so the outer join fails. For this implementation you can try…

@Doug Ross , @SharonAtGorilla , this forum was last actively looked in July 2024. I would suggest starting a new thread with as much as details possible about your requirement. Thanks

As a workaround, if you don’t need a custom dataset (no joins, transforms, snapshots): Build the workbook directly on the OTBI subject area Let environment-specific OTBI connections handle themselves This avoids the dataset layer entirely and migrations become much cleaner.

@User_WJ43I , In OAC, custom datasets are tightly bound to the data connection they were created with (in your case, the OTBI connection in SIT). When you migrate a workbook: The workbook migrates cleanly The dataset migrates cleanly But the dataset keeps the original OTBI connection ID, not just the name So when the…

@Kamal Raj , Welcome to the Oracle Analytics Community! I do not think this question has anything to do with Oracle Analytics. You might be well served if you can put the question in Oracle Customer Connect. - Welcome to Cloud Customer Connect. Thanks

As per my experience, it is not necessary that if a feature is available in OAC, it will be available in FDI as well. Reason is FDI must stay aligned with Fusion application semantics. Fusion Applications store and process timestamps in application-defined time zones. It already apply time zone logic consistently across:…

@DeepaliG-Oracle , I do not think we can refresh it manually. If it is a static repository variable, it's value is initialized in the Variable dialog. The value of the static repository variable persists and doesn't change until an administrator decides to change it. For example, suppose you want to create an expression to…

@User_D0GY2 , this is where we need to raise SR with Oracle Support by providing all the logs.