Fndload is not a command line tool
Fndload is a tool used at patch-upgrade time to migrate data from the Oracle reference instance to your installation. Via fndload seeded responsibilities, menus, profile options and many many more are delivered.
Fndload can also be used at your project by dba’s or technical consultants to migrate-script the setup from one instance to an other. Those people will tell you that fndload requires a first set of mandatory parameters (apps/apps 0 Y) and then some object specific parameters.
But you do not need the unix prompt to use fndload. Make it a functional tool by creating a concurrent program that points to the seeded fndload executable.
Seeded examples you can explore in the instance you’re on now are:
- Download HRMS Taskflows
- Forms Configurator - Upload Template
- Plan Design Copy - Import (Benefit plans)
Forget about the first set of parameters. The concurrent manager handles these for you. The only parameters you have to create and validate and restrict are the functional ones. In the examples above you can see how Oracle implemented it.
Below is the SQL script, which will provide the entire list of the concurrent programs and responsibilities using FNDLOAD as an executable.
select
e.executable_name,responsibility_key,user_concurrent_program_name
from fnd_responsibility r,
fnd_concurrent_programs_tl p,
fnd_request_group_units u,
fnd_executables e,
fnd_concurrent_programs fcp
where r.request_group_id=u.request_group_id
and u.request_unit_id = p.concurrent_program_id
and executable_name like ‘%FNDLOAD%’
and fcp.executable_id = e.executable_id
and user_concurrent_program_name like ‘Download%’
and fcp.concurrent_program_id = p.concurrent_program_idI agree that it gives another option to run FNDLOAD besides UNIX prompt. Although it still remains a manual process to move ldt files to VCS and verify any errors in the log files.
Also it allows to execute FNDLOAD or associated concurrent programs from PL/SQL code and provide some sort of automation this way.Mark
Oracle APPS and surroundingsPosted by .(JavaScript must be enabled to view this email address) on 04/12 at 07:31 AMThis is a modified query versus the one above.
It shows all the concurrent programs associated with FNDLOAD and all responsibilities.select
e.executable_name,responsibility_name,responsibility_key,user_concurrent_program_name
from fnd_responsibility r,
fnd_responsibility_tl tr,
fnd_concurrent_programs_tl p,
fnd_request_group_units u,
fnd_executables e,
fnd_concurrent_programs fcp
where r.request_group_id=u.request_group_id
and u.request_unit_id = p.concurrent_program_id
and executable_name like ‘%FNDLOAD%’
and fcp.executable_id = e.executable_id
and r.responsibility_id = tr.responsibility_id
—and user_concurrent_program_name like ‘Download%’
and fcp.concurrent_program_id = p.concurrent_program_idOracle Applications and Surroundings
Posted by .(JavaScript must be enabled to view this email address) on 04/22 at 12:06 AMVerifying FNDLOAD ldt files is still required.
Click Here
Posted by .(JavaScript must be enabled to view this email address) on 04/22 at 12:07 AMiTerra Consulting Inc. Developed FNDLOAD GUI Application. No need to dig through FNDLOAD examples, blogs and sysadmin guide. <a > Click here </a> to see video presentation and get a feeling of this tool.
Posted by .(JavaScript must be enabled to view this email address) on 12/04 at 06:15 AM
Add Comment Information Here
Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.
Next entry: Oracle E-Business Suite Electronic Technical Reference Manuals (eTRM)
Previous entry: Download Oracle Documentation