HCM Data Loader fails to import resource assignments in resource management with FBDI template errors

ERP Oracle Fusion Cloud
, , , , , , , ,
1

We’re trying to onboard 200+ contractors using HCM Data Loader for resource assignments in our 23b instance, but the import keeps failing with validation errors. The same FBDI template worked fine in our previous quarterly update.

Error from HDL import:


ERROR: Invalid value for ProjectId
ERROR: ResourceOrganizationId is required
Row 45: Assignment validation failed

We’re using the ResourceAssignment.dat file format that’s documented in the 23a template guide. Did Oracle change the HDL template structure or field requirements in 23b? Our IT team suspects the quarterly patch modified validation rules but we can’t find clear documentation on what changed.

2

Thanks, I’ll try the project number approach. But I’m confused about ResourceOrganizationId - our contractors aren’t tied to specific business units, they’re cross-functional resources. What value should we use for them?

3

I downloaded the 23b template and noticed several new required fields. Running a test import now with updated mappings.

4

Also check your ProjectId values. In 23b, Oracle changed how project references work in HDL imports. You now need to use the project number instead of the internal project ID for cross-module imports. This was part of the data integrity improvements in the quarterly update. Try using PROJECT_NUMBER field instead of PROJECT_ID in your template.