Core Forms - Even Though Assignment Data Is Present In The per_all_assignments_f Table, the Assignment Form Shows Blank For Certain Datetrack Dates. (Doc ID 3020193.1)

Last updated on MAY 28, 2024

Applies to:

Symptoms

Assignment form is blank for certain Datetrack dates.

Steps to Reproduce the Issue:

1. Navigate to 'XX Super HRMS Manager' responsibility -> People -> Enter and Maintain
2. In the People form, (Datetrack to today's date) query the Employee.
3. Click on Assignment button, shows Assignment Details.
4. Close the Assignment form.
5. Go back to People form, Datetrack to a date when supervisor was changed for the employee (Example: 02-Feb-2024) and query the employee.
6. Click on Assignment button.
7. Assignment form does not show Assignment record details (like Organization, Job, Location, Position, Grade etc.). It shows blank assignment form.
 
Note: The assignment related data (like Organization, Job, Location, Position, Grade etc.) is present in per_all_assignments_f table on the day where the assignment form shows blank assignment form for the employee.

Example:

Asg ID  Asg_Number Eff_Start_Dt      Effe_End_Dt     Primary Asg Seq Asg  Type(Type ID)     Asg Status              PO Serv-ID  BG ID  Supervisor_Id   OVN
100             49       01-Jan-2024      01-Feb-2024    Y                  1        Employee (1)      Active Assignment        98          80      200                  6
100             49       02-Feb-2024     01-Mar-2024    Y                  1        Employee (1)      Active Assignment        98          80      300                  7    ===> The data is present in the table, still this record is not showing in Assignment form.
100             49       02-Mar-2024     31-Dec-4712    Y                  1        Employee (1)      Active Assignment        98          80      300                  8

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.