Home/ Questions/Q 83126
In Process

Oraask Latest Questions

Question
Saly
  • 1
  • 1
Explorer
Asked: 2025-05-28T07:20:50+03:00 In:

What is the difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F in Oracle Fusion

  • 1
  • 1

I am currently working with Oracle Human Resources Management System (HRMS) and came across two tables: PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F.

I understand that both tables are related to employee assignments, but I am not clear on the specific differences between them.

Could someone explain the distinctions in terms of their structure, usage, and the type of data they store? Any insights or examples would be greatly appreciated.

Share

    Related Questions

    1 Answer

    1. Hassan AbdElrahman
      Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

      The PER_ALL_ASSIGNMENTS_M is the core table for assignment-related data in the Oracle HCM Cloud.

      The PER_ALL_ASSIGNMENTS_F view is essentially a filtered version of this table, defined as:

      SELECT *
FROM per_all_assignments_m paam
WHERE effective_latest_change = 'Y';

      This means:

      If you’re looking to retrieve all assignment records, regardless of their current status, you should query the PER_ALL_ASSIGNMENTS_M table directly.
      If you’re only interested in the most recent effective changes to assignments, then the PER_ALL_ASSIGNMENTS_F view is the appropriate choice, as it returns only the latest effective rows.

      Source: Doc ID 2096539.1

    Leave an answer

    You must login to add an answer.

    Need An Account,