BICS: FNDLOAD FAILS WITH THE FOLLOWING ERROR:"ORA-01452 CANNOT CREATE UNIQUE INDEX AND PVO RETURNS SPACE OR TAB"
(Doc ID 2569042.1)
Last updated on JULY 08, 2021
Applies to:Oracle Business Intelligence Cloud Service - Version 18.1.5 and later
Information in this document applies to any platform.
On: Business Intelligence Cloud Service
- Tried to extract FscmTopModelAM.AnalyticsServiceAM.LookupValuesTLPVO from ERP cloud OTBI to DBCS instance in identity domain
- Extract job (FND-load) is failing with error index creation failed :
- Two rows in target DB have the same values for columns used for index, but have different values for column meaning.
- The same query from PVO returns only one row with space or tab and the data has trimmed
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