Best way to get data from 'Standard Lookups' (FND_LOOKUPS) in Fusion into Fusion Data Intelligence

Richard J Smith

What is the best way to get data from 'Standard Lookups' (FND_LOOKUPS) in Fusion into Fusion Data Intelligence?

We are creating a procurement dashboard in FDI and we'd like to be able to map cost centres to business lines and business leaders. The team is planning on storing this mapping in Fusion in the FND_LOOKUPS table.

Is it possible to load and map this data from Fusion? What would be the best way to do this?

Ashish-Oracle

@r1csm1th One way would be identify the underlying PVO's for the FND_LOOKUPS table and create Augmentations on top of those PVO's to bring the required data to the Database. Post that you can perform Semantic Model Extensions and bring in the table to the required Procurement based SA you want.

Conor Murnane

Agree with Ashish - I was able to successfully do what you have stated.

The name of the VO's are

FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO

or FscmTopModelAM.AnalyticsServiceAM.LookupValuesTLPVO.

Then create the Data Augmentation as a Data Set. Then update the Semantic Model so you can join on whatever attribute you need.