Trying to create leave allocation based on a field in hr.employee model. @api.onchange('confirm_date')
def _onchange_confirm_date(self):
if self.confirm_date:
# Create sick leave allocation
self.env['hr.leave.allocation'].create({
'name': 'Automatic Sick Leave Allocation',
# 'holiday_status_id':
self.env.ref('hr_holidays.holiday_status_sl').id,
'holiday_status_id': 1,
'holiday_type': 'employee',
# 'employee_ids': [(4, self.id)],
'employee_ids': 20,
'employee_company_id': 1,
'department_id': 3,
'number_of_days': 15.0,
'state': 'draft',
'allocation_type': 'regular',
'date_from': '2024-01-21',
'date_to': '2024-12-21',
}) it's giving me the validation error: The employee, department, company or employee category of this request is missing. Please make sure that your user login is linked to an employee.
Here is the sql constraints causing the error:
_sql_constraints = [
('type_value',
"CHECK( (holiday_type='employee' AND (employee_id IS NOT NULL OR multi_employee IS TRUE)) or "
"(holiday_type='category' AND category_id IS NOT NULL) or "
"(holiday_type='department' AND department_id IS NOT NULL) or " "(holiday_type='company' AND mode_company_id IS NOT NULL))",
"The employee, department, company or employee category of this request is missing. Please make sure that your user login is linked to an employee."),
('duration_check', "CHECK( ( number_of_days > 0 AND allocation_type='regular') or (allocation_type != 'regular'))", "The duration must be greater than 0."),
] what am i doing wrong here?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
Hi,
The error message indicates that the employee, department, company, or
employee category is missing from your leave allocation record. This is
due to the SQL constraint in the hr. leave. allocation model.
@api.onchange('confirm_date') |
Following
my assumptions about your HR model structure, I've added the employee,
company, and department information in this example. Based on your real
model structure and requirements, modify the fields as necessary. To
meet the SQL requirements, make sure the values you're entering for each
field are legitimate.
Hope it helps
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Jan 23
|
10152 | ||
|
2
Aug 25
|
31590 | ||
|
0
Dec 19
|
4087 | ||
|
1
Aug 19
|
4656 | ||
|
1
Oct 18
|
8650 |