Search This Blog

Wednesday, April 3, 2013

Payables Interface: Copy Line Attribute Values to Distribution Attributes in R12

Issue:
We are upgrading to R12 from R11. Currently in R11, we populate the AP_INVOICE_DISTRIBUTIONS_ALL table with DFF values (attributes). These DFF values are flowing through to Projects, which is what we need. (The DFF values are the external system PO numbers, work order numbers, etc.)

In R12, the Payables Interface populates the DFF in the "AP_INVOICE_LINES_ALL" table. This data is not flowing into the AP_INVOICE_DISTRIBUTIONS_ALL table. Since it is the Distributions table that ultimately flows into Projects. the DFF data is not getting into Projects.

We need the DFF values to flow from the Payables import interface through Payables and into Projects. 

Is there a way to link the DFF (attributes) on the AP_INVOICE_LINES_ALL table to the AP_INVOICE_DISTRIBUTIONS_ALL? Or, is there another way to get it from the AP Interface and into Projects?

Solution: Enable Profile Option : AP: Copy Invoice Lines Flex field to Distributions during Import

No comments:

Post a Comment