A concurrent Oracle job is submitted only with the last string "Request"
search cancel

A concurrent Oracle job is submitted only with the last string "Request"

book

Article ID: 84997

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

Affects Release version(s): 5

Error Message :
There is no explicit error message , besides the fact that the concurrent job is submitted with misleading variables . Example : "Request" instead of "Internal Job Request"

Patch level detected:Manager for Oracle Applications 3.2
Product Version: Dollar.Universe 5.6.0 FX25010

Description :When submitting a concurrent Oracle job via the Manager for Oracle applications 3.2 that contains a variable with space characters such as "Internal Job Request" , the manager submits it only with the last string "Request" .

Example:

-----------------------
Running ux_orapps.ksh
-----------------------
resp_app:XXCEN
resp_name:XXCSOrsyp Scheduler
username:XXCSORSYP
appli_short_name:XXCEN
prog_name:XXPIM_ITEM_VAL_MATCH_RULE
log:0
nowait:1
nls_lang:AMERICAN_AMERICA.UTF8
printer:noprint
copies:0
print_style:
Arguments:@2=Internal Item Request
[email protected]=Internal Item Request
Language = AMERICAN_AMERICA.UTF8
Connected.
""
Request
""
End of the PL/SQL procedure call to compute default parameter values with code 0
ARGUMENTS = "" Request ""

Environment

OS: All Unix
OS Version: All

Cause

Cause type:
Defect
Root Cause: N/A

Resolution

Add double quotes before and after the entire string of values.
(Then make sure to re-compile the sql packages that come with the package in order).

Fix Status: Released

Fix Version(s):
Component: Manager.for.Oracle.Application
Version: Dollar.Universe 5.6.0 FX25010
FX24815

Additional Information

Workaround :
N/A