Oracle View / Materialized View - ORA-00904:

I've created an Oracle Materialized View based on an Oracle Table. I've added both the Table and Materialized View to the LightSpeed designer.

When I try to search for data using the Materialized View using LINQ

        using (var unitOfWork = this.context.CreateUnitOfWork())
        {
            VwmAisItemMaster vwmAisItemMaster = unitOfWork.VwmAisItemMasters.Where(i => i.Upc == upc && i.Wic == wic)
                                                                            .FirstOrDefault();
            <snip>

I get the following errors: ORA-06550: line 72, column 11: PL/SQL: ORA-00904: "VWMAISITEM_MASTER"."ID": invalid identifier ORA-06550: line 4, column 1: PL/SQL: SQL Statement ignored

The view does not have an ID field. Since it's a view, there is no primary key. So I'm confused as to why Lightspeed is looking for a PK field called ID.

I found following blurb:

"Because a view does not have a primary key, if the identity column is not called Id then the designer will not infer the identity column name. You will need to fix this up manually in this case." http://www.mindscapehq.com/documentation/lightspeed/Controlling-the-Database-Mapping/Working-with-Database-Views

My underlying table does have a PK: AisItemMasterId. And that column is included in the Materialized View.

If I go to the lightspeed designer, and set the Materialzied View's Identity Column name to "AISITEMMASTERID", I get the following compile error: Column AISITEMMASTERID is mapped multiple times in entity VwmAisItemMaster

I'm assuming this is because I have both the Table and View on the designer. Not sure though.

I got past the error by renaming the PK to "ID" column in the view.

create materialized view wag.ais_vwm_item_master 
as 
    select *
    from (select a.AIS_ITEM_MASTER_ID AS ID, a.*, rank() over (partition by a.upc, a.wic order by a.created_datetime_utc desc) rnk
          from wag.ais_item_master a
          order by a.upc, a.wic)
    where rnk = 1;