How to use phone numbers (Work phone, Mobile phone and home phone) in OTBI

Hi Oracle Community,

The customer needs to report the Contact (Person) phone numbers (Work phone, Mobile phone and home phone) in OTBI, but these atributtes are not available.

Is there any way to view these atributtes in a subject área in OTBI?

Meanwhile, we tried to create a SQL query but we don’t able to find these atributtes there neither. Where (what is the table) are loaded the phone numbers (Work phone, Home phone and Mobile phone)?

Regards,