Dear Friends
Kindly suggest where i should place the Dynamic action in Oracle apex Master Detail form, right now when I try to create a new entry, first, it opens the header after applying it goes to the interactive form and then when clicking on the link of that record it opens the header and detail form, many a times before it opens the form it delete the master record and shows as error on screen . I want to know the exact location from where we can fire this DA.
CREATED A Dynamic Action
Even : Page Load
DELETE FROM Accounts_h
WHERE NOT EXISTS (
SELECT 1
FROM Accounts_d
WHERE Accounts_d.detail_id = Accounts_h.id
);
SANDY