ATP Plan Archival Process Failure ERROR- ORA-08103: object no longer exists (Doc ID 1490290.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Global Order Promising - Version 12.1.3 and later
Information in this document applies to any platform.
*** Reviewed for currency 18-Nov-2016 ***

Goal

We have Launch Supply Chain Planning Process scheduled to run in Production environment Daily.
Launch Supply Chain Planning Process is scheduled to run with the following parameters.

Plan Name : ATP
Launch Snapshot : Full Snapshot
Launch Planner: Yes
Anchor date : Current Date
Archive Current Version of the Plan summary : Yes
Enable 24X7 : Yes , purge current plan after switch plan
Snapshot Static Entities : yes

The Followning spawned requests are getting error out in Production often:
Program Name : Archive One Package
Error Message : "An error occured while populating fact tables, please consider rerunning the concurrent program-8103 -ERROR- ORA-08103: object no longer exists"

Program Name : Purge Plan Summary
Error Message : "An error occured while purging fact tables, please consider rerunning the concurrent program"

Please let us know why the Prorgams are getting error out.
 
We are not running any other ASCP plans while this is running

This is a 24x7 ATP plan.
 

Solution

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