Oracle Communities

Oracle Analytics and AI

Child Item

XLE_ETB_PROFILES PVO needed

Hi,

We are trying to create a view with the legal entities, establishments, etc and registration number.

We managed to join the client-provided table augmented #1 (FscmTopModelAM.FinExtractAM.XIBiccExtractAM.RegistrationExtractPVO) where we have the reigistration number, with another augmented table #2 (FscmTopModelAM.FinLeLegalEntitiesAM.EstablishmentPVO) where REGISTRATIONSOURCEID = ESTABISHMENLEGALENTITYID (the 2nd one contains legal entity, est, address, and a few interesting data).

But with this join, we only get the yellow highlighted type of registration number (9 characters instead of the full 14 character number in blue).

What is the PVO we can use that contains the table XLE_ETB_PROFILES please ?

Regards

LAuriane

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

Ashish-Oracle

@Lauriane Massin Whitaker As advised earlier, Its best to reach out to the Fusion Community for queries related to Fusion OTBI Lineages for accurate responses.

All comments

Ashish-Oracle

@Lauriane Massin Whitaker For HCM use the below spreadsheet to understand the Fusion PVO related lineages.

https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1

Going forward you can ask these questions in the Fusion community for accurate responses.

https://community.oracle.com/customerconnect/

Lauriane Massin Whitaker

Thank you but XLE_ETB_PROFILES does not seem to be found in this spreadsheet… that's my concern.

Only XLE_ENTITY is

Ashish-Oracle

@Lauriane Massin Whitaker As advised earlier, Its best to reach out to the Fusion Community for queries related to Fusion OTBI Lineages for accurate responses.