User-Defined Elements

Many elements in Oracle Hyperion Financial Management are user-defined. For example, when you create a journal, you specify a label and description.

User-defined elements, the minimum and maximum length for each element, and additional restrictions are listed below. The table groups the elements by the modules in which they are found.

Table 1-1 Requirements for User-Defined Elements

Element Min. length Max. length Restrictions

Application Profile

Language

1

20

None

Period label

1

80

  • Must contain only alphanumeric characters.

  • Cannot contain spaces, symbols, or diacritical marks such as umlauts.

View label

1

10

  • Must contain only alphanumeric characters.

  • Cannot contain spaces, symbols, or diacritical marks such as umlauts.

View description

0

40

Cannot contain an ampersand (&).

Period description

0

40

Cannot contain an ampersand (&).

Create Application

Application label

1

10

  • Must contain only alphanumeric characters.

  • Cannot start with a number.

  • Cannot contain spaces, symbols, diacritical marks such as umlauts, or special characters such as German Capital Sharp S.

Note: Application labels are not case-sensitive. For example, App1 and APP1 are considered the same application label.

Application description

1

255

  • Cannot contain an ampersand (&).

  • Cannot contain spaces.

Member label

1

80

Must be unique. The label can contain up to 80 characters including spaces, but cannot start with a space.

Cannot include these characters:

  • Ampersand (&)

  • Asterisk (*)

  • At sign (@)

  • Comma (,)

  • Curly brackets ({})

  • Double quotation mark ""

    Forward slash (/)

  • Minus sign (-)

  • Number sign (#)

  • Period (.)

  • Plus sign (+)

  • Semicolon (;)

Note: You cannot use ALL as the name of an entity.

Member description

0

40

Cannot contain an ampersand (&).

Note: Avoid using a period (.) in a member description when you select to work in Description mode.

Alias label

0

80

Cannot contain an ampersand (&).

Security

Security class

1

80

Cannot include these characters:

  • Asterisk (*)

  • At sign (@)

  • Comma (,)

  • Curly brackets ({ })

  • Double quotation mark ""

  • Minus sign (-)

  • Number sign (#)

  • Period (.)

  • Plus sign (+)

  • Semicolon (;)

  • Slash mark (/)

Journals

Journal label

1

20

Cannot include these characters:

  • Asterisk (*)

  • At sign (@)

  • Comma (,)

    Curly brackets ({})

  • Double quotation mark ""

  • Forward slash (/)

  • Minus sign (-)

  • Number sign (#)

  • Period (.)

  • Plus sign (+)

  • Semicolon (;)

Journal description

0

255

None

Journal group

0

30

None

Journal line item description

0

50

None

Load/Extract

Delimiter character

1

1

Must be one of these characters and cannot be used in the file or in the file name:

  • Ampersand (&)

  • At sign (@)

  • Backslash (\)

  • Carat (^)

  • Colon (:)

  • Comma (,)

  • Dollar sign ($)

  • Line (|)

  • Percent sign (%)

  • Question mark (?)

  • Semicolon (;)

  • Tilde (~)

Note: You must use the same delimiter character throughout the file. Using different delimiter characters within the same file causes an error when you load the file.

Data grids

Cell description

1

1900

None

Line item detail

1

80

None

Annotation

0

255

None

Decimal character

1

1

These characters are invalid decimal characters for data grids:

  • Backslash (\)

  • Forward slash (/)

  • Minus sign (-)

  • Plus sign (+)

Documents

Document names

(including folder and report names)

1

16

These characters are invalid characters for document names:

  • Asterisk (*)

  • At sign (@)

  • Backslash (\)

  • Colon (:)

  • Comma (,)

  • Curly brackets ({})

  • Double quotation mark ""

  • Forward slash (/)

  • Greater than sign (>)

  • Less than sign (<)

  • Line (|)

  • Number sign (#)

  • Period (.) at the end of a document name

  • Plus sign (+)

  • Question mark (?)

  • Semicolon (;)

Note: Document names also cannot contain trailing or leading white space.