OBIA 18.104.22.168.2: W_MFG_MATERIAL_USAGE_F Failure Due To Duplicate Records In Fact Staging
(Doc ID 2168380.1)
Last updated on OCTOBER 22, 2018
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.2 and later
Information in this document applies to any platform.
On : Oracle Business Intelligence Applications 126.96.36.199.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
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