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?

Top Leaders

Top Posts

Session Variables for Use in Activity Center Visualizations
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
Recruiting Real Time and Real Time Events
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
OTBI Report - need to fetch the Worker Historic information
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
26C Deprecated BI View Objects
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
Where are the work order notes?
Hi team, I would like to add the work order notes to my work order schedule calendar, but I'm unable to find where these notes are stored and what otbi subject to use to access them. Be great if I can be pointed in the right direction, thanks