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 <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.

Are you using the ‘Program’ name or the “Short Name’ of the concurrent program?  I believe you need to pass the short name.

Regards,
Michael

Thanks Michael.
Yes, I am passing the shortname of the conc program (XXXX).
I tried other options like,
passing argument5=>’XXXX’ (without CONCURRENT_PROGRAM_NAME=). but No improvement.

Regards,
Senthil.

whu dont you use FNDLOAD shell utility
something like this in the unix prompt

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $FND_TOP/patch/115/import/US/mu_instal_ready_interval_table.ldt

I am facing similar problem while trying to download the ldt file by executing FNDLOAD from PL/SQL. My code is as below :

CREATE OR REPLACE package body AOL_TEST AS
PROCEDURE AT_TEST(
errbuf out nocopy varchar2, --needed by concurrent manager.
retcode out nocopy number
) IS

req_id number;

begin
REQ_ID := FND_REQUEST.SUBMIT_REQUEST (
application => ‘FND’,
program => ‘FNDLOAD’,
description => NULL,
start_time => NULL,
sub_request => FALSE,
argument1 => ‘DOWNLOAD’,
argument2 => ‘/ng1/oracle/visappl/fnd/11.5.0/patch/115/import/emp.lct’,
argument3 => ‘/usr/tmp/emp.ldt’,
argument4 => ‘EMP’,
argument5 => ‘TEST’
);

end AT_TEST;
end AOL_TEST;
/

Kindly let me know if the problem is solved as of now or if I have done anything wrong in my coding.

Thanks
Sujatha

works fine for me. are you initialising your session?

example downloading the standard manager setup

--------------------------------------------------------------------------------------------------------------------------------------

DECLARE
req_id fnd_concurrent_requests.request_id%TYPE;
BEGIN
fnd_global.apps_initialize(
user_id => 50515
,resp_id => 20420
,resp_appl_id => 1
);

req_id :=
fnd_request.submit_request
(application => ‘FND’
,program => ‘FNDLOAD’
,description => NULL
,start_time => NULL
,sub_request => FALSE
,argument1 => ‘DOWNLOAD’ —Mode - UPLOAD
,argument2 => ‘@fnd:patch/115/import/afcpque.lct’ —LCT File
,argument3 => ‘/tmp/concqueues.ldt’ —
,argument4 => ‘QUEUE’
,argument5 => ‘APPLICATION_SHORT_NAME=FND’
,argument6 => ‘CONCURRENT_QUEUE_NAME=STANDARD’
);
DBMS_OUTPUT.put_line(’req_id= ‘||req_id);
COMMIT;
END;

--------------------------------------------------------------------------------------------------------------------------------------

this is equivalent to:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpque.lct /tmp/concqueues.ldt QUEUE APPLICATION_SHORT_NAME=FND CONCURRENT_QUEUE_NAME=STANDARD

Regards,

Alan