Oracle Analytics and AI

Sachin Shejwadkar

Can you provide a sample extract or schema definition for the PO Header and PO Line DFFs that lists both the column names and their data types?

FscmTopModelAM.POLineDFFPublicBIAM.FLEX_BI_POLineDFFPublic_VI

FscmTopModelAM.POHeaderDFFPublicBIAM.FLEX_BI_POHeaderDFFPublic_VI

Riyaz Ali-Oracle

DFFs in Oracle applications contain columns named ATTRIBUTEn, where n is a number. These columns store additional information that businesses may need beyond standard fields. If you're working with PO_HEADERS_ALL or PO_LINES_ALL, the DFFs would be associated with these tables.

To get the exact schema definition, you might need to:

Query the data dictionary using SQL to retrieve column names and data types.
Check the Oracle BI Cloud Connector (BICC) PVOs for PO Headers and Lines.