PAXINEAG Cannot Query Agreement Number In R12 After Patch PJ Delta 5 14162290 Is Applied (Doc ID 1479683.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 30-Jan-2014 ***

Symptoms

In the PAXINEAG Agreements form version 12.0.31.12010000.18, users are unable to query and view agreements that do not have a value in the owning_organization_id in the PA_AGREEMENTS_ALL table. The form displays error:

 FRM-40301: Query caused no records to be retrieved. Re-enter.

However the PAXINVPF Funding Inquiry form shows totals that include the agreements with the missing owning_organization_id. The application should not restrict querying agreements on this field if the field is not required when the agreement is created. This issue exists for agreements created without an owning_organization_id in both release 11i and in release 12.

Changes

 Applied <patch:14162290> Oracle Projects Release Update Pack 5 for 12.1 (R12.PJ_PJ.B.DELTA.5)

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