Nov 13, 2018

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:
  1. Blue
  2. Khaki
  3. Olive
  4. Purple
  5. Red
  6. Swan
  7. Teal
  8. 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


Jul 23, 2018

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