R12: Performance Issue While Approving Project Contract (Doc ID 2146225.1)

Last updated on JANUARY 26, 2017

Applies to:

Oracle Project Planning and Control - Version 12.2 and later
Oracle Project Costing - Version 12.2 and later
Information in this document applies to any platform.
Approve Contract, Performance, Contract Organizer

Symptoms

In OKE form 'Contract Organizer', when submitting contract for approval workflow this fails due to a performance issue. 

STEPS TO REPLICATE:

1. With Projects Contracts responsibility go to Contract Organizer.

2. Find a contract.

3. Click Go To ... > select Authoring Workbench

4. In Contract Authoring Workbench, click button Start in order to submit the contract to Approval.

5. On Quality Assurance Results form, once Severity shows Success , click on Continue Approval button.

At this point, the application hangs, nothing happens.

 

The issue happens due to the following select statement:

Changes

 

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