Unable To Cancel Rejected or Incomplete Purchase Orders (POs) - Error Message: Unexpected Error Encountered: ORA-01400 (Doc ID 2128715.1)

Last updated on JUNE 24, 2016

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms


Edit Purchase Order

When you attempt to cancel a purchase order that is at status Rejected or Incomplete, an error message is returned:
Unexpected Error Encountered: ORA-01400: cannot insert NULL into ("FUSION"."CMR_PO_EVENTS"."EVENT_DATE").

Steps to reproduce the issue:
1. Go to Manage Orders
2. Search for purchase order that is at status Incomplete or Rejected
3. Edit Order, attempt to cancel the purchase order
Notice that an error message is displayed:
Unexpected Error Encountered: ORA-01400: cannot insert NULL into ("FUSION"."CMR_PO_EVENTS"."EVENT_DATE").

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms