Which Special Characters are Allowed in Batch and Task Description? (Doc ID 1934077.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

Goal

The 6.1/7.3.4 environment allows users to enter underscores and dots in task description of the batch and also in allocation name and description.
However, the documentation (InstallGuide_PFT61.pdf, InstallGuide_FTP61.pdf,InstallGuide_ALM61.pdf) contains a paragraph "Batch changes" in "Pre-Upgrade Activities" section, extracting also tasks with dots and underscores:

"Batch changes:
The batches do not allow a special character in the task description, and hence the existing batches that violate this rule have to be identified and the task description has to be changed. The query below, gives the list of tasks that violates the rule. The description of these tasks has to be changed manually before the upgrade, in order to avoid errors.
SELECT t1.v_batch_id,
t1.v_task_description
FROM batch_task_master T1
WHERE Replace(Translate(Nvl(T1.v_task_description, ' '),
'`~!@#$%^&*_()+=[]{}\\|;"<>?,/-:.',
'#'), '#', '') <> Nvl(T1.v_task_description, ' ');"

What are the special characters allowed in batch name, batch description, task name and task description?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms