Getting ORA-01400: cannot insert NULL While Running Planning Autoschedule Request
(Doc ID 1373085.1)
Last updated on SEPTEMBER 20, 2023
Applies to:Oracle Supplier Scheduling - Version 22.214.171.124 and later
Information in this document applies to any platform.
Executable:AUTO SCHEDULE PLANNING - Auto Schedule Planning
Form:WPSWKBCH.FMB - Scheduler Workbench
When attempting to run Planning Auto Schedule request, the following error occurs.
ERROR at line 1:
ORA-01400: cannot insert NULL into ("PO"."CHV_ITEM_ORDERS"."PURCHASING_UNIT_OF_MEASURE")
ORA-06512: at "APPS.CHV_BUILD_SCHEDULES", line 1206
ORA-06512: at line 1
Due to this issue, users cannot send the Schedules to Supplier who is accessing iSupplier portal.
Steps to reproduce:
1. Responsibility: Supplier Scheduling
2. Run the Push Plan Information in destination instance
3. Run the Planning Auto schedule request
Request completes with error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document