Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- 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
1 -
We cannot see this either —
- FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO in PVO list as well as custom offering doesn't have it listed.Is there anyone who can provide a updated how to guide?
0