Home » Applications » Oracle Fusion Apps & E-Business Suite » FNDLOAD in PL/SQL
FNDLOAD in PL/SQL [message #223847] Mon, 12 March 2007 01:32 Go to next message
bhanubalaji
Messages: 8
Registered: March 2007
Location: Chennai
Junior Member
hi,

may anyone of u will help, how to run the FNDLOAD script in PL/SQL.

regards,
bhanu
Re: FNDLOAD in PL/SQL [message #223867 is a reply to message #223847] Mon, 12 March 2007 02:49 Go to previous messageGo to next message
srinivasoracle
Messages: 18
Registered: February 2007
Location: Hyderabad
Junior Member

Hi,

Can you please tell me exact senario of your Problem.

Thanks & Regards,
Srinivasulu Vakati
Re: FNDLOAD in PL/SQL [message #224076 is a reply to message #223867] Mon, 12 March 2007 22:15 Go to previous messageGo to next message
bhanubalaji
Messages: 8
Registered: March 2007
Location: Chennai
Junior Member
hi,

actually i need to move the records from one instance to another instance in the same server.

i started with 1st step as, downloading the records from instance to local folder.
For acheiving this,i used FNDLOAD Scipts.
FNDLOAD Script is working fine while we run it in Linux or Unix prompt.

now my question is, i should run the FNDLOAD Script in PL/SQL.
so that only i can able to call it from form builder.
is it possible?

i think now u got some idea.

thanks in advance,

regards,
bhanu.
Re: FNDLOAD in PL/SQL [message #224204 is a reply to message #224076] Tue, 13 March 2007 07:00 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Form builder you mean from Some Custom Form?
Re: FNDLOAD in PL/SQL [message #224221 is a reply to message #224204] Tue, 13 March 2007 07:42 Go to previous messageGo to next message
bhanubalaji
Messages: 8
Registered: March 2007
Location: Chennai
Junior Member
Yes, I am on a process of trying to create a sort of object migration of registering a report from one instance of apps to another as a generic process.

For that, I need to execute a PL/SQL procedure which will inturn call the FNDLOAD script to download the ldt file. I could then utilise this same pl/sql procedure in another instance to upload the ldt file.

Below is my script which I tried to execute this functionality.
______________________________________________
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;
/
______________________________________________

In the above code, I am trying to execute the FNDLOAD concurrent program from FND_REQUEST.SUBMIT_REQUEST. Kindly let me know if my coding is right or not. The output of the file is just the structure without any data of the ldt as below:
______________________________________________

# $Header$

# dbdrv: exec fnd bin FNDLOAD bin &phase=daa+64 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y DOWNLOAD @FND:patch/115/import/emp.lct @~PROD:~PATH/~FILE
LANGUAGE = "US"
LDRCONFIG = "emp.lct"

#Source Database VIS

# -- Begin Entity Definitions --

DEFINE EMP
KEY ENAME VARCHAR2(50)
BASE EMPNO VARCHAR2(50)
BASE JOB VARCHAR2(50)
BASE MGR VARCHAR2(50)
BASE HIREDATE VARCHAR2(80)
BASE SAL VARCHAR2(50)
BASE COMM VARCHAR2(50)
BASE DEPTNO VARCHAR2(50)
END EMP

# -- End Entity Definitions --
______________________________________________

I would really appreciate any kind of help.

Thanks
Bhanu

Re: FNDLOAD in PL/SQL [message #224233 is a reply to message #224221] Tue, 13 March 2007 08:08 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Hi,
this is just a suggestion.

Write your own programs.
1)Download - Host Executable - i.e. Shell Script
2)Upload - Host Executable

call it from your form of course you have to give all 100 arguments give values where you have parameter and others with NULL. Check AOL guide for calling concurrent program from Form.

regards
Prashant Pathak
Re: FNDLOAD in PL/SQL [message #224470 is a reply to message #224221] Wed, 14 March 2007 07:05 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Bhanu,
Some mismatch would be there in the FNDLOAD script and the CP parameters.
Quote:
FNDLOAD Script is working fine while we run it in Linux or Unix prompt.
Can you please share the piece of code of FNDLOAD, which is working in UNIX?
I could see the Entity as EMP. But what are the other parameters?

By
Vamsi
Re: FNDLOAD in PL/SQL [message #224646 is a reply to message #224470] Wed, 14 March 2007 22:09 Go to previous messageGo to next message
bhanubalaji
Messages: 8
Registered: March 2007
Location: Chennai
Junior Member
thanks for ur response.

Vamsi,

intially,i tried for sample table[EMP Table]


emp.lct
----------------------------------------------------------------
# $Header$

COMMENT = "dbdrv: exec fnd bin FNDLOAD bin &phase=daa+64 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y DOWNLOAD @FND:patch/115/import/emp.lct @~PROD:~PATH/~FILE"


#Source Database VIS

# -- Begin Entity Definitions --

DEFINE EMP
KEY ENAME VARCHAR2(10)
BASE EMPNO VARCHAR2(50)
BASE JOB VARCHAR2(9)
BASE MGR VARCHAR2(50)
BASE HIREDATE VARCHAR2(11)
BASE SAL VARCHAR2(50)
BASE COMM VARCHAR2(50)
BASE DEPTNO VARCHAR2(50)
END EMP

DOWNLOAD EMP
"SELECT EMPNO,JOB,MGR,HIREDATE,SAL,COMM,
DEPTNO FROM EMP
WHERE ENAME = :ENAME"
----------------------------------------------------------------
script runned in Linux prompt

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/emp.lct emp.ldt EMP ENAME='TEST'

EMP - Entity Name (Defined in LCT file)
TEST - Emp Name (TEST employee records to download)

after execution, i got LDT File in the Specified Path(Mentioned in LCT file)


thanks,
bhanu
Re: FNDLOAD in PL/SQL [message #224742 is a reply to message #224646] Thu, 15 March 2007 05:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Then try out passing entire string.
argument5 => 'ENAME=TEST'
By
Vamsi
Re: FNDLOAD in PL/SQL [message #224905 is a reply to message #224742] Thu, 15 March 2007 21:45 Go to previous messageGo to next message
pretty
Messages: 3
Registered: March 2007
Junior Member
S.







[Updated on: Thu, 15 March 2007 21:59]

Report message to a moderator

Re: FNDLOAD in PL/SQL [message #224906 is a reply to message #224742] Thu, 15 March 2007 22:08 Go to previous message
bhanubalaji
Messages: 8
Registered: March 2007
Location: Chennai
Junior Member
s. got it.
thanks


Previous Topic: TCA in AR
Next Topic: Does anyone use Oracle Pre-Payment functionality?
Goto Forum:
  


Current Time: Mon Dec 05 08:52:04 CST 2016

Total time taken to generate the page: 0.25423 seconds