PAXINEAG: It Takes Over a Minute To Select a Task in the Agreement Project Funding Form (Doc ID 3059058.1)

Last updated on NOVEMBER 15, 2024

Applies to:

Symptoms

There is a performance issue when adding funding to an agreement.

After entering a project and task number and leaving the task field, it takes over a minute to return.

This should take less than a second to find the entered task.

Performance tracing found the problem query.

select task_name, task_number, task_id
from
 pa_tasks_top_v pt where project_id = :1 and decode(:2, 'Y', Customer_ID, :3)
  = :4 /* ER#35035351 EZ INVOICE */ AND EXISTS( (SELECT NULL FROM DUAL WHERE
  pa_agreement_utils.is_ez_agreement(:5) = 'Y' AND pt.task_id NOT IN (SELECT
  task_id FROM pa_project_fundings WHERE project_id = pt.project_id AND
  task_id IS NOT NULL AND agreement_id != :6)) UNION (SELECT NULL FROM DUAL
  WHERE pa_agreement_utils.is_ez_agreement(:7) = 'N') ) order by
  wbs_sort_order

Steps to reproduce

1. Log into a Projects responsibility
2. Navigate to Billing > Agreements
3. Open agreement to add project funding
4. Click on Funding
5. Enter Project Number > Tab
6. Enter Task Number > Tab
7. Wait for cursor to return and enter amount
8. Save.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.