12.1.2 ORA-01400 When Trying to Create a Budget Version in PAXBUEBU or Self-Service

(Doc ID 1073598.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.2 to 12.1.2 [Release 12.1]
Information in this document applies to any platform.
PAXBUEBU
ORA-01400
***Checked for relevance on 10-Sep-2012***
APP-PA-19973

Symptoms

While trying to enter Budget in R12 Budget form (PAXBUEBU) for any budget type there is the following error:

APP-PA-19973: Encountered Oracle error -1400. Refer to Oracle server messages and codes manual. Report to Oracle Worldwide Support with the diagnostic information: stage PA_BU_CORE_NO_VERSION_ID and stack --> get_draft_version_id --> create_draft --> get_baselined_version_id --> get_draft_version_id.


In Self- Service (Budgeting and Forecasting tab), when trying to create a budget or forecast version, the error is:

ORA-01400: cannot insert NULL into ("PA"."PA_BUDGET_VERSIONS"."PROJECT_STRUCTURE_VERSION_ID") in Package PA_FP_BUDGET_VERSIONS_PKG.Insert_Row Procedure Create_Version
ORA-01400: cannot insert NULL into ("PA"."PA_BUDGET_VERSIONS"."PROJECT_STRUCTURE_VERSION_ID") in Package PA_FIN_PLAN_PUB Procedure CREATE_VERSION

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