Exclamation mark on table or view object in SQL developer

Question

I use Oracle SQL developer https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html to model my tables and views. When I create view I see warning symbol next to view element:

My code for view:

CREATE OR REPLACE VIEW cards_restaurants AS
    SELECT
        *
    FROM
        (
            SELECT
                l.loyaltycardid,
                COUNT(r.restaurants_id) AS times_purchased,
                nvl(SUM(p.price), 0)    AS money_spent
            FROM
                loyalty_cards  l
                LEFT JOIN orders         o ON o.loyaltycardid = l.loyaltycardid
                LEFT JOIN restaurants    r ON r.restaurants_id = o.restaurants_id
                LEFT JOIN order_products op ON op.orderid = o.orders_id
                LEFT JOIN products       p ON p.products_id = op.products_id
            GROUP BY
                l.loyaltycardid
        )
    WHERE
        money_spent > 0
    ORDER BY
        money_spent DESC;

QUESTION: Where can I check what error my query has? And why when I press "test query" it shows results and that query is successful.

Maybe a full screen picture could help:

Answer 1

That doesn't mean there's an error. It means we haven't parsed the SQL under the view...because it's expensive, and you could have hundreds of those when you do an import from your data dictionary.

I talk about this here

Right click on the view, select 'parse' - then the picture will update and you'll see a list of tables your view is hitting.

Disclaimer: I'm a product manager at Oracle, and Data Modeler is one of my products.