Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Mohammed Kaja Nawaz L J
    How to Identify Physical table name for EGO_ITEM_EFF_B table
    Topic posted February 12, 2019 by Mohammed Kaja Nawaz L JBlue Ribbon: 750+ Points, tagged BICS, OTBI, Product Development, Product Information Management-PIM 
    185 Views, 4 Comments
    Title:
    How to Identify Physical table name for EGO_ITEM_EFF_B table
    Summary:
    How to Identify Physical table name for EGO_ITEM_EFF_B table
    Content:

    Hi all,

    I am using Oracle BICS Data Sync to get data from Oracle Fusion SaaS (Product Hub module). I got physical table name mapping from the below post:

    https://cloudcustomerconnect.oracle.com/posts/7643f26ffd 

    However, I couldn't identify the physical table name for EGO_ITEM_EFF_B (Extensible FlexField) to query it from Oracle BICS Data Sync.

    Any pointers would be highly helpful.

    Thanks,
    Nawaz

    Version:
    BICS,Data Sync

    Comment

     

    • Kumar

      Nawaz, 

      Please check if the below helps.

      For EGO_ITEM_EFF_B - The flex VO name is FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO

      • Mohammed Kaja Nawaz L J

        Kumar,

        I tried the given VO path by issuing select_physical query in Oracle BI under "Issue SQL" by replacing "ItemEFFBIFlattenedVO" with my EFF VO name obtained from FlexField archive but still it's not working.

        Thanks,
        Nawaz


         

    • Kumar

      Please log a SR in Oracle Support. BI Team would be able to assist further.

    • Manjunath Gangadhar

      FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO is the correct VO name. You need not replace it with anything else. This VO has certain columns which can be used to filter the relevant data based on your Context etc. 

      You can do a select_physical * on this VO and look at the data. Then filter on the appropriate columns to get the result that you need.