| FNDLOAD - Execution thorugh PL/SQL package [message #136555] |
Thu, 08 September 2005 13:04  |
rsenthila
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
Hi,
I am in process of using the FNDLOAD in pl/sql packge to get rid of MD120s for the setups when we move any customization to the production instance.
Our instance details :
11.5.8
Windows server.
I tried using the FNDLOAD in the pl/sql package to DOWNLOAD and UPLOAD the *.ldt file for program definitions.
But while using the DOWNLOAD option, I could not get to work this properly.
I used the following syntax for the same.
l_req_id := fnd_request.submit_request
(program => ‘FNDLOAD’,
application => ‘FND’,
description => NULL,
start_time => NULL,
sub_request => FALSE,
argument1 => ‘DOWNLOAD’,
argument2 => ‘@FND:/patch/115/import/afcpprog.lct’,
argument3 => l_data_file, —holding the data file directory
argument4 => ‘PROGRAM’,
argument5 => l_entity_arg);—holding value short name <CONCURRENT_PROGRAM_NAME=’XXXX’>
This is creating the .ldt file with only the skeleton of the concurrent program (metadata) without any details of the program XXXX.
If anyone faced this before, Please let me know the proper syntax for this.
Thanks in advance.
Regards,
Senthil.
|
|
|
|
| Re: FNDLOAD - Execution thorugh PL/SQL package [message #136681 is a reply to message #136555] |
Fri, 09 September 2005 08:50  |
justchakri
Messages: 27
Registered: September 2005
Location: Bangalore
|
Junior Member |
|
|
Hi Senthil,
fact: Oracle Application Object Library
symptom: Call to FND_REQUEST.SUBMIT_REQUEST from server-side stored PL/SQL
returns zero
symptom: Fnd_Request.Submit_Request Return 0
cause: Short Name Paramter is set incorrectly.
fix:
Enter the correct values for the Parameters in the call.
Parameters are as follows:
application - Short name of the application associated with the concurrent
request to be submitted.
program - Short name of the concurrent program (not the executable) for which
the request should be submitted.
description - Description of the request that is displayed in the Concurrent
Requests form (Optional.)
start_time - Time at which the request should start running, formatted as HH24:
MI or HH24:MI:SS (Optional.)
sub_request - Set to TRUE if the request is submitted from another request and
should be treated as a sub-request.
argument1...100 - Arguments for the concurrent request; up to 100
arguments are permitted. If submitted from Oracle Forms, you must specify all
100 arguments.
Thanks,
chakri
|
|
|
|
| Re: FNDLOAD - Execution thorugh PL/SQL package [message #136738 is a reply to message #136681] |
Fri, 09 September 2005 14:44 |
rsenthila
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
Thanks Chakri.
I guess I have not explained it clearly. I am not getting the problem with FND_REQUEST.SUBMIT_REQUEST() procedure call.
But I am getting the problem with passing the arguments for the FNDLOAD program.
.
This takes arguments
arg1 - DOWNLOAD
arg2 - lct file name
arg3 - ldt file name
arg4 - entity name
arg5 - ( Key value pair like,
CONCURRENT_PROGRAM_NAME='XXXX')
.
PS:
This can be successfully executed when run from command prompt in the middle tier.
Syntax is as follows.
> FNDLOAD <apps/apps> 0 Y DOWNLOAD @FND:/patch/115/import/afcpprog.lct @FA:resource/senthil.ldt PROGRAM CONCURRENT_PROGRAM_NAME='XXXX'
.
So the problem is passing the key_value pair arguments in the arg5. Please try this and let me know if you need further info.
.
Thanks,
senthil.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
