R12 Certain MOAC Forms in Projects Have Inconsistent Search Results Giving FRM-40350 Error Upon Consequent Searches
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***
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.
FRM-40350: Query caused no records to be retrieved
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms