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

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Open Interface and Inv 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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms