getting the error when i am trying to change the Assignment Category field of employee
I am facing similar issue as describe in below bug, I am trying to change the assignment category from assignment screen for an employee and getting error as-
FRM-40735 POST- UPDATE trigger raised unhandled exception ORA- 01403
document: from the note I found Doc ID 1626879.1
and checked the data in from the query mentioned in document-
For each impacted assignment run below query
select * from pay_object_groups where (SOURCE_ID in (select person_id from
per_all_assignments_f where assignment_id = &ass_id1) and SOURCE_TYPE = 'PPF')
or
(SOURCE_ID = &ass_id1 and SOURCE_TYPE = 'PPF')
this query returns nothing for me, can you please help in getting the issue resolved.