My Oracle Support Banner

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

Last updated on JUNE 10, 2021

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:

"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,
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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.