Oracle HCM Absence Orphan Records


Sometimes We come across a less known Error while submitting an Absence in Oracle Cloud HCM with an Error Code ANC-3405194



Likely caused when Update of Accrual plan is done after an accrual process has already run till a date in future. OR Entering accrual via HDL in a previous plan period and missing to run calculate accrual.

This is Resolved when we Delete the Orphaned records found by Below Query

Query to identify the Orphan Absence Records in the System

SELECT  per_accrual_entry_dtl_id,

        ppl.person_number       ,
        ass.assignment_number   ,
        plans_tl.NAME           ,
        TYPE                    ,
        procd_date
FROM    fusion.anc_per_acrl_entry_dtls acrl_dtls ,
        fusion.per_all_people_f ppl              ,
        fusion.per_all_assignments_m ass         ,
        fusion.anc_absence_plans_f_tl plans_tl
WHERE   acrl_dtls.person_id = ppl.person_id
        AND acrl_dtls.procd_date BETWEEN ppl.effective_start_date AND ppl.effective_end_date
        AND acrl_dtls.work_term_asg_id = ass.assignment_id
        AND ass.assignment_type        = 'ET'
        AND acrl_dtls.procd_date BETWEEN ass.effective_start_date AND ass.effective_end_date
        AND plans_tl.absence_plan_id = acrl_dtls.pl_id
        AND acrl_dtls.procd_date BETWEEN plans_tl.effective_start_date AND plans_tl.effective_end_date
        AND plans_tl.language = 'US'
        AND TYPE              ='ORA_ANC_FORFT_REST'
        AND NOT EXISTS
        (
                SELECT  per_accrual_entry_id
                FROM    fusion.anc_per_accrual_entries acrl_ent
                WHERE   acrl_ent.per_accrual_entry_id = acrl_dtls.per_accrual_entry_id
        )

Comments

Post a Comment

Popular posts from this blog

Oracle Cloud HCM Open Ended Absences Update

  Oracle Cloud HCM Open Ended Absences       In Oracle Cloud HCM, when there exist open ended absences like Maternity and Sickness and Employee is terminated, it is seen that there is no end date updated to these open absences as of Termination Date. This leads to ambiguity in reporting and payroll To address this issue, worked on an automation process which will pick such records and put an end date same as the termination date.   Design Steps   1.       Build a BIP report to list the Open ended absences for Terminated employees 2.      Write the Bursting definition to feed the BIP report output to Extract 3.      Desing the ETF template to build the HDL Template for End dating Open Absence 4.      Design a HCM Extract that will take the output fed from BIP Report and Auto Loads as   HDL process 5.   ...
Read more
Image
           Deploying an AI agent on Redwood Page                                    1.     N avigate to the AI Agent Studio from the Tools Menu             2.    Select any available delivered AI agent and Copy it to be used by    your business.                         3.     Run it to see all the Profiles and Config are good.         4.     Publish the AI Agent              5.       Navigate to My Client Groups -> Guided Journeys      6.       Create New Journey      7.       Create Draf...
Read more