BIAPPS Fusion datawarehouse

user12302396

Hello,

I am trying to understand the architecture between UCM and ODI. We have implemented Oracle Fusion apps for Procure and spend module, will be extending this to Financial modules soon.

My question is how does ODI reads the files loaded into UCM using BI cloud connector console. I have done the below steps

Logged into BI Cloud connector console (BICCC) and configured a cloud extract for the offering  'Oracle Procurement and Spend Analytics' and scheduled the extract to UCM.

After the scheduled process is complete, I logged into UCM and was able to find several files extracted from FUSION to UCM. I randomly selected the file below zip file

'file_fscmtopmodelam_finapinvtransactionsam_invoicedistributionpvo-batch731076681-20170117_191615.zip'. I opened the excel file to compare the list of columns to the file available in the ODI mapping.

Navigation :

BI Apps Project-->Mappings-->SDE_FUSION_10_Adaptor-->FTS_FUSION_FscmTopModelAM.FinApInvTransactionsAM.InvoiceDistributionPVO

under this opened the Interfaces and was trying to compare the file extracted to UCM to the file used as a source in ODI. They do not match.

Can anyone help me the in understanding the process to read the file from UCM to ODI and load them to the corresponding staging and target tables?

Thanks