User-Defined Elements

Many elements in Financial Management are user-defined. For example, when you create a journal, you give the journal a label and a 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. 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 start with a number.

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

View label

1

10

  • Must contain only alphanumeric characters.

  • Cannot start with a number.

  • 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, or diacritical marks such as umlauts.

    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 ( & ).

Metadata Manager

Member label

1

80

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

Note:

If you are using an Oracle database, member labels cannot contain spaces.

You cannot use the following characters in the member name:

  • period ( . )

  • plus sign ( + )

  • minus sign ( - )

  • asterisk ( * )

  • forward slash ( / )

  • number sign ( # )

  • comma ( , )

  • semicolon ( ; )

  • at symbol ( @ )

  • double quotation mark ( " )

  • curly brackets ( { } )

Note:

You cannot use ALL as the name of an entity.

Member description

0

40

Cannot contain an ampersand ( & ).

Alias label

0

80

Cannot contain an ampersand ( & ).

Security

Security class

1

80

None

Journals

Journal label

1

80

Cannot include the following characters:

  • period ( . )

  • plus sign ( + )

  • minus sign ( - )

  • asterisk ( * )

  • forward slash ( / )

  • number sign ( # )

  • comma ( , )

  • semicolon ( ; )

  • at symbol ( @ )

  • double quotation mark ( " )

  • curly brackets ( { } )

    Note:

    If you are using an Oracle database, journal labels cannot contain spaces.

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 the following characters and cannot be used in the file or in the file name:

  • comma ( , )

  • tilde ( ~ )

  • at sign ( @ )

  • dollar sign ( $ )

  • percent sign ( % )

  • ampersand (&)

  • carat ( ^ )

  • line ( | )

  • colon ( : )

  • semicolon ( ; )

  • question mark ( ? )

  • back slash ( \ )

    Note:

    The ampersand ( & ) is not a valid delimiter for metadata .app files. 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

The following characters are invalid decimal characters for data grids:

  • back slash ( \ )

  • forward slash ( / )

  • plus sign ( + )

  • minus sign ( - )

Documents

Document names

(including folder and report names)

1

16

The following characters are invalid characters for document names:

  • plus sign ( + )

  • question mark ( ? )

  • asterisk ( * )

  • back slash ( \ )

  • forward slash ( / )

  • number sign ( # )

  • comma ( , )

  • semicolon ( ; )

  • colon ( : )

  • at sign ( @ )

  • double quotation mark ( " )

  • curly brackets ( { } )

  • line ( | )

  • less than sign ( < )

  • greater than sign ( > )

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

    Note:

    Document names also cannot contain trailing or leading white space.