Register to the Data Intelligence Summit Mexico City Register today to the Oracle Analytics Data Intelligence Summit in Mexico City on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

This worked. Thanks

in Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances? Comment by Lynda G November 2024
Hi @Nathan CCC Re point 2. Thanks for this. It appears we have never run the BI Extender job and now that I have run it in TEST I am able to separate out the segments I need from the subject area General Ledger - Transactional Balances Real Time. I will play around with the other subject areas as I think this will work.…

in Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances? Comment by Lynda G November 2024
@Nathan CCC - thanks for your response. The issue with building a report from a subject area is that you are limited to 1 subject area. I have tried this but unable to get the segments into separate columns as I only want the report to show 5 of the segments but the subject area displays all segments as concatenated. I…

in Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances? Comment by Lynda G November 2024
@Darwin HP - Thanks, I will try this.

in Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances? Comment by Lynda G November 2024