My Oracle Support Banner

MSCQFA "Generate Plan Summary" Completes With ORA-29283 (Doc ID 2231083.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Advanced Planning Command Center - Version 12.2.5 and later
Information in this document applies to any platform.


On Memory Based Planner version 12.2.5, the MSCQFA "Generate Plan Summary" completes with errors ORA-29283 and ORA-06512 

During ASCP plan run, requests to populate APCC are launched, the program "Generate Plan Summary" completes in error with multiple error codes in the log file :

ORACLE error 29283 in FDPSTP

Cause: FDPSTP failed due to ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "APPS.MSC_APQ_PKG", line 49
ORA-06512: at "APPS.MSC_APQ_PKG", line 1195
ORA-23-NOV-2016 09:27:48


The issue can be reproduced at will when you run the plan.


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.