Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
metadata file for the PO Header and PO Line DFFs
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
Answers
-
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.0
