OracleAppsBlog

A day in the life of an Oracle Applications Consultant

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.

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

   I 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 surroundings

   Posted by .(JavaScript must be enabled to view this email address)  on  04/12  at  07:31 AM

2. This 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_id

   Oracle Applications and Surroundings

   Posted by .(JavaScript must be enabled to view this email address)  on  04/22  at  12:06 AM

3. Verifying 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 AM

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

Smileys

Notify me of follow-up comments?

Submit the word you see below: