AGIS: Transactions Query and Approval Submission is Limited By Profile 'FND: View Object Max Fetch Size'
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 ***
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.
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.
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