R12 CE: Poor Performance And Error In Cash Position Process (Doc ID 2129042.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms



When trying to run Cash Position Process
with “Use Calculated Prior Day Cash Flow and Overdue Transaction Balances” = No,
after few minutes the following error is displayed.

ERRORS

FAILURE OF WEB SERVER BRIDGE
No backend server available for connection :
timed out after 10 seconds or idempotent set to OFF or method not idempotent .

 

In contrast, when trying to run Cash Position Process
with “Use Calculated Prior Day Cash Flow and Overdue Transaction Balances” = Yes,
the Cash Position Prior Day Cash Flow and Overdue Transactions Program is submitted automatically
but it takes 4+ hours to finish.

The following SQL takes long time to finish.

 

 

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