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 AUGUST 01, 2016

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance 23-Dec-2013 ***

PA_RESOURCE_ASGN_CURR


Symptoms

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.

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