ORA-12018,ORA-00904: : invalid identifier During MV creation -11203 AIX 6.1
Created the MV logs on the base tables .The MV and MV logs are in same schema ,nothing is being referenced outside the schema.
During MV creation throwing error ORA-12018
ORA-12018: following error encountered during code generation for "XMATSBX"."MV_CUST_SEARCH"
ORA-00904: : invalid identifier
CREATE MATERIALIZED VIEW XMATSBX.MV_CUST_SEARCH NOLOGGING PARALLEL 8 BUILD IMMEDIATE
REFRESH FAST ON COMMIT AS
( SELECT personprofilenames.pp_legalentity_number legal_entity_number,
personprofilenames.first_name,
personprofilenames.last_name,
personprofilenames.middle_name,