OBIA 220.127.116.11.2: W_MFG_MATERIAL_USAGE_F Failure Due To Duplicate Records In Fact Staging
Last updated on SEPTEMBER 01, 2017
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.2 and later
Information in this document applies to any platform.
On : Oracle Business Intelligence Applications 22.214.171.124.2
ODI version 11.1.7
Modules Configured -HR,SCM,P&S,EAM,FIN,PROJ and MFG.
Running incremental loads
- SILOS_SIL_MFGMATERIALUSAGEFACT task failed with unique constraint violation error in production environment.
- On analyzing the issue, it was observed that there are duplicates on integration_id in the fact staging table.
- Since applying a max or min function on CREATED_BY column is not a valid solution here would like to know of the additional filter that needs to be applied in order to resolve this error.
SELECT INTEGRATION_ID,COUNT(*) FROM W_MFG_MATERIAL_USAGE_FS GROUP BY INTEGRATION_ID HAVING COUNT(*)>1
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