Skip to content

FND FNDLOAD Object Transfer

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

FND FNDLOAD Object Transfer

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
FND FNDLOAD Object Transfer.sql
FND FNDLOAD Object Transfer.sql
 
 
README.md
README.md
 
 

README.md

layout default
title FND FNDLOAD Object Transfer | Oracle EBS SQL Report
description Generates FNDLOAD download and upload linux commands for automated setup transfer between environments
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, FNDLOAD, Object, Transfer, fnd_concurrent_programs_vl, fnd_form_functions, fnd_lookup_types
permalink /FND%20FNDLOAD%20Object%20Transfer/

FND FNDLOAD Object Transfer – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Generates FNDLOAD download and upload linux commands for automated setup transfer between environments

Report Parameters

Object Type, Object Name, Application Short Name, Output File Location, Apps Password Download, Apps Password Upload

Oracle EBS Tables Used

fnd_concurrent_programs_vl, fnd_form_functions, fnd_lookup_types, fnd_application, fnd_profile_options

Report Categories

Enginatics

Related Reports

FND Responsibility Access, FND Responsibility Access 11i, FND Forms Personalizations, FND Concurrent Requests, FND Attachment Functions, Blitz Report Assignments and Responsibilities, FND Flex Value Sets, Usages and Values, FND Concurrent Requests 11i, FND Concurrent Programs and Executables 11i

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output None
Blitz Report™ XML Import FND_FNDLOAD_Object_Transfer.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-fndload-object-transfer/

Executive Summary

The FND FNDLOAD Object Transfer report is a DevOps utility that generates the Linux commands required to migrate Oracle EBS configurations between environments (e.g., DEV to TEST).

Business Challenge

  • Deployment Automation: Reducing the manual effort of typing complex FNDLOAD commands.
  • Error Reduction: Preventing syntax errors in migration scripts.
  • Standardization: Ensuring consistent migration practices across the development team.

The Solution

This Blitz Report generates the exact shell commands:

  • Download Command: The FNDLOAD syntax to extract the object from the source instance.
  • Upload Command: The FNDLOAD syntax to import the object into the target instance.
  • Object Support: Supports common objects like Concurrent Programs, Lookups, Profile Options, and Functions.

Technical Architecture

The report uses a large DECODE or CASE statement to map the user-selected "Object Type" to the specific .lct configuration file and download parameters required by the FNDLOAD utility.

Parameters & Filtering

  • Object Type: Select the type of object (e.g., "Concurrent Program").
  • Object Name: The specific name of the object to migrate.
  • Apps Password: Optional parameter to embed the password in the command (use with caution).

Performance & Optimization

  • Utility Report: Runs instantly.

FAQ

  • Q: Does this run the migration?
    • A: No, it generates the text of the command. You must copy and paste this into a Linux terminal or put it in a shell script.

Useful Links

© 2026 Enginatics