XLE_ETB_PROFILES PVO needed

Lauriane Massin Whitaker

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

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.

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