Which Special Characters are Allowed in Batch and Task Description?
Last updated on JANUARY 05, 2018
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)
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:
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.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms