We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
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