B Handling Special Characters

Oracle Enterprise Performance Management Cloud passwords, proxy passwords, and command parameter values may contain special characters. Special handling is required for EPM Automate to handle such characters.

The examples in this section use a sample password to illustrate the use of special characters.

Oracle recommends that you enclose parameter and value pairs in double quotation marks.

Windows

These special characters must be escaped using double quotation marks (") around the special character or around the parameter value containing the special character.

Note:

EPM Automate cannot be run from a folder that contains & in its name; for example, C:\Oracle\A&B.

Table B-1 Special Character Handling: Windows

Character Description Escaped Example
) Close parenthesis
  • Example")"pwd1 or
  • "Example)pwd1"
< Less than
  • Example"<"pwd1 or
  • "Example<pwd1"
> Greater than
  • Example">"pwd1 or
  • "Example>pwd1"
& Ampersand
  • Example"&"pwd1 or
  • "Example&pwd1"
| Pipe
  • Example"|"pwd1 or
  • "Example|pwd1"
" Quotation mark
  • Example"""pwd1 or
  • "Example"pwd1"

Using Exclamation Mark in Plain Text Passwords in Windows Batch Files

Use of exclamation mark (!) in plain text passwords in Windows batch files used with EPM Automate should be handled as follows:

  1. Use two caret symbols (^^) before the exclamation mark as the escape character. For example, if the password is Welc0me!, encode it as Welc0me^^!
  2. Update the bach file to set DisableDelayedExpansion at the beginning of the file by including the following declaration:

    setlocal DisableDelayedExpansion

  3. Remove setlocal EnableExtensions EnableDelayedExpansion declaration, if present, in the script.

UNIX/Linux

On UNIX and Linux operating systems, special characters must be escaped using a backslash (\).

Note:

  • To escape ! (exclamation mark), use a single quotation mark around the password or use the back slash (\) as the escape character.
  • To escape \, $, ', and ", use a double quotation mark around the password or use the back slash (\) as the escape character.

Table B-2 Special Character Handling: UNIX/Linux

Character Description Escaped Example
( Open parenthesis Example\(pwd1
) Close parenthesis Example\)pwd1
< Less than Example\<pwd1
> Greater than Example\>pwd1
` Apostrophe Example\'pwd1
! exclamation mark
  • 'Example!pwd1' or
  • Example\!pwd1
# Hash Example\#pwd1
& Ampersand Example\&pwd1
| Pipe Example\|pwd1
; Semicolon Example\;pwd1
. Period Example\.pwd1
" Quotation mark
  • Example\"pwd1 or
  • "Example\"pwd1"
' Single quotation mark
  • Example\'pwd1 or
  • "Example\'pwd1"
$ Dollar sign
  • Example\$pwd1 or
  • "Example\$pwd1"
\ Back slash
  • Example\\pwd1 or
  • "Example\\pwd1"

Using Exclamation Mark in Plain Text Passwords in UNIX or Linux Scripts

In UNIX/Linux scripts, if an EPM Automate password stored in a shell variable contains special characters, use three back slashes as the escape sequence and then enclose the string in double quotation marks. For example, the password lzi[ACO(e*7Qd)jE included in the shell variable password should be scripted as follows:

password="lzi[ACO\\\(e*7Qd\\\)jE"