My Oracle Support Banner

PA_EVENT_NO_REV_CAN_INV_AMG: Getting Error While Updating Event From API PA_EVENT_PUB.UPDATE_EVENT (Doc ID 2742010.1)

Last updated on MARCH 21, 2021

Applies to:

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

Symptoms

When attempting to update event using API PA_EVENT_PUB.UPDATE_EVENT,
the following error occurs.

ERROR
-----------------------
The event ID is not revenue distributed and cancelled invoice against this event exists. Updates are allowed only to the event date, organization, description, bill hold, bill amount, bill group, revenue hold, and revenue amount fields


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect to SQL Plus
2. Execute API PA_EVENT_PUB.UPDATE_EVENT.
3. Review Output file of the script, It will show error message.

The event ID is not revenue distributed and cancelled invoice against this event exists. Updates are allowed only to the event date, organization, description, bill hold, bill amount, bill group, revenue hold, and revenue amount fields.

Note: Above error message is mapped to error code PA_EVENT_NO_REV_CAN_INV_AMG

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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