R12: Getting Error - Query Has Exceeded 200 Rows While Trying To Approve Purchasing Documents In Buyer Work Center

(Doc ID 1360750.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Purchasing - Version: 12.1.2 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
Buyer Work Center
PoHeaderSvrCmd.java

Symptoms

While attempting to approve Purchase Orders in Buyer Work Center, the following error occurs:

Query has exceeded 200 rows. Potentially more rows exist, please restrict your query.
Blanket Purchase Agreement xxxx has been submitted for approval.

Steps to Reproduce:


1. Login to the E-Business Suite and choose the Purchasing Responsibility
2. Navigate to:  Buyer Work Center
3. Select a purchase order having more lines than the profile - FND: Max Fetch Size Value
4. Submit for approval, error occurs

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