how to create a foreign key in custom table that references PK in standard table in oracle apps
Hi all,
I am working on oracle EBS environment
I wanna create custom table with a foreign key that references an oracle standard table - as u know the standard table in oracle does not have PK explicitly it exists in somewhere else -
I wanna add this FK because when record in the standard parent table is updated , it reflects record in detail table with command on delete cascade
therefore when the parent record is deleted detail record is deleted
but when I add the command
alter TABLE xx_om_so_logistic_capture_tab ADD constraint header_id_fk_01 foreign key( header_id) references OE_ORDER_LINES_ALL(header_id)