My Oracle Support Banner

Unable To Update Bill Amount Using PA_EVENT_PUB.UPDATE_EVENT After Event Is Billed And Cancelled (Doc ID 2161245.1)

Last updated on JULY 08, 2020

Applies to:

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


On : 12.1.3 version, Revenue

Unable to Update Bill Amount using PA_EVENT_PUB.UPDATE_EVENT after Event is Billed, and Cancelled getting following error

"You can update the event date, organization, description, bill hold, and bill amount for this event because a canceled invoice for it exists."

Following is the  Scenario:
Distribution Rule in EVENT/EVENT
Event Bill Amount = 2000
Revenue Amount = 2000
Generated invoice and Revenue based on above and the invoice is interfaced to AR, now  cancelled the Invoice from Projects Invoice Review form.
This releases the Event#1 (i.e PA_EVENTS.BILLED_FLAG is now N after cancelling the invoice generated from this Event#1)
Now trying to update the Event Bill amount using PA_EVENT_PUB.UPDATE_EVENT and it is not allowing  to update the Event. How ever from the standard form it is allowing to update Bill Amount.




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.