nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Where to find the Enterprise Legal Seniority/ Hire Date fields to add in a OTBI report

Abhishek Bagh

Please advise

Find more posts tagged with

OTBI

Accepted answers

All comments

AjayKumar Maddipati

Hi Abhishek,

In OTBI most of subject areas available in below cloumns

Worker assigmnent real time subject area -in worker folder please find.

"Worker"."Enterprise Seniority Date"

"Worker"."Enterprise Hire Date"

--------------------------------------------------------------

SQL Issued-

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

0 s_0,

"Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Hire Date" s_1,

"Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Seniority Date" s_2

FROM "Workforce Management - Worker Assignment Real Time"

ORDER BY 3 ASC NULLS LAST, 2 ASC NULLS LAST

FETCH FIRST 500001 ROWS ONLY.

Thanks,

Ajay.

Abhishek Bagh

HI @AjayKumar Maddipati -

Thanks for your response. Helpful.

I was however looking for Legal Seniority & Legal Hire Date. I have Enterprise Seniority/ Hire Date in my report already but would like to add the Legal ones too. Can you suggest on the above please?

Regards, Abhishek

Hazel De Castro

Any update on this?

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders

User_DL0BA 65

LukeHRIS 30

Sahana Sakkarapani 15

Val S 15

Navyashree 15