My Oracle Support Banner

Push Plan Information Is Failing With 'ORACLE error 14452 in FDPSTP' Error (Doc ID 2783789.1)

Last updated on AUGUST 17, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.8 version,

When attempting to run Push Plan Information,
the following error occurs.

 **SQL error and free**
 ORACLE error 14452 in FDPSTP

Cause: FDPSTP failed due to ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-06512: at "APPS.MSC_M2A_PUSH", line 3272
ORA-06512: at "APPS.MSC_M2A_PUSH", line 1303
ORA-06512: at line 1

The issue happens while performing the following:

1. Run the Push Plan Information

Nav: Advanced Supply Chain Planner (R) -> Other -> Request -> Select 'Push Plan Information' and enter parameters appropriately.

2. Review the log file of the concurrent request and see the above error.


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

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