R12 AP/IBY: Payment Instructions Poor Performance Searching By Status = Formatted (Doc ID 2219790.1)

Last updated on OCTOBER 07, 2024

Applies to:

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

Symptoms

Performance problem in the Funds disbursement process home page.

When going to the Payment Instructions page to Search by Status = Formatted,
after some minutes, the following error is displayed:

ERROR
--------
Failure of server APACHE bridge:
No backend server available for connection: timed out after 10 seconds or
idempotent set to OFF or method not odempotent.

This SQL statement took 18 minutes according to the trace generated:

SQL_ID = fsh7rfuas3nv5

Changes

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

R12 AP/IBY: Payment Instructions Poor Performance Searching By Status = Formatted (Doc ID 2219790.1)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!