My Oracle Support Banner

OKEKAUWB: Performance Issue While Saving a Project Contract Line When it is Updated With a Change (Doc ID 3063481.1)

Last updated on DECEMBER 16, 2024

Applies to:

Oracle Project Contracts - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Saving a project contract line (CLIN) is taking 30 minutes after the change is made on the contract line.  The problem statement per the trace is:

SELECT PPEVS.ELEMENT_VERSION_ID
FROM
PA_PROJ_ELEMENTS PPE, PA_PROJ_STRUCTURE_TYPES PPST, PA_STRUCTURE_TYPES PST,
PA_PROJ_ELEM_VER_STRUCTURE PPEVS WHERE PPE.PROJECT_ID = :B1 AND
PPE.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID AND PPE.PROJECT_ID =
PPEVS.PROJECT_ID AND PPE.PROJ_ELEMENT_ID = PPEVS.PROJ_ELEMENT_ID AND
PPEVS.STATUS_CODE = 'STRUCTURE_PUBLISHED' AND NVL(PPEVS.BASELINE_FLAG,'N')
<>'Y' AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID AND (
PPEVS.PROCESS_CODE IS NULL OR PPEVS.PROCESS_CODE = 'PRE') AND
PST.STRUCTURE_TYPE_CLASS_CODE = 'FINANCIAL' ORDER BY PPEVS.PUBLISHED_DATE
DESC

The AWR also shows the following as an issue:

SELECT 'x'
FROM
( SELECT P.PROJECT_ID PID,P.SEGMENT1 FROM PA_PROJECTS_ALL P WHERE
P.PROJECT_ID IN (SELECT TO_NUMBER(SUB_PROJECT_ID) PROJECT_ID FROM
PA_FIN_STRUCTURES_LINKS_V START WITH PARENT_PROJECT_ID = :B1 AND
PARENT_TASK_ID IN (SELECT TASK_ID FROM PA_TASKS WHERE PROJECT_ID=:B1 AND
TOP_TASK_ID=NVL(:B2 ,TOP_TASK_ID) ) CONNECT BY PARENT_PROJECT_ID = PRIOR
SUB_PROJECT_ID) UNION SELECT PROJECT_ID PID,SEGMENT1 FROM PA_PROJECTS_ALL
WHERE PROJECT_ID = :B1 ) WHERE PID = :B3

Steps to Reproduce:

1.  Oracle Contracts Super User
2.  Query a contract
3.  Go to Change Management
4.  Enter a change to implement
5.  Now go to Contract line | Go to other drop-down list and make change on the attribute.
6.  Save the change and see the performance issue. 

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
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.