AGIS: Transactions Query and Approval Submission is Limited By Profile 'FND: View Object Max Fetch Size' (Doc ID 1121921.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Financials Common Modules - Version 12.1.2 and later
Oracle General Ledger - Version 12.1.2 and later
Information in this document applies to any platform.
*** Checked for Relevance on 8-Aug-2013 ***

Symptoms

When approving an AGIS batch that has more transactions than the value of the profile "FND: View Object Max Fetch Size", the transactions that exceed that value are not approved.

Expected Behavior
-----------------------
Expect all transactions to be approved, regardless of the profile setting.

Steps to Recreate:
------------------
1. The profile "FND: View Object Max Fetch Size" is set to 270.
2. Uploaded an AGIS Web ADI spreadsheet with 315 transactions.
3. Only the first 270 could be viewed  on the Outbound Transactions form.
This message was received:
'Warning: Query has exceeded 270 rows. Potentially more rows exist, please limit your query.'
4. Submit the transactions for Approval. Only the first 270 are approved.
 

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