Oracle Transactional Business Intelligence

Products Banner

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

Received Response
79
Views
2
Comments

Answers

  • 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.

  • 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