Forum Stats

  • 3,836,735 Users
  • 2,262,175 Discussions
  • 7,900,088 Comments

Discussions

Unable to view data in PER_CONTRACTS_F

4173366
4173366 Member Posts: 3 Green Ribbon
edited May 19, 2020 12:50AM in HCM Cloud Service

Hi All

I'm working on a report that requires me to display a person contract type and contract end date.

Navigation : Peron Management > Search > Contract

From research I see that the underlying table for these fields is PER_CONTRACTS_F ( column TYPE and EFFECTIVE_END_DATE ).

But when i query this table using a simple data model, I don't see any data at all. Wondering if there's any role that I need to view this table ?

I appreciate any inputs on this topic!

Using Oracle Cloud Application 20A (11.13.20.01.0).

pastedImage_3.png

Thanks

Kini

Answers