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

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…

Top Leaders