My Oracle Support Banner

R11 PARGDR: Performance Issue with PRC: Generate Draft Revenue For Both a Range and Single Projects (Doc ID 1546849.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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

Symptoms

Performance issue when running the PRC: Generate Draft Revenues for a Single and Range of Projects. The following query is the most expensive:

update pa_events ev set ev.revenue_distributed_flag='A',ev.last_update_date=
 sysdate
where
(ev.revenue_distributed_flag='D' and exists (select null from
 pa_draft_revenues dr ,pa_cust_event_rev_dist_lines l where
 ((((((l.project_id=ev.project_id and nvl(l.task_id,(-1))=nvl(ev.task_id,(-1)
 )) and l.event_num=ev.event_num) and l.request_id=:b0) and dr.project_id=
 :b1) and dr.request_id=:b0) and dr.transfer_rejection_reason='ABNORMAL
 TERMINATION')))

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.