How to get other fields or more information from ERP fusion modules

Question

I have the following business need: We want to create an AP report to have consolidated information when preparing payments. This report contains detailed information about the supplier, invoices, payments, etc. I have tried to make this report with the subject area: "Financials - AP Invoices" but it is evident that all the fields I need are not available for use.

For example, I need the report to show detailed supplier information such as their bank accounts that are at the site level.

I have tried to expand the data through the semantic model but I have not been able to do it, I can't find that information. I also tried to connect to Fusion to use the thematic areas of OTBI, but a consultant told me that it was not a good practice. What alternatives can I use to build this report from FDI?

Ram-Oracle · Accepted Answer

@SERGIO BARRETO Please you may try below alternative approaches and see if it works.

* There is a bank account attribute in ap payments subject area.please check if this data related to bank account helps to some extent.

2.Other alternative options like creating a otbi bip report based on fusion bip tables which holds supplier bank account information and use faw/fdi bip data source connection to connect to this source bip report  and create data augmentation job with source as otbi bip and which in turn will create adw table.

3.Use this adw table at fdi oac datasets and join with ap payments or ap invoice subject areas and create a final report with supplier  bank details .

Please check if this  approach helps achieving your requirement

Ram-Oracle · Accepted Answer

@SERGIO BARRETO Hi Sergio, After bip table using data augmentation was created in ADW db ,please use this table at oac datasets and join with  OOTB subject areas  available from fdi.

other suggestions are welcome.