My Oracle Support Banner

iStore Reports Fact Tables Refresh Completes With Error - ORACLE error 12838 in FDPSTP (Doc ID 1160145.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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

Symptoms

-- Problem

When attempting to run the iStore Reports Fact tables Refresh - IBEFACTREF - it completes with the following error each time it is run :-

--Error
ORACLE error 12838 in FDPSTP

Cause: FDPSTP failed due to ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-06512: at "APPS.IBE_REPORTING_PVT", line 2389
ORA-06512: at line 1


--Steps
1. Run the iStore Reports Fact tables Refresh concurrent program
2. Fails with error

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
References


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