Invoice Workbench Gateway Timeout Performance Issues (Doc ID 2213742.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Manage Invoices-Receive and Process Invoices

ACTUAL BEHAVIOR
---------------
Invoice Workbench Gateway Timeout or it takes a long time to load the Invoice Infotiles.

Navigating to Payables Invoice -  Invoice Workbench Landing Page submits a Gateway Timeout.

javax.el.ELException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

An application error Occurred. See incident log for more information.

or

Service Unavailable - Zero size object

Changes

 You are logging in under a User that just had many invoices (thousands) created under their name.  E.g. User ran Invoice Import.

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