PVO related to ego_item_eff_b

User_MC4QP

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

Vivek Gautam

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:

https://www.ateam-oracle.com/post/bi-cloud-connector-custom-object-data-extraction

Thanks & Regards,

Vivek Gautam

Vivek Gautam

Hi Sagunthala,

In the below document it's also mentioned how to add this custom PVO in BICC.

https://www.ateam-oracle.com/post/bi-cloud-connector-custom-object-data-extraction

Thanks & Regards,

Vivek Gautam

Bharath Raghupathi-Oracle

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

KaustubhP

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