Oracle Communities

Oracle Analytics and AI

Child Item

Need Attribute fields (DFF) for table PO_HEADERS_ALL in PO Header Level BICC PVOs

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

Ville de Montréal (City of Montréal)

Description (Required):

Need ATTRIBUTE columns, or Descriptive FlexFields (DFF), added to the following BI Cloud Connector View Objects :

FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.DraftPurchasingDocumentHeaderExtractPVO;
FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentHeaderExtractPVO;
FscmTopModelAM.PrcPoPublicViewAM.StandardHeaderPVO.

Use Case and Business Need (Required):

Internally, many business users need information about PO Headers outside Fusion Applications, including organisation-specific DFFs, as part of their daily activities. Externally, as a public organisation, there is a need to be transparent and disclose various information about sourcing and procurement transactions and/or related statistics.

Enhancement Request / Service Request:

N/A

Find more posts tagged with

Submitted

BI Cloud Connector

Status: Submitted

Comments

RajivDel

Stéphane Lamy-Bouchard

Is it safe to use a BICC PVO view found in the online documentation but not available in the lineage mapping document ?

PVO :

https://docs.oracle.com/en/cloud/saas/procurement/24c/oadpr/PurchasingDocumentHeaderDFFExtractPVO.html#PurchasingDocumentHeaderDFFExtractPVO

The Purchase Document Header Descriptive Flexfields view object contains information about descriptive flexfields on a purchase document header.
- Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentHeaderDFFExtractPVO

Lineage link : https://community.oracle.com/customerconnect/discussion/47652/r13-x-fscm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping-spreadsheet/p1

Thanks

Amritha2184-Oracle

Hello,

Is there Any update on the correct PVO for the DFF fields of Purchase Order Tables?

Client requirement is to have extract columns as per the database table structure like Attribute1, Attribute2 etc .

But with the PVO "FscmTopModelAM.POHeaderDFFPublicBIAM.FLEX_BI_POHeaderDFFPublic_VI" or "FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentHeaderDFFExtractPVO", the structure is different and specific to the DFF configured in the system.

Can anyone provide their inputs.

Thanks in Advance,