Skip Navigation
Expand
Activity duration key length and allocation of related fields
Answer ID 9757   |   Last Review Date 01/16/2019

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:  

Statistics > Activity duration stats fields shows value: Activity type[awortype] (5, case insensitive) and Case Type[ XA_CASE_TYPE] (10, case sensitive)

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.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.