PAXINEAG Cannot Query Agreement Number In R12 After Patch PJ Delta 5 14162290 Is Applied
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 ***
In the PAXINEAG Agreements form version 220.127.116.1110000.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.
Applied <patch:14162290> Oracle Projects Release Update Pack 5 for 12.1 (R12.PJ_PJ.B.DELTA.5)
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