Which three statements are true about modifying Flexfield values? (Choose three.)

Question

Options

• AThe values cannot be disabled.
• BThe value description can be changed.
• CThe effective dates for a value can be limited.
• DThe values can be deleted after they are defined.
• EThe values cannot be modified after they are defined.

• A
  15% (7)
• B
  81% (39)
• D
  4% (2)

Explanation

Flexfield values in Oracle follow specific immutability rules designed to protect data integrity across transactions.

Why B, C, and E are correct: Once a Flexfield value is defined, its underlying code is locked - you cannot alter the value itself (E). However, Oracle allows two cosmetic/administrative changes: updating the human-readable description (B) and setting effective start/end dates to control when a value is available for selection (C). This balances data consistency with operational flexibility.

Why the distractors are wrong:

• A is wrong because values can be disabled (made inactive via effective dates or an enabled flag) - disabling is precisely the mechanism Oracle provides instead of deletion.
• D is wrong because values generally cannot be deleted once defined; removing them would risk breaking existing transaction records that reference those values.

Memory tip: Think of it as a published law - you can add an expiry date (C) or change the title in the gazette (B), but you cannot rewrite the law's text once enacted (E), and you certainly can't pretend it never existed by deleting it (D). "Describe and Date, but don't Delete or alter."

No community discussion yet for this question.