Descriptive Flexfields
AP Invoice Wizard allows you to upload Descriptive Flexfields for the Invoice Header, Lines and Distributions.
Profile Options are available to control Line and Distribution DFFs in R12. Refer to section: Profile Options
R12 Line and Distribution DFF Attribute fields in AP Invoice Wizard post version 9.6.16
Prior to EBS R12, the 'Payables Invoice Workbench' comprised of 2 levels, Invoice Headers and Distributions. The additional level, Lines, was added in Release 12.
As many EBS instances upgraded from versions prior to R12, Invoice Distribution Level DFF’s are still in use and very important in their R12 environments. However, Oracle didn’t provide a new interface table for the lines level, or a new set of attribute fields for the line level DFF’s. Now, when DFF data is populated into the interface, it only updates the AP Invoice Lines table.
To populate the DFF’s down to the distribution level Oracle introduced the following profile option to 'Copy' the information down during invoice validation or when first viewing distribution information in the Invoice Workbench:
“AP: Copy Invoice Lines Flexfield to Distributions during Import”
There are a few potential drawbacks with this option:
• After the copy the same DFF values will exist in the attribute fields in the ap_invoice_lines and ap_invoice_distributions tables. The lines data is not removed after the copy.
• The copy does not respect your DFF configuration validation, it simply copies the data directly into the same attribute fields.
AP Invoice Wizard now has better control of this functionality to allow users to ultimately have two different sets of DFF attribute information at the Invoice Line and Distribution level. If your current invoice template is based on AP Invoice Wizard 9.6.16 or earlier you may need to change the titles of your DFF columns, or add new DFF columns to your layout.
In version 9.6.16 and later new 'Line DFF' columns now exist which map to the Invoice Line Level and the previous 'Dist DFF' columns now map directly to the Invoice Distributions level.
Each of the sections below describes how to configure EBS, the Wizard, and the process required for your business needs in this regard.
Refer to section: