1. Subscription Management Questions and Answers
  2. What descriptive flexfields can I use in subscriptions?

What descriptive flexfields can I use in subscriptions?

You can enable descriptive flexfields for subscriptions and subscription products using the Manage Descriptive Flexfields task in the Setup and Maintenance work area.

Once you define the descriptive flexfields, you can access these on the Subscription Number and Edit Product page by navigating to Actions > Edit Additional Information.

In Subscription Management, descriptive flexfields coexist with Application Composer custom attributes. Oracle recommends that you use descriptive flexfields only for choice lists that can't be created using the Application Composer fixed choice list and dynamic choice list.

Here are the descriptive flexfields types you can define at the subscription and subscription product level:

  • Character: 30 attributes
  • Number: 10 attributes
  • Date: 10 attributes
Subscription Management supports the use of the following subscription attributes for setting the initial value of segment values:
  • Customer
  • Bill to Account
  • Bill to Site
  • Ship to Account
  • Ship to Site

For subscription products, only Inventory Item or Inventory Product is supported to set the initial value of a segment.

Here are a few limitations of using descriptive flexfields in Subscription Management:

  • Descriptive flexfields segments aren't visible in service mappings. You must use algorithm extensions to interface descriptive flexfields values to Oracle Accounts Receivable and Oracle Revenue Management Cloud Services.
  • Column names in an import CSV file don't match the descriptive flexfields segment names. You must do manual mappings.
  • Hierarchical import of Subscription and Subscription Product descriptive flexfields isn't supported. You must import these independently.
  • Search based on descriptive flexfields segments on the Subscriptions landing page isn't supported.
  • Descriptive flexfields segments aren't supported in Subscription SOAP services.

Subscription Import and Descriptive Flexfields

  • The descriptive flexfield attributes can be imported and updated in all subscription statuses.
  • No validations are performed during import of descriptive flexfield attributes.
  • Descriptive flexfield attributes can't be deleted using Import Management.

Subscription Lifecycle and Descriptive Flexfields

  • Descriptive flexfields are copied to the new subscription or subscription product when the subscription header or subscription product is copied.
  • Descriptive flexfields are copied to new product line when a subscription product line is amended separately or amended using mass update.
  • Descriptive flexfields are copied to a new product line when Schedule Product Change is performed, when a subscription is renewed, and on resumption of a suspended product line. During consolidation at time of renewal the descriptive flexfields aren't copied.

You can use descriptive flexfields to create global and context-sensitive segments. This feature lets you write SQL queries to retrieve data from other products, such as Oracle Order Management and Oracle Accounts Receivable.

For more information about descriptive flexfields, see the Oracle Applications Cloud Implementing Applications and the Oracle Applications Cloud Configuring and Extending Applications guides.

Related Topics