Archive Plan Summary Completing With "Error while populating the fact tables. purging this plan summary." and "ORA-00001: unique constraint (MSC.MSC_APCC_WORKERS_U1)"
Last updated on DECEMBER 01, 2016
Applies to:Oracle Advanced Planning Command Center - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Load and Summarization ETL
After applying 126.96.36.199 VCP Cum <Patch 19549533>: When running the Archive Plan Summary with parameter "Enable Details" = Yes, it is completing with error
The issue is occurring while inserting records into msc_apcc_workers due to unique constraint violation.
If we run the following SQL statement manually from msc_phub_pkg.populate_details_fn (the statement which populates msc_appc_workers)
sysdate, fnd_global.user_id, fnd_global.login_id,
(select 'msc_plan_details_pkg' worker_name, 'orders' part_name from dual
union select 'msc_plan_details_pkg' worker_name, 'pegging' part_name from dual
union select 'msc_plan_details_pkg' worker_name, 'exception_details' part_name from dual
We get the following error:
The issue can be reproduced at will with the following steps:
1. Run Archive Plan Summary with parameter "Enable Details" = Yes
2. Note the error above
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