R12:AP: APXIIMPT:Interface Description Flexfield (DFF) values is not getting Copied to Invoice Distributions for PO Matched Invoices (Doc ID 1564250.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

On : 12.1.3 version, Open Interface and Invoice Import

scenario 1:
1)Enabled profile option 'AP: Copy Invoice Lines DFF to Distributions during Import'
2)Disable checkbox -> Payable Option -> Transfer PO Descriptive Flexfield Information
Result: DFF as per interface is copied to invoice distributions after import (Expected)

scenario 2:
1)Enabled profile option 'AP: Copy Invoice Lines DFF to Distributions during Import'
2)Enable checkbox -> Payable Option -> Transfer PO Descriptive Flexfield Information
3)PO Distributions DFF is populated.
Result: DFF values is copied from PO distributions rather than Interface (Not expected)

scenario 3:
1)Enabled profile option 'AP: Copy Invoice Lines DFF to Distributions during Import'
2)Enable checkbox -> Payable Option -> Transfer PO Descriptive Flexfield Information
3)PO Distributions DFF is not populated but DFF is populated in AP_INVOICE_LINES_INTERFACE
Result: Interface DFF values is copied to AP_INVOICE_LINES but not AP_INVOICE_DISTRIBUTIONS. (Not expected)

Below is the behaviour explained in Payables Implementation Users Guide
Release 12.1
Part No. E12795-04

   Transfer PO Descriptive Flexfield Information. Enable this option if you want
   Payables to automatically transfer the descriptive flexfield information from the
   purchase order distribution to the invoice distribution when you match an invoice to a
   purchase order. If you enable this option, make sure that the flexfield structure is the
   same for purchase order distributions and invoice distributions.

   Please note that for invoices imported through the invoice open interface if a value is
   provided for any flexfield attribute in the invoice open interface, that value will
   overwrite the resulting attribute value on the invoice.

So for imported invoices expect the DFF values in AP_INVOICE_LINES_INTERFACE to be copied to invoice distributions AND when DFF is not populated in PO_DISTRIBUTIONS, DFF values from AP_INVOICE_LINES_INTERFACE to be copied.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.