HRSD

[garimakharb]

When I submit a Leave of Absence request through the Record Producer, a case gets created in the sn_hr_core_case_total_rewards table, but no corresponding record appears in the sn_hr_core_leave_of_absence table or under the HR Profile’s ‘Leaves of Absence’ related list. Why isn’t the Leave of Absence record getting created, and what configuration is missing or needs to be enabled to make it work end-to-end? And also I want to know the relations of tables and the flow of LOA table.

[YaswanthKurre]

Hi @garimakharb ,

The Record Producer may be configured to create only an HR Case (sn_hr_core_case_total_rewards) and not a corresponding LOA record.

• You need to ensure the HR Service tied to the Record Producer has logic (via Script) to also create a record in sn_hr_core_leave_of_absence.
• This is often handled by a Flow tied to the HR Service or a Script Include like hr_ServicesUtil.createCaseFromProducer().

Mark this as helpful/correct, if this helps you.

thanks,

Yaswanth

[Ankur Bawiskar]

@garimakharb 

May be the HR Service and Record Producer should point to "sn_hr_core_leave_of_absence" table

Once you do that records will start getting created in that table.

Then the related list data will also start showing correct info.

share some screenshots.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏