How You Specify Work Phones

A person can have only one primary phone. Typically, employees see others' phone details only if it's work related and primary. If you specify a nonwork phone as primary then workers can't see the phone details.

Who can see which phone number is controlled by Oracle's virtual private database policy, which can't be changed

Access Security and Privileges

You can see a coworker's work and nonwork phone numbers if your role has these privileges

• Manage person phones data

• View person phones data

• Report person phones data

It's important to understand these phone lookup codes since the virtual private database policy relies on the lookup codes:

Lookup Code	Meaning
W1	Work Phone
W2	Second Work Phone
W3	Third Work Phone
WF	Work Fax
WM	Work Mobile Phone

If you want to change the phone type, keep in mind the lookup code and how the VPD policy works with that lookup code. Lookup codes starting with W indicate the phone number is public and can be viewed by all. Lookup codes not starting with W indicate the phone number is private and can be seen only by people with the required privileges.