PAIGEN - Performance Issue Running the PRC: Generate Draft Invoices Process

(Doc ID 1571386.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance 16-Oct-2014 ***

Symptoms

On : 12.1.3 version, Billing Setup

ACTUAL BEHAVIOR
---------------
Running the  PAIGEN -PRC: Generate Draft Invoices process encounters slow performance.  The most expensive query is:

 

SELECT CONCURRENT_PROGRAM_ID,PROGRAM_APPLICATION_ID,PRINTER,
 PROGRAM_SHORT_NAME,ARGUMENT_TEXT,PRINT_STYLE,USER_PRINT_STYLE,
 SAVE_OUTPUT_FLAG,ROW_ID,ACTUAL_COMPLETION_DATE,COMPLETION_TEXT,
 PARENT_REQUEST_ID,REQUEST_TYPE,FCP_PRINTER,FCP_PRINT_STYLE,
 FCP_REQUIRED_STYLE,LAST_UPDATE_DATE,LAST_UPDATED_BY,REQUESTED_BY,
 HAS_SUB_REQUEST,IS_SUB_REQUEST,UPDATE_PROTECTED,QUEUE_METHOD_CODE,
 RESPONSIBILITY_APPLICATION_ID,RESPONSIBILITY_ID,CONTROLLING_MANAGER,
 LAST_UPDATE_LOGIN,PRIORITY_REQUEST_ID,ENABLED,REQUESTED_START_DATE,
 PHASE_CODE,HOLD_FLAG,STATUS_CODE,REQUEST_ID,PROGRAM,REQUESTOR,PRIORITY
FROM
FND_CONC_REQ_SUMMARY_V WHERE (DECODE(IMPLICIT_CODE, 'N', STATUS_CODE,'E',
 'E', 'W', 'G') = STATUS_CODE OR DECODE(IMPLICIT_CODE, 'W', 'E') =
 STATUS_CODE) and (nvl(request_type, 'X') != 'S' ) and (request_date >=
 trunc(sysdate-:1)) and (requested_by = :2)  order by REQUEST_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