What is the max length of the activity duration key and how are the fields allocated inside the key?
Environment:
Oracle Field Service (OFS) all versions
Issue:
What is the max length of the activity duration key and how are the specified fields allocated inside the key
Resolution:
The activity duration key length is fifty (50) characters. The key is created based on the fields and lengths specified under Configuration > Statistics > Activity duration stats fields in OFS.
For example:
The activity duration key is defined as:
Activity type[awortype] (5, case insensitive) - Five (5) characters will be reserved for this field.
Case Type[ XA_CASE_TYPE] (10, case sensitive) - Ten (10) characters will be reserved for this field.
Note: If the length of any of the fields is less than the length specified for the duration key, the remaining characters will be filled out with spaces so that it always matches the characters defined for the key.