Search notes:

ORA-01733: virtual column not allowed here

Creating a table …

create table tq84_ora_01733_t (
   id  integer generated always as identity,
   prt varchar2(10),
   txt varchar2(10)
);

… and a view that selects from a subquery that involves the table:

create or replace view tq84_ora_01733_v as
select
   prt,
   txt
from (
   select
      row_number() over (partition by prt order by id desc) rn,
      prt,
      txt
   from
      tq84_ora_01733_t
)
where
   rn = 1;

The following insert statement results in ORA-01733: virtual column not allowed here:

insert into tq84_ora_01733_v values ('A', 'abc');

Cleaning up

drop table tq84_ora_01733_t;

ORA-01733: virtual column not allowed here

See also