Translate

Wednesday, July 15, 2015

Inventory Convergence make any attempt to copy Descriptive Flexfield (DFF)

Does the OPM Migration process for Inventory Convergence make any attempt to copy Descriptive Flexfield (DFF) setup information for an OPM table from the Release 11i database to the corresponding Discrete Inventory table in the Release 12 environment?

We are specifically thinking of a DFF which we have on the OPM Lot Master table (IC_LOTS_MST). In this example would DFF setup and data be copied to MTL_LOT_NUMBERS in the Release 12 environment?

SOLUTION

Provided that there is no data conflict (that is to say, another Descriptive Flexfield already using the relevant 'Attribute' columns in the target table) then the migration process will copy DFF data from the OPM table to the corresponding Discrete Manufacturing (ODM) table.

If there is a data conflict (for example, column ATTRIBUTE1 already used by an existing DFF), then this should be highlighted by the pre-migration report and will need intervention.

Please note, however, that the migration makes no attempt to set up the FND Descriptive Flexfield definition for you in Release 12.  You will need to do this setup (the DFF column names, Value Sets and so on) after the migration is complete.