Receipt Data Diagnostic does not Finish for Large Receipts

(Doc ID 2222520.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle E-Business Suite Diagnostics - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running "Oracle Receivables Receipt Data Setup Test" for large receipts, the diagnostic does not finish

Steps to Reproduce:

Responsibility: Application Diagnostics
Navigation
: Diagnose

  1. Follow steps in Doc ID 732201.1 to run this diagnostic for a large receipt

 

The SQL statement running long is the following:

 

 

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