Your customer has a requirement across their 10 warehouses, each with different users. They would like that whenever a warehouse user logs in, their warehouse should get populated. How will you…

Question

Options

• ASet up the profile option INV_DEFAULT_WHSE_ID at site level.
• BSet up the profile option INV_DEFAULT_WHSE_ID at user level for each user.
• CSet up the profile option INV_DEFAULT_WHSE_ID at role level (different roles for different
• DSet up the profile option INV_DEFAULT_ORG_ID at user level for each user.
• ESet up the profile option INV_DEFAULT_ORG_ID at role level (different roles for different
• FSet up the profile option INV_DEFAULT_ORG_ID at site level.

• A
  16% (5)
• C
  3% (1)
• D
  6% (2)
• E
  71% (22)
• F
  3% (1)

Explanation

Option E is correct because INV_DEFAULT_ORG_ID is the proper profile option for defaulting an inventory organization (warehouse) in Oracle, and setting it at the role level is the most scalable approach - you create one role per warehouse, assign all relevant users to that role, and when any of those users log in, their warehouse populates automatically without individual configuration.

Why the distractors fail:

• A & F (INV_DEFAULT_ORG_ID/INV_DEFAULT_WHSE_ID at site level) apply a single default to all users system-wide - useless when 10 different warehouses need different defaults.
• B uses the wrong profile option name (INV_DEFAULT_WHSE_ID); additionally, user-level setup means manually configuring every individual user, which is inefficient at scale.
• C has the right level (role) but the wrong profile option (INV_DEFAULT_WHSE_ID instead of INV_DEFAULT_ORG_ID).
• D has the correct profile option (INV_DEFAULT_ORG_ID) but user-level setup requires touching each user record individually - feasible but not the best practice when roles exist.

Memory tip: Remember "ORG, not WHSE" - in Oracle Inventory, warehouses are represented as organizations, so the profile is ORG_ID. Then remember "Role = one setup per warehouse" - roles bundle users together, so 10 warehouses = 10 roles, far better than configuring dozens of individual users.

No community discussion yet for this question.