Oracle Analytics

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

FscmTopModelAM.LinesDFFBIAM.FLEX_BI_LinesDFF_VI not available in BICC for AP_INVOICE_LINES_ALL

Received Response
182
Views
2
Comments
MohanPothuri
MohanPothuri Rank 3 - Community Apprentice

We have enabled DFF for AP Invoice headers and AP Invoice lines using "Manage descriptive flexfields" in setup and maintenance.

For Attribute columns, selected check box for 'BI ENABLED' , so that we can access columns from BICC and OTBI.

I observed that FLEX_BI_HeaderDff_VI is available but not FLEX_BI_LinesDFF_VI in BICC.

Please suggest a way to fetch FLEX_BI_LinesDFF_VI in BICC.



Reason for choosing FLEX_BI_LinesDFF_VI : This PVO helps in identifying DFF attributes with corresponding segment labels. Other PVOs (FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceLineExtractPVO) just populate as Attribute1,2,3.

image.png


Thanks in advance.

Answers