APEX

Hi Team

APEX Version 24.2.2

Reproduction steps.

1. Build a schema

-- Create the STAND_UP_COMEDIANS table
CREATE TABLE stand_up_comedians (
    comedian_id NUMBER PRIMARY KEY,
    stage_name VARCHAR2(50) NOT NULL,
    real_name VARCHAR2(50),
    favorite_punchline VARCHAR2(200),
    heckles_survived NUMBER DEFAULT 0,
    mic_drops NUMBER DEFAULT 0
);

COMMENT ON TABLE stand_up_comedians IS 'Where we keep track of our laugh generators';
COMMENT ON COLUMN stand_up_comedians.heckles_survived IS 'Number of times they''ve turned boos into applause';
COMMENT ON COLUMN stand_up_comedians.mic_drops IS 'Literal mic drops, we have a budget for new mics';

-- Create the JOKES table
CREATE TABLE jokes (
    joke_id NUMBER PRIMARY KEY,
    comedian_id NUMBER,
    joke_text VARCHAR2(1000),
    laugh_o_meter NUMBER(3,2),
    crickets_chirped NUMBER DEFAULT 0,
    CONSTRAINT fk_comedian FOREIGN KEY (comedian_id) REFERENCES stand_up_comedians(comedian_id)
);

COMMENT ON TABLE jokes IS 'Repository of comedic gold (and some fool''s gold)';
COMMENT ON COLUMN jokes.laugh_o_meter IS 'Scale of 0 to 10, where 0 is a tumbleweeds and 10 is uncontrollable laughter';
COMMENT ON COLUMN jokes.crickets_chirped IS 'Number of times this joke was met with awkward silence';

-- Create a sequence for comedian_id
CREATE SEQUENCE comedian_seq START WITH 1 INCREMENT BY 1;

-- Create a sequence for joke_id
CREATE SEQUENCE joke_seq START WITH 1 INCREMENT BY 1;

-- Insert some data
BEGIN
INSERT INTO stand_up_comedians (comedian_id, stage_name, real_name, favorite_punchline, heckles_survived, mic_drops)
VALUES (comedian_seq.NEXTVAL, 'The Pun-isher', 'Peter Parker', 'That''s how eye roll!', 42, 7);

INSERT INTO jokes (joke_id, comedian_id, joke_text, laugh_o_meter, crickets_chirped)
VALUES (joke_seq.NEXTVAL, comedian_seq.CURRVAL, 'Why don''t scientists trust atoms? Because they make up everything!', 8.5, 2);
END;

-- Create a view for the best jokes
CREATE VIEW hilarious_hits AS
SELECT c.stage_name, j.joke_text, j.laugh_o_meter
FROM stand_up_comedians c
JOIN jokes j ON c.comedian_id = j.comedian_id
WHERE j.laugh_o_meter > 7;

COMMENT ON TABLE  hilarious_hits IS 'The cream of the comedic crop, guaranteed to make you LOL';

2. Create App using GenAI

2. APEX cannot create the app - fine. so I now create UI Defaults as usual

3. Create App using GenAI

4. This time it works, so now I remove all the UI defaults from these tables, sign out/back in of Builder.

5. Create App using GenAI again.

Summary

After removing the UI Defaults I would expect that AI would revert back to being oblivious to those tables, columns, comments, etc.

If I cannot remove this knowledge from AI by removing the UI Defaults, how can I delete it so that AI will not consider these again?

This also happens after I drop JOKES, HILARIOUS_HITS and STAND_UP_COMEDIANS. When I drop the objects, Create App with GenAI still remembers those objects and will attempt to create an app on non-existent objects.