Categories
How to get other fields or more information from ERP fusion modules
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?
Best Answers
-
@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
0 -
@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.
0
Answers
-
@SERGIO BARRETO - One option would be to find the PVO which stores this data at Fusion end and then use Data Augmentation to being in the data in to FDI and use SME to model it to attain the requirement. Thanks!
1 -
@Ram-Oracle hi Ram, thanks for your response.
I did option 2, however, but joining a subject area from OTBI and the table created from BI Publisher, but I did not manage to establish a correct join, any advice?
0
