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