FDI(FAW) Purchase Order Distributions DFF not available in FAW [Solved]

Santosh_V

Oracle Fusion Purchase Orders Distributions Descriptive Flexfields is not available for visualisation directly in the FAW Vanilla instance.

Navigation from FAW Admin screen:
Application Administration > Data Configuration > Custom Data Configurations > Descriptive Flex Fields > Edit

We are unable to see the option to add PO Distributions as it doesn't exist when when we searched with "Distributions" Keyword. (Screenshot attached)

When we searched with "Purchasing" keyword, we are finding only "Purchasing Document Headers" and "Purchasing Document Lines", but there is NO "Purchasing Document Distributions". (Screenshot attached)

We can overcome this with below custom solution:

Navigation from FAW Admin screen:
Application Administration > Data Configuration >Data Augmentation>Create> Augmentation

In Train Stop 1 (Source Selection):

Enter the parameters as shown below-

Augmentation Type: Extend Entity

Source Dataset Type: CUSTOM_ATTRIBUTE

Pillar: Enterprise Resource Planning

Source Table Type: Customer Provided

Source Table: FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentDistributionDFFExtractPVO

Once Done, Click Next.

In Train Stop 2(Attribute Selection):

Select the DFF attributes as needed.

In Train Stop 3(Column Options):

Use the Action button to edit Column Options as needed.

Make sure to leave the s_k_5000 field as Primary Key and LastUpdateDate as Incremental Key

In Train Stop 4 (Entity Options):

Select the Extending Entity as "Purchase Order Distributions"

Map the Primary Key to PO_DISTRIBUTION_ID

Train Stop 5 (Dimension Keys) will be disabled as we are extending Entity and not creating a Dimension.

In Train Stop 6 (Schedule and Save):

Enter a suitable Name, example: PODistDFF

Enter a suitable Description, example: PO Distribution DFFs

Enter a suitable Table Suffix, example: PODISTDFF

Table Name is auto-populated based on Table Suffix

Enter the Subject Areas(where PO Distribution DFFs are required) : "Procurement - Purchase Orders"."Distribution Details"

Schedule with Run Now Option and Submit.

The Data Augmentation will be queued for Activation. This may take a while.

Now, once the Data Augmentation is Activated, You can see in a new workbook, the PO Distribution DFFs are available in the "Procurement-Purchase Orders" Subject Area > Purchase Order Distribution Details Folder > Distribution Details subfolder

Therefore, we have extracted the PO Distribution DFFs with help of Data Augmentation Pipeline successfully.

For more details on different Data Store (PVOs) available for creating Augmentation Pipelines in FAW, Refer to below links:

https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-36897671731&id=2626555.1

https://docs.oracle.com/en/cloud/saas/analytics/24r2/fawag/augmenting-your-data.html#GUID-6ECE6166-ADD2-40AB-9AF5-FD702F432B90