PVO related to ego_item_eff_b

Question

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.

https://community.oracle.com/customerconnect/discussion/605622/extract-item-eff-information-using-bicc

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):

Doug 11235813 · Answer

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?

KaustubhP · Answer

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

Bharath Raghupathi-Oracle · Answer

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