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

Last updated on MARCH 08, 2017

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')))

Cause

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