How to get the Data source behind screens in Fusion

Refer:

http://www.ateam-oracle.com/fusion-saas-finding-the-view-object-you-need-for-data-extracts/

or

https://docs.oracle.com/en/cloud/saas/financials/18c/analyze-and-report.html
->

• Review data lineage

then

-> you will get excel data similar to below:

Search for field names and get the subject area name

Product Area	Subject Area	Presentation Table	Presentation Column	Physical Table
Financials	Payables Payments - Disbursements Real Time	"- Account"	Account Identifier	FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO
Financials	Payables Payments - Disbursements Real Time	"- Account"	Account Identifier	FscmTopModelAM.AccountBIAM.FLEX_BI_Account_VI

go to Data Model> SQL > OBIEE > then choose the relavent subject area in list, then you will get the presentation layer SQL.

Run this presentation layer sql into xmlpserver> admin > issue sql and get the physical sql