R12 - ORA-01400: cannot insert NULL into ("PA"."PA_RESOURCE_ASGN_CURR"."EXPENDITURE_TYPE") when using Budgeting and Forecasting or Workplan functionality

(Doc ID 1278680.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.


When trying to baseline funding or assign a planning resource to a Workplan task, the following error appears:

ORA-01400: cannot insert NULL into ("PA"."PA_RESOURCE_ASGN_CURR"."EXPENDITURE_TYPE").

It is normally accompanied with many other errors which may be different in other screens but the ORA-01400 is always there.


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