AP Invoice Approval Is Failing If Invoice Has More Than 500 Lines (Invoice Gets Stuck In Initiated) (Doc ID 2174543.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Fusion Payables - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.8.0.0 version, Manage Invoices-Audit Invoices

AP Invoice approval is failing with below error if invoice has more than 500 lines and invoice gets stuck in Initiated status.
For the rest other invoices, having less than 500 lines, approval is triggering properly.

This error is coming while calling InvoiceHeaderBPEL1 operation of InvoiceApprovalBCService inside AP Invoice approval composite which we can see from composite instance in EM.

We have done some research from our and found following articles related to our error which can helpful for you to investigate the issue further.
- Invoices Stuck In "Initiated" Status (Doc ID 2010482.1)
- Bug 20830069 : INCREASE THE MAX FETCH SIZE OF INVOICE LINES VO IN INVOICEAPPROALBCSERVICE

We are also not able to see or scroll through invoice lines beyond 500 lines in pages: Invoice Details (Manage Invoice) and Edit Invoice.


ERROR
-----------------------
BusinessFault : {http://xmlns.oracle.com/apps/financials/payables/invoices/transactions/invoiceApprovalService/}ServiceException. Client received SOAP Fault from server : JBO-29000: Unexpected exception caught: oracle.jbo.RowLimitExceededWarning, msg=JBO-25089: Too many matching records found. Specify additional criteria to limit the number of records.: JBO-25089: Too many matching records found. Specify additional criteria to limit the number of records.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an invoice with more than 500 lines.
2. Initiate approval.

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