is available the option to append or combine tables in FDI?

Question

i would like to have in BIP or FDI the details for each transaction from sources(CST, CMR, AP, FA, AR, INV) with the SLA and GL Detail, but in FDI i cannot see the transaction number to join with the diferent subject areas and in BIP i cannot find something like that. is therer any query or data model or in FDI?

Bhaskar Konar · Answer

Hi @Zeneyda HM,

Additionally, Please take a look into the following post and the discussion which might be useful.

NEW REPORT: Journal and Transaction Details Report — Cloud Customer Connect

Hope this help.

Thank you.

Bhaskar Konar · Answer

Hi @Zeneyda HM,

Welcome to the Oracle Analytics & AI Community!

You may find the following Oracle out-of-the-box report helpful as a starting point. It can be extended and customized further to meet your specific requirements.

Report Name: Journal And Transaction Details Report

Location: /Shared Folders/Financials/General Ledger/Journals

Hope this help.

Thank you.