R12 Slow Performance For PRC: GENERATE DRAFT INVOICE (Doc ID 1567397.1)

Last updated on SEPTEMBER 07, 2015

Applies to:

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

Symptoms

Generate Draft Invoice process has a performance issue with this SQL:

SELECT P.OUTPUT_TAX_CODE, P.RETENTION_TAX_CODE
FROM
 ZX_OUTPUT_CLASSIFICATIONS_V L, PA_PROJECTS P WHERE P.PROJECT_ID = :B4 AND
  L.LOOKUP_CODE = DECODE(:B3 ,'TRUE',P.RETENTION_TAX_CODE,P.OUTPUT_TAX_CODE)
  AND L.ORG_ID IN (:B2 , -99) AND L.ENABLED_FLAG = 'Y' AND
  (L.START_DATE_ACTIVE   (L.END_DATE_ACTIVE >= :B1 OR L.END_DATE_ACTIVE IS NULL) AND ROWNUM = 1
  ORDER BY L.ORG_ID DESC

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