Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Best Answer
-
@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.
1
Answers
-
@Lauriane Massin Whitaker For HCM use the below spreadsheet to understand the Fusion PVO related lineages.
Going forward you can ask these questions in the Fusion community for accurate responses.
0 -
Thank you but XLE_ETB_PROFILES does not seem to be found in this spreadsheet… that's my concern.
Only XLE_ENTITY is
0