Increase Efficiency with Product Group Dynamic Choice Lists

Speed administrator tasks by setting up dynamic choice lists for product group data selection within Sales objects like opportunities and leads. After you configure product group dynamic choice lists in Application Composer, Sales Catalog administrators can use them with specific filter criteria. You can also use dynamic choice lists with your own custom objects.

Use the procedure, Create Product Group Dynamic Choice Lists, to create the dynamic choice lists. As you implement this feature, keep in mind:

  • Oracle supplies an existing filter named GetProductGroupsForUsage to facilitate setup.
  • The example filter expression value for Bind_usageCode is 'BASE'.
  • The example filter expression value for Bind_UsageModeCode is 'MOO' when you define a custom choice list field for Opportunity. This includes any other associated filter functions, such as the territory engine, if defined for Opportunity in the Manage Product Group Usage task.
  • If you want a choice list field to display all available product groups, use the filter expression value, 'QSC' for Bind_UsageModeCode.
  • The filter expression value for Bind_UsageModeCode is 'MKL' when you define a custom choice list field for Lead.
  • For example filter expression values to set up for variable Bind_UsageModeCode when you define the custom choice list (dynamic) field for Opportunity, navigate and refer to Setup and Maintenance > Manage Product Group Usage > Select Usage: Base > Base Details > Modes > Description.
Note: You must include the single apostrophes in the filter expression values when you enter them.