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

Question

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 · Accepted Answer

@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.