That's syntax for ya! Here's the "new" way to recompile invalid objects on and CDB / PDB in Oracle Database Server 19c (and above), a little trickier than just @utlrp.sql huh! ...

cd $ORACLE_HOME/rdbms/admin 
$ORACLE_HOME/perl/bin/perl catcon.pl --n 1 --e --b utlrp --d '''.''' utlrp.sql

At least querying them back is easier:

select * from dba_invalid_objects;

For reference:

• Recompiling All Invalid Objects (19c)

This is a post from Gareth's blog at http://garethroberts.blogspot.com

Oracle EBusiness Suite and Java Webstart

Are there some little things in life that frustrate you? 

How about Oracle EBusiness Suite installations that haven't configured Java Webstart - you know, the one's that still require some archaic version of Microsoft Internet Explorer with incarnations of JInitiator. Get Java Webstart sorted and use Firefox, Chrome :-)

If you're an Oracle EBS customer and haven't done that yet - as long as you're reasonably patched on your current version it's very little effort - if you need a hand, get in touch! 

Here are a couple of pointers to get started: 

• Java Web Start Available for EBS 12.1 and 12.2
• Using Java Web Start with Oracle E-Business Suite (Doc ID 2188898.1)

This is a post from Gareth's blog at http://garethroberts.blogspot.com