Tip Tuesday - Application Boundaries and Magic Numbers

Approval Workflow

• 256 characters for the approve/reject comment in Approval Workflow
• 4000 characters for the Submit Comment in Approval Workflow

Attributes

• 16 digits maximum length of a Currency attribute converted to scientific notation
• (for example, 10,000,000 is 10e6 in scientific notation).
• 16 digits maximum length of a Float attribute.
• 18 digits maximum for the _system_transaction_counter attribute
• 255 characters in a text field (Not text area)
• 4000 characters in an attribute description
• 200 configuration array rows
• 500 rows in a Transaction Array
• To increase the default row size, open a ticket on My Oracle Support.
• -2,147,483,648 to 2,147,483,647 = integer variable value range

BML

• 64kb maximum length of a BML script (limit on Java try block).