My Oracle Support Banner

R12.PA: API PA_FP_SPREAD_AMTS_PKG: Encountering Error: ORA-00001: Unique Constraint (PA.PA_BUDGET_LINES_U1) Violated in API PA_FP_SPREAD_AMTS_PKG (Doc ID 2931884.1)

Last updated on APRIL 11, 2024

Applies to:

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


While executing the Standard API PA_FP_SPREAD_AMTS_PKG from the database, the error log reports the occurrence of the following error:


The issue can be reproduced at will with the following steps:
1. Connect to the SQL Developer/toad
2. Execute the API : PA_FP_SPREAD_AMTS_PKG to generate the Project Forecast version
3. Review the error log


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.