Oracle Applications Java Color Scheme

Have you ever experienced an accidental mistake when you thought you were testing something in Test instances (DEV, UAT, etc.), but in fact, it was in Production? Then, you gasped in fear, rushed to cancel the test you did in Production, and/or asked  the EBS technical/functional guys to come up with an urgent 'datafix' to reverse your mistake (test entry) in Production.

Well, personally I have not. But in case you ever did or feel that it may happen to you 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.

I use the following color schemes to differentiate different instances from each other.

1. TEAL
• Use this color for Development type of instances
• Green color suggests that you are free to make any changes in this instance
2. RED
• Use this color for Test type of instances
• Red color suggests that you should proceed carefully in this instance
3. SWAN
• Defaulted color used primarily in Production
• Swan color suggests that your entries are permanent 
• This color theme profile typically gets copied over to other instances after the Clone

Oracle provides many other color options to choose from. Apply as you see fit or makes sense for your applications.

Blue Khaki Olive Purple Red Swan Teal Titanium

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);