MSCHUBA2 Archive One Package and Archive Plan Summary Fail with "msc_supply_pkg.populate_details.exception: Duplicate Data exists for entered plan/plan run, please purge the data before running Populate API100 -ERROR- ORA-01403: no data found" (Doc ID 1900910.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Load and Summarization ETL in Advanced Planning Command Center

When attempting to run Archive Plan Summary and Archive One Package, they end in error:

ERROR
-----------------------

msc_supply_pkg.populate_details.exception: Duplicate Data exists for entered plan/plan run, please purge the data before running Populate API100 -ERROR- ORA-01403: no data found

NOTE: This error has also occurred after upgrading from 12.1.3 to 12.2.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Archive Plan Summary
2. Archive Plan Summary and Archive One Packaged complete in error

Cause

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