My Oracle Support Banner

Fee Events Created, But Not Revenue Generated (Doc ID 2911865.1)

Last updated on JUNE 03, 2024

Applies to:

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

Symptoms

There are differences between Net Revenue and Invoice Amount fields in the Agreements screen.  After further research, found that the differences are with the events in the PA_EVENTS table with the REVENUE_DISTRIBUTED_FLAG=Y (Yes).  But, the events have not been revenue generated as there are no associated records in the PA_CUST_EVENT_RDL_ALL table, and also no related records in the PA_DRAFT_REVENUE_ITEMS table.  These events have been invoice generated.  Note that the example project has other revenue Fee events created and revenue generated successfully.

Replication steps:

1. Navigate to > Projects responsibility > Billing > Agreements. 

2. In the Agreements screen, query the Agreement that is associated with the problem project.

3. Note the amounts in the Net Revenue and Invoice Amount fields.  Note that the amounts do not match.

4. Query the events in the PA_EVENTS table.  Use the query,

select * from pa_events where project_id = &project_id;

Compare the events in the PA_EVENTS table to see what has been revenue distributed and not revenue distributed in the PA_CUST_EVENT_RDL_ALL.

If the above is not feasible to perform, run the following query to find out what events have not been revenue distributed.

SELECT PA.NAME, PA.PROJECT_ID, PE.*
FROM PA_EVENTS PE,
PA_PROJECTS_ALL PA
WHERE PA.PROJECT_ID = PE.PROJECT_ID
AND PE.REVENUE_DISTRIBUTED_FLAG = 'Y'
AND PE.REVENUE_AMOUNT <> 0
AND NOT EXISTS (
SELECT 1
FROM PA_CUST_EVENT_RDL_ALL CERDL
WHERE CERDL.EVENT_NUM = PE.EVENT_NUM
AND PE.PROJECT_ID = CERDL.PROJECT_ID)



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
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.