Categories
- All Categories
- 71 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
PVO related to ego_item_eff_b
Summary: How can we access attribute fields frmo table ego_item_eff_b in ODI
Content (required): As per Oracle forums, there is no associated PVO for table ego_item_eff_b. As per below link, there is a VO associated with this table.
But I want to know how can I reverse engineer this in ODI environment to use it. I already have a connection created for Oracle BICC and have reverse engineered many PVOs but I couldnt able to do for this object.
Please provide me with solution.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi Sagunthala,
If you are not able to find the PVO for the "ego_item_eff_b" table you can ask the functional team to create a custom PVO for it.
How to create a custom PVO you can follow the below document:
Thanks & Regards,
Vivek Gautam
0 -
Hi Sagunthala,
In the below document it's also mentioned how to add this custom PVO in BICC.
Thanks & Regards,
Vivek Gautam
0 -
Hello,
By default EFF PVOs wont be enabled in BICC for extraction. You can create a customer offer and add the EFF PVOs to that offering.
For ego_item_eff_b table PVO is : FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO.
Thanks,
Bharath
0 -
Hi Bharath,
We are not able to find - FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO in PVO list as well as custom offering doesn't have it listed.
Regards,
Kaustubh
0