ORA-01400: cannot insert NULL into CST_PREP_ERRORS_GT.ERROR_CODE

Q: How do I fix "ORA-01400: cannot insert NULL into CST_PREP_ERRORS_GT.ERROR_CODE" in Oracle Fusion?

1. Run the first SQL to list the item ids costing can't validate 2. Convert ids to item numbers with the second SQL 3. In Product Information Management, assign those items to the validation organization 4. Rerun the processor, the crash disappears with the data gap

Error code: ORA-01400

The processor crashed while preparing its batch, and the real cause hides one level deeper: some items in the batch aren't assigned to the cost org's ITEM VALIDATION ORGANIZATION. This usually happens when the validation org configured in costing isn't the same as the item master org, so some items simply don't exist where costing goes to look them up.

Root cause

Items in the batch are missing from the cost org's validation org (validation org ≠ item master org).

How to fix it

Run the first SQL to list the item ids costing can't validate
Convert ids to item numbers with the second SQL
In Product Information Management, assign those items to the validation organization
Rerun the processor, the crash disappears with the data gap

Where to go in Fusion

Product Information Management → Manage Items → assign items to the validation org
Setup and Maintenance, search tasks: Manage Cost Organization Relationships (to see which org IS the validation org)
Cost Accounting work area, Create Cost Accounting Distributions (the cost processor)

Diagnostic SQL

Items missing from the validation org

select distinct inventory_item_id from cst_inv_transactions cit where not exists (select 1 from egp_system_items_b it where it.inventory_item_id = cit.inventory_item_id and it.organization_id in (select validation_organization_id from cst_cost_org_parameters where cost_org_id in (select organization_id from hr_organization_units_f_tl where name = '&cost_org_name')))

Item number from item id

select item_number, organization_id from egp_system_items_b where inventory_item_id = &item_id

Read-only diagnostic queries. Substitute the bind values for your instance; run in a test environment first.

Oracle references

My Oracle Support document IDs for readers with access: 2201301.1. We do not reproduce their content.

Checked Cost processor behavior for Oracle Fusion Cost Management, rewritten in plain words from publicly known troubleshooting practice and reviewed by a working consultant. Checked against the current release, Jul 2026. Amounts, account names and navigation vary by configuration; verify in your own instance and test before acting.

Solve it, then prevent it

This page explains one error. These help with the rest:

🔧Search any cost processor errorThe interactive triage: paste your error, get the card.→🧾The setup behind these errorsThe Cost Management implementation guide.→✅Close without surprisesThe dependency-ordered SCM period close checklist.→

More cost processor errors