FND_DOCS_LONG_TEXT_SN Materialized View has INVALID Status ORA-00932 inconsistent datatypes: expected (Doc ID 1368704.1)

Last updated on APRIL 17, 2025

Applies to:

Symptoms

FND_DOCS_LONG_TEXT_SN Materialized view is invalid. It was created from MSCINVSN.sql. When trying to compile the materialized view, it still remains invalid. The materialized view uses the following SQL:

SELECT fdlt.MEDIA_ID, TO_LOB(fdlt.LONG_TEXT) LONG_TEXT, 0 RN
FROM APPLSYS.FND_DOCUMENTS_LONG_TEXT fdlt
WHERE fdlt.LONG_TEXT IS NOT NULL;

which returns a ORA-00932; inconsistent datatypes: expected - got LONG error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.