Need attribute (DFF) columns included in supplied PVOs — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need attribute (DFF) columns included in supplied PVOs

373
Views
4
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Jacobs Technology Inc


Description (Required): Need attribute (DFF) columns added to the entity related BI Cloud Connector (BICC) PVOs for the following tables... HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, HZ_CUST_ACCOUNTS, PER_ALL_ASSIGNMENTS_M, PER_ALL_PEOPLE_F, PO_HEADERS_ALL, PO_LINES_ALL


Use Case and Business Need (Required): Business is extracting data using BI Cloud Connector (BICC) for the entities related to the following tables and their attribute columns are not included in their respective PVOs... HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, HZ_CUST_ACCOUNTS, PER_ALL_ASSIGNMENTS_M, PER_ALL_PEOPLE_F, PO_HEADERS_ALL, PO_LINES_ALL

For example their are no attribute columns included in any of the 3 PVOs below for purchase headers...

FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.DraftPurchasingDocumentHeaderExtractPVO

FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentHeaderExtractPVO

FscmTopModelAM.PrcPoPublicViewAM.StandardHeaderPVO

Because of this the business cannot extract the needed data stored in attribute fields using BI Cloud Connector (BICC)


Enhancement Request / Service Request: SR 3-32131020471 : ER ^ Missing attribute columns in PVOs info for certain tables

16
16 votes

Submitted · Last Updated

Comments

  • Stéphane Lamy-Bouchard
    Stéphane Lamy-Bouchard Rank 2 - Community Beginner

    Sharing the same requirement :

    Organization Name : Ville de Montréal (City of Montreal)

  • Isai Ramos
    Isai Ramos Rank 1 - Community Starter

    Hello, I have the same need regarding PO_HEADERS_ALL, do you have anything working now?

  • Isai Ramos
    Isai Ramos Rank 1 - Community Starter

    Hello, we need to do the same for:

    PurchasingDocumentHeaderExtractPVO for PO_HEADER_ALL 

    PurchasingDocumentDistributionExtractPVO for PO_DISTRIBUTIONS_ALL 

    Do you have any possible workaround?

  • Amritha2184-Oracle
    Amritha2184-Oracle Rank 1 - Community Starter

    Hello,

    Is there any update on this requirement and the correct PVO to be used to extract DFF columns like Attribute1 , Attribute2 etc ?