Oracle Transactional Business Intelligence

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

Oracle Fusion Budgetary Control Transaction Subject Areas.

Received Response
11
Views
1
Comments
Naaman Yulianto
Naaman Yulianto Rank 1 - Community Starter

Hi,

I use the budgetary control transaction subject area to show a transaction with purchase order transaction type. I want to display the item number of the purchase order transaction but I cannot find the column in the budgetary control transaction, so I want to get the item number from purchase order subject areas. But the item numbers is empty in result tab.

I had read the documentation: https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/combine-subject-areas-analyses.html#GUID-0F9D7DB5-32B3-4D62-951B-6CA45B6BBD56

But still cannot find solution.

I also tried to use the SQL Issued to join the two subject areas, but turns out its nullified the build-in function from the budget control transaction subject areas.

Answers