1. Securing HCM
  2. Tables and Views in Custom Criteria

Tables and Views in Custom Criteria

You can secure access to person records using custom criteria in the form of SQL predicates. You shouldn’t use some tables and views in custom SQL statements. They might cause runtime errors, with error message containing the text ORA28113: POLICY PREDICATE HAS ERROR.

This table identifies tables and views that you must not include in custom SQL statements when securing access to person records.

Product

Table or View

Contracts

  • OKC_EMPLOYEE_CONTACT_V

  • OKC_SEARCH_EMPLOYEE_V

  • OKC_SEARCH_INT_CONTACTS_V

  • OKC_SIGNER_CONTACTS_V

Financials for EMEA

  • JE_RU_FA_EMPLOYEE_V

General Ledger

  • GL_HIERVIEW_PERSON_INFO_V

Global Human Resources

  • HR_BU_LOCATIONS_X

  • HR_LOCATIONS

  • HR_LOCATIONS_ALL

  • HR_LOCATIONS_ALL_F

  • HR_LOCATIONS_ALL_F_VL

  • HR_LOCATIONS_ALL_VL

  • HR_LOCATIONS_ALL_X

  • PER_ADDRESSES_F

  • PER_ADDRESSES_FU_SEC

  • PER_ADDRESSES_F_

  • PER_ADDRESSES_F_SEC

  • PER_CONT_WORKERS_CURRENT_X

  • PER_CONT_WORKERS_X

  • PER_DISPLAY_PHONES_V

  • PER_DRIVERS_LICENSES

  • PER_DRIVERS_LICENSESU_SEC

  • PER_DRIVERS_LICENSES_

  • PER_DRIVERS_LICENSES_SEC

  • PER_EMAIL_ADDRESSES

  • PER_EMAIL_ADDRESSESU_SEC

  • PER_EMAIL_ADDRESSES_

  • PER_EMAIL_ADDRESSES_SEC

  • PER_EMAIL_ADDRESSES_V

  • PER_EMPLOYEES_CURRENT_X

  • PER_EMPLOYEES_X

  • PER_LOC_OTHER_ADDRESSES_V

  • PER_NATIONAL_IDENTIFIERS

  • PER_NATIONAL_IDENTIFIERSU_SEC

  • PER_NATIONAL_IDENTIFIERS_

  • PER_NATIONAL_IDENTIFIERS_SEC

  • PER_NATIONAL_IDENTIFIERS_V

  • PER_PASSPORTS

  • PER_PASSPORTSU_SEC

  • PER_PASSPORTS_

  • PER_PASSPORTS_SEC

  • PER_PERSON_ADDRESSES_V

  • PER_PHONES

  • PER_PHONESU_SEC

  • PER_PHONES_

  • PER_PHONES_SEC

  • PER_PHONES_V

  • PER_VISAS_PERMITS_F

  • PER_VISAS_PERMITS_FU_SEC

  • PER_VISAS_PERMITS_F_SEC

  • PER_WORKFORCE_CURRENT_X

  • PER_WORKFORCE_X

Global Payroll

  • PAY_AMER_W4_LOC_ADDRESS_V

  • PAY_AMER_W4_PERSON_ADDRESS_V

Grants Management

  • GMS_ALL_CONTACTS_V

  • GMS_INTERNAL_CONTACTS_V

Payments

  • IBY_EXT_FD_EMP_HOME_ADDR

Planning Common Components

  • MSC_AP_INTERNAL_LOCATIONS_V

Profile Management

  • HRT_PERSONS_D

  • HRT_PERSONS_X

Project Foundation

  • PJF_PROJ_ALL_MEMBERS_V

  • PRJ_PROJECT_MANAGER_V

  • PRJ_TEAM_MEMBERS_F_V

Workforce Reputation Management

  • HWR_VLTR_REGN_RGSTR_VL

  • HWR_VLTR_REGN_TOTAL_VL

For more information about tables and views, see the Tables and Views for Oracle HCM Cloud guide.

Related Topics