R12 Certain MOAC Forms in Projects Have Inconsistent Search Results Giving FRM-40350 Error Upon Consequent Searches (Doc ID 977888.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Foundation - Version 12.0.0 and later
Information in this document applies to any platform.
Form:PAXPREPR.FMB - Projects
Form:PAXINEAG.FMB - Agreements
Form:PAXTREPE.FMB - Pre-Approved Expend Entry


***Checked for relevance on 15-Nov-2013***

Symptoms

On 12.1.1 Instance: 

When extensive MOAC security has been implemented (e.g. setting HR: Security Profile to a security profile defined as "Secure organizations by organization hierarchy and/or organization list") there may be issues when searching for data in Projects forms: PAXPREPR (Projects), PAXINEAG (Agreements), PAXTREPE (Expenditure Inquiry). Initial search will return correct results while consecutive searches will fail with FRM-40350. Closing a form after every search and reopening it is a valid although inconvenient workaround.


ERROR
-----------------------
FRM-40350: Query caused no records to be retrieved

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