My Oracle Support Banner

AR Reconciliation Report Running Long Time (US And CANADA) Performance - FDPSTP Failed Due to ORA-01466: Unable to Read Data - Table Definition Has Changed (Doc ID 1556313.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

ARXRECON module: AR Reconciliation Report is having performance issues.

The child program is failing with the following error:

Cause: FDPSTP failed due to ORA-01466: unable to read data - table definition has changed

The master program never ends and has to be terminated.

The Tkprof shows the following query as the top one:

The Tkprof does not have row source operation for this and other queries (maybe because it was terminated)

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
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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