Error message states “Invalid Calendar ID reference” even though the calendar exists in our setup. I’ve verified the calendar ID mapping in our Schedule Management setup and confirmed CAL-CORP-2024 is configured correctly. The validation rules seem stricter than documented.
Has anyone encountered this during schedule management data imports? Our calendar structure includes multiple enterprise calendars with different working day patterns, and we need to map about 250 schedules correctly. This is blocking our go-live timeline.
Maria’s right about the ID format. Also verify your calendar is published and active in the target environment. I had a similar issue where calendars were in draft status. Another thing - if you’re using enterprise calendars, make sure the calendar assignment scope matches your schedule’s organizational context. The validation checks calendar accessibility based on the schedule’s business unit or legal entity assignment.
Thanks both. I checked and our calendars are published. How do I find the system-generated calendar ID? The setup UI only shows our custom codes. Is there a specific report or query I should run?
Another consideration: pre-validate your calendar references before the main import. I built a validation step that queries the calendar setup tables to confirm each calendar ID exists and is accessible. This catches mapping issues early. The validation SQL checks both calendar existence and organizational assignment compatibility. Saved us hours of troubleshooting during our manufacturing schedule migration.
The calendar ID mapping issue you’re experiencing stems from how Oracle Fusion handles calendar references in FBDI imports versus the UI display values. Let me walk through the complete resolution addressing all three critical aspects.
Calendar ID Mapping Resolution:
The calendar identifier in FBDI must use the internal calendar code, not the display name. Run this extraction to get correct mappings:
Navigate: Schedule Management > Extract Calendar Data
Parameters: All Active Calendars
Output Format: CSV
The extracted file shows CalendarCode field - use this value in your FBDI template. For CAL-CORP-2024, the actual code might be something like ENT_CAL_1234.
Schedule Management Setup Validation:
Ensure your calendar assignments align with schedule organizational contexts:
Verify calendar scope matches schedule business unit assignments
Check calendar is assigned to correct manufacturing plants or organizations
Confirm calendar effective dates cover your schedule periods
Validate calendar working day patterns are complete (no gaps in date ranges)
In 23c specifically, hierarchical calendar structures require parent calendar references to be loaded before child schedules.
Data Import Validation Enhancement:
Implement a pre-import validation process:
For your 250 schedules, create a staging validation query that cross-references your import file against extracted calendar data. This identifies all mapping mismatches before attempting the actual import. The validation should flag: invalid calendar codes, organizational scope mismatches, and inactive/expired calendars.
One critical gotcha in 23c: if using calendar groups, reference the group calendar code, not individual member calendars. The FBDI validator enforces stricter referential integrity than earlier versions.
After correcting your calendar ID mappings, re-run the import with validation mode first (set Import Process parameter to Validate Only). This confirms all references resolve correctly before committing data.
Use the “Extract Calendar Data” scheduled process under Schedule Management. This gives you the exact calendar identifiers used internally. Alternatively, create one test schedule manually in the UI, then extract it via FBDI export. The exported file will show the correct calendar ID format. In 23c, I’ve noticed calendar references sometimes require the full hierarchical path if you’re using calendar groups.