Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Content of different email fields in OTBI

We noticed that the email data that we get for the learners from OTBI is
inconsistent and would like to know where those differences may come
from and which OTBI email column we should use when generating
mailing lists for learners.
We use the following 3 OTBI subject areas:
- Subject area "Learning Records":
Our main subject area which we use for reporting about training
completions, training times etc. - Subject area "Learning Management":
We rarely use this subject area as it misses some columns like Offering
Language and doesn't allow well to differentiate between the enrollment
situation on the offering level versus the enrollment situation on the
course level for individual learners. - Subject area "Worker Assignment":
We use this subject area in order to create reports which are then used as
the basic building block for Global Access Groups and Learning Initiatives.
While the email data for individual employees seems to be identical in
the subject areas "Learning Records" and "Learning Management", the
data in "Learning Records" is sometimes empty.
Maybe someone from the community can give us feedback on the following questions:
- Where does OTBI draw the data from that appears in the column
"Assignee Primary Email Address" in the subject area "Learning
Records"? - Why is the content of the field sometimes empty for the
learners even though there are email addresses for them in the other
subject areas?
We look forward to your reply!
Answers
-
Hi @szoerner,
Welcome to the Oracle Analytics Community!
Please take a look into the following post where you can get the OTBI Subject Area to Database Lineage document which will be helpful to understand which column is coming from where.
HCM OTBI subject areas to database lineage mapping spreadsheet — Cloud Customer Connect
Hope this help.
Thank you.
0