How To Create Revenue Event By Agreement Number? (Doc ID 1623291.1)

Last updated on JANUARY 02, 2017

Applies to:

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

Goal

Users are trying to Create Revenue Event By Agreement Number automatically using PA_EVENT_PUB API, but pa_billing_pub.insert_event does not have an option to enter Agreement Number.

Checking the PA_EVENTS table, the AGREEMENT_ID column is available.  Then why is this not available in the API to create Agreement number in Revenue Events?

 

The following note was identified:

API to Create Revenue Event By Agreement Number (Doc ID 1448153.1)
Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
GOAL

Customer is trying to create a revenue event by agreement for the Billing Extension.

PA_BILLING_PUB.Insert_Event does not have the option to insert an agreement number.
pa_event_pub.create_event does not work when passing an agreement number.

Is this functionality available?

SOLUTION

The insert_event is used by the billing extension and the create_event is the API to use for standalone creation of events. There is not an option to create an event with an agreement number using these APIs.

Per Development in <Bug 9196863>: GSI: PUBLIC API, PA_EVENT_PUB.CREATE_EVENT, DOES NOT STORE AGREEMENT NUMBER

The feature of Date-Effective Funds Consumption and ability to update agreement ID on the event is not supported in 12.1+ through API. It is only available via forms (front end).

In Projects, navigate to Projects and review Billing information to be sure that Date-Effective Funds Consumption is checked.

Then in Projects, navigate to the Events form, go to Projects: Billing/Events/(Project or All). The Agreement Number can be modified here.

 

Solution

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