Oracle Applications Java Color Scheme

Have you ever experienced an accidental mistake when you thought you were testing something in DEV or UAT instances, but it was, in fact, in PROD, which had you gasp in fear and eventually forced you to cancel what you did or come up with some kind of datafix? Well, me neither.

But in case you ever did or feel that it may happen in future, there is an easy remedy to avoid this. Hence, one of the good reasons why Oracle Applications offer you different color schemes for different Oracle Application instances. Note that, this only applies to Oracle (Java) form.

Following is what I do for using different colors for different instances:

1. TEAL
• suggests you are free to make any changes in this color/instance
• such as DEV or TRAIN instance
2. RED
• suggests you should be careful during any actions in this color/instance
• such as UAT or TEST instance
3. SWAN
• defaulted color theme for Production
• this color theme gets copied over to other instances after the instance clone is complete

Of course, you have more color options that you can choose from. Apply them as you see fit or which make more meaningful to you.

The Options are: Blue Khaki Olive Purple Red Swan Teal Titanium

Profile Name: Java Color Scheme

Navigation:  Any Responsibility à Edit à Preferences à Profiles

Press 'F11' in the Profile Name field. Type 'Java Color Scheme'. Press Ctrl+F11. From "User Value" drop down list, choose one of the values.

 

• Blue

• Khaki

• Olive

• Purple

• Red

• Swan

• Teal

• Titanium

REGEXP_SUBSTR: Create a list from a comma separated line

You can create a numbered list from a comma separated string line using REGEXP_SUBSTR function.

WITH t AS

   (SELECT 'PAYABLES, RECEIVABLES, GENERAL LEDGER, INVENTORY, PURCHASING'  str,

           '[^|,]+'  sep

      FROM dual)

 SELECT level, TRIM (REGEXP_SUBSTR (t.str, t.sep, 1, LEVEL)) parsed_str

   FROM t

CONNECT BY LEVEL <= REGEXP_COUNT (t.str, t.sep);