1. Understanding Import and Export Management for Sales and Fusion Service
  2. Import Descriptive Flexfields

Import Descriptive Flexfields

A flexfield is a flexible data field that your organization can configure according to your business needs. Descriptive Flexfields (DFF) capture additional business information such as the name of the company's owner.

DFF's data are stored in the attributes. These are fixed set of custom fields and can be of data type VARCHAR2, NUMBER, DATE, or TIMESTAMP.

For more information on DFFs see the chapter Flexfields in the guides Oracle Applications Cloud Configuring and Extending Applications (http://www.oracle.com/pls/topic/lookup?ctx=cloud&id=OAEXT) and Oracle Sales Implementing Incentive Compensation (http://www.oracle.com/pls/topic/lookup?ctx=cloud&id=OAWIC) available on the Help Center.

Objects Supporting the DFF Import

The objects that support the DFF fields are:

  • Contract (child object is Contract Header Descriptive Flexfield)

  • Contract Line (child object is Contract Line Descriptive Flexfield)

  • Contract Party (child object is Contract Party Descriptive Flexfield)

  • Contract Party Contact (child object is Contract Party Contact Flexfield)

How you Register new Objects for DFF Support

Follow these steps to register any new object for DFF support:

  1. In the Navigator, click Tools > Import Management.

  2. On the Manage Imports page, click the Create Import Activity button.

  3. Create an import by selecting the Contract object from the drop-down list. For more information on creating an import, see the topic Import Data.

  4. Once the import completes, create another import by selecting the Contract Header Descriptive Flexfield child object from the drop-down list.

  5. In the source CSV file, include the ContractPuid header attribute and provide the value you entered for the parent object import. For each DFF field, provide its Table Column name in the header. Select the source CSV file and click Next.

  6. Click Next to go to the Map Fields page. Here you can see only the AttributeNames and not the DFF attribute labels. Map the attributes and click Next. Submit the import on the Review and Submit page.

  7. To verify your contracts after import completes, navigate to Contract Management > Contracts.

Note: Only high-volume import supports importing DFF fields.

Related Topics