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

Last updated on JUNE 03, 2024

Applies to:

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

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