Use Decision Tables and Bucket Sets in Business Rules

Use a decision table to create a set of IF statements and display them as a table.

If you must analyze more than one combination of attribute values, then the decision table is more compact and intuitive to use than a number of individual IF statements. The decision table doesn't require you to use all If statements and Then statements in every rule.

Note that you can't add a bucket set to a fact.

Examine some examples that use a decision table and bucket set. For details, see Create Transformation Rules and Assign Orchestration Processes

Bucket Sets

A bucket is a container that sets up a list of values or a range of values that the If statement uses to determine whether its true.

A bucket set is a container that you can use to hold the overall range of values that a group of buckets defines. Use it to constrain the values that the If statement and the facts in a decision table will consider.

Assume you create a Colors bucket set that includes string values of red and purple. You can write a rule for each color. You can also write one rule for blue and another rule for purple.

Or assume you create a Numbers bucket set that uses integers instead of strings. You can create buckets in the Numbers bucket set. Here are the buckets.

• Less than 1

• 1 to 10

• Greater than 10

You can create a bucket set that specifies aliases for data that might be difficult to recognize, such as identification numbers. You can use the toString function in the If statement to convert the value from the Long data type to a String alias, such as a product code. The bucket set will map each identification number to the product code.

Here's an example bucket set that groups ranges of values into a large, a medium, or a small bucket.

Use Predefined Bucket Sets

Here they are.

• ORACancelReason

• ORACarrier

• ORAConversionType

• ORACurrencies

• ORADemandClasses

• ORAFOB

• ORAFreightTerms

• ORAInvoicingRules

• ORAModeOfTransport

• ORAPaymentTerms

• ORAReceiptMethods

• ORAReturnReason

• ORAReturnReason

• ORASalesCreditTypes

• ORAServiceLevel

• ORAShipmentPriority

• ORASupplier

• ORASupplierSite

• ORATaxClassificationCodes

• ORATaxExemptionReason

• ORAUOM

• ORAWarehouses

• RAAccountingRules

Add Data to Your Bucket Sets

Run a scheduled process to populate your bucket sets with data.

Assume you need to populate your bucket set only with data that's related to your Computer Service and Rentals customer.

1. Go to the Scheduled Processes work area.

2. Click Schedule New Process, then search for the Generate Bucket Sets scheduled process.

3. In the dialog that displays, set the value.

   Parameter	Value
   Bucket Set Name	You must leave this parameter empty. It is no longer supported.
   View Object Name	You must leave this parameter empty. It is no longer supported.
   Where Clause	You must leave this parameter empty. It is no longer supported.
   Refresh Collected Data	Set a value. Yes. Keep your bucket set up to date with data in the entities that the bucket set references. No. Don't use this value.

4. Click Submit.