The same application name can be present multiple times
SQL> select * from sys_fba_app where appname = 'TQ84_FBA_DEMO_APP';
APPNAME APP# FA# FLAGS SPARE
____________________ _______ ______ ________ ________
TQ84_FBA_DEMO_APP 5 1 0
TQ84_FBA_DEMO_APP 6 1 0
TQ84_FBA_DEMO_APP 7 1 0
SQL> exec sys.dbms_flashback_archive.drop_application('TQ84_FBA_DEMO_APP');
SQL> select * from sys_fba_app where appname = 'TQ84_FBA_DEMO_APP';
APPNAME APP# FA# FLAGS SPARE
____________________ _______ ______ ________ ________
TQ84_FBA_DEMO_APP 6 1 0
TQ84_FBA_DEMO_APP 7 1 0
-- Lowercase!
SQL> exec sys.dbms_flashback_archive.drop_application('tq84_fba_demo_app');
-- ORA-55650: application not registered for flashback archive
SQL> exec sys.dbms_flashback_archive.drop_application('TQ84_FBA_DEMO_APP');
SQL> select * from sys_fba_app where appname = 'TQ84_FBA_DEMO_APP';
APPNAME APP# FA# FLAGS SPARE
____________________ _______ ______ ________ ________
TQ84_FBA_DEMO_APP 7 1 0
SQL> exec sys.dbms_flashback_archive.drop_application('TQ84_FBA_DEMO_APP');
no rows selected