My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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.


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.




To view full details, 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 a vibrant support community of peers and Oracle experts.