SQL Language (MOSC)

MOSC Banner

how to create a foreign key in custom table that references PK in standard table in oracle apps

edited Dec 24, 2014 10:02AM in SQL Language (MOSC) 3 commentsAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center