PRC: Generate Draft Revenue Is Failing: ORA-00001: unique constraint (PA.PA_DRAFT_REVENUE_ITEMS_U1) violated (Doc ID 2305332.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

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

Symptoms

Error when running PRC: Generate Draft Revenue for transactions where there have been adjustments made on all 3 comprising of transfers and recalculations prior to revenue generation.

The revenue generation process errors out with the following:
ERROR:
    ORA-00001: unique constraint (PA.PA_DRAFT_REVENUE_ITEMS_U1) violated

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