Description-

Currently We have only below information reg. FDI documentation, we are looking for 1:1 mapping related information

We have only data store information as of now. we don't have an documentation for 1-1 mapping related information - fusion table vs FDI table.

https://docs.oracle.com/en/cloud/saas/analytics/25r1/faiae/data-store.html

Example: if I run "SELECT * FROM fusion.ap_invoices_all" in Oracle Fusion, what would be the equivalent query in FDI?"

The same for all these tables.

-- General Ledger (GL)
GL.GL_CODE_COMBINATIONS GCB
GL.GL_IMPORT_REFERENCES GIR
GL.GL_JE_HEADERS GH
GL.GL_JE_LINES GL
GL.GL_LEDGERS GLL
GL.GL_PERIODS GP

-- AP (Accounts Payable)
AP.AP_AWT_GROUP_TAXES_ALL GT
AP.AP_AWT_GROUPS AG
AP.AP_CHECKS_ALL APC
AP.AP_INVOICE_DISTRIBUTIONS_ALL AID
AP.AP_INVOICE_LINES_ALL AIL
AP.AP_INVOICES_ALL AP
AP.AP_PREPAY_APP_DISTS PDIST
AP.AP_SUPPLIERS
AP.AP_TERMS_TL

-- XLA (Subledger Accounting)
XLA.XLA_AE_HEADERS XHEAD
XLA.XLA_AE_LINES XLAL
XLA.XLA_DISTRIBUTION_LINKS XDL
XLA.XLA_EVENTS XEVNT
XLA.XLA_TRANSACTION_ENTITIES XENTY

-- ZX (Tax)
ZX.ZX_LINES ZL

-- PO (Purchasing)
PO.PO_DISTRIBUTIONS_ALL POD
PO.PO_HEADERS_ALL POH

-- COA (Chart of Accounts)
COA_INFO CIF

-- PA (Projects)
PA.PA_PROJECTS_ALL

-- INV (Inventory)
INV.MTL_SYSTEM_ITEMS_B MTL

-- AR (Accounts Receivable)
AR.AR_ADJUSTMENTS_ALL ADJ
AR.AR_CASH_RECEIPTS_ALL RAC
AR.AR_DISTRIBUTIONS_ALL DIST
AR.AR_PAYMENT_SCHEDULES_ALL APSA
AR.AR_RECEIVABLE_APPLICATIONS_ALL RCAPP
AR.HZ_CUST_ACCOUNTS HZ
AR.RA_CUST_TRX_LINE_GL_DIST_ALL RCD
AR.RA_CUST_TRX_TYPES_ALL RAT
AR.RA_CUSTOMER_TRX_ALL RAC
AR.RA_CUSTOMER_TRX_LINES_ALL RCL