My Oracle Support Banner

R12: ORA-01400 When Trying to Create a Budget Version in PAXBUEBU or Self-Service (Doc ID 1073598.1)

Last updated on FEBRUARY 14, 2019

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
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

To view full details, 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 a vibrant support community of peers and Oracle experts.