Oracle FNDLOAD Loader

The Generic Loader (FNDLOAD) is a concurrent program that can move Oracle E-Business Suite data between database and text file representations. The loader reads a configuration file to determine what data to access. For information on specific configuration files consult the Open Interfaces Guide for your product group. The following sections describe the operation of the Generic Loader.

FNDLOAD Executable Syntax

The Generic Loader is a concurrent program named FNDLOAD. The concurrent executable takes the following parameters:

FNDLOAD {apps/APPS_PASSWORD} {0 Y} {mode} {configfile} {datafile} {entity} [optional {param} {param}]

Code	Variable	Description
1	{apps/APPS_PASSWORD}	The APPS schema and password
2	{0 Y}	Concurrent program flags
3	{mode}	UPLOAD or DOWNLOAD - UPLOAD causes the datafile to be uploaded to the database. - DOWNLOAD causes the loader to fetch rows and write them to the datafile.
4	{configfile}	The configuration file to use (usually with a suffix of .lct, but not enforced or supplied by the loader).
5	{datafile}	The data file to write (usually with a suffix of .ldt, but not enforced or supplied by the loader). If the data file already exists, it will be overwritten.
6	{entity}	The entity(ies) to upload or download. When uploading, you should always upload all entities, so specify a "-" to upload all entities.
7	[optional {param} {param}]	Zero or more additional parameters are used to provide bind values in the access SQL (both UPLOAD and DOWNLOAD). Each parameter is in the form NAME=VALUE. NAME should not conflict with an attribute name for the entities being loaded.

Example

Download

FNDLOAD

Upload

FNDLOAD

FNDLOAD Entities

• Oracle AOL Configuration
  • Concurrent Programs
  • Request Groups
  • Lookups
    • Lookup Types
    • Lookup Values
  • Profile Options
    • Profile options definition
    • profile option values
  • Flexfields setup
    • Key flexfields Structures
    • Descriptive flexfields
    • Value sets
  • Attachments setup
  • Messages Dictionary
  • Security Information
    • Menu
    • Function
    • Form
    • Entry
• Alerts
• Approvals Management Engine (AME)
  • Transaction Types
  • Attributes
  • Attribute Definitions
  • Attribute Usages
  • Conditions
  • Approver Groups
    • Approver Groups Definitions
    • Approval Group Configuration
  • Rules
    • Rule Definitions
    • Rule Usages
• XDO
  • Data Definitions
  • XML Template
  • RTF Template
• Generic
  • Responsibility
  • Users
  • Request Set
  • Request Set Link
  • SOA Gateway
  • Forms Personalizations
• Others
  • Workflow
  • Web ADI

Oracle AOL Configuration

Code	Entity Name	Configuration File
1.1	Concurrent Programs	afcpprog.lct
1.2	Request Groups	afcpreqg.lct
1.3	Lookup: Lookup Types	aflvmlu.lct
1.4	Lookup: Lookup Values	aflvmlu.lct
1.5	Profile Option: Definition	afscprof.lct
1.6	Profile Option: Values	afscprof.lct
1.7	Flexfield: Key flexfields	afffload.lct
1.8	Flexfield: Descriptive flexfields	afffload.lct
1.9	Flexfield: Value sets	afffload.lct
1.10	Attachments	afattach.lct
1.11	Messages	afmdmsg.lct
1.12	Security: Menu	afsload.lct
1.13	Security: Function	afsload.lct
1.14	Security: Form	afsload.lct
1.15	Security: Entry	afsload.lct

Alerts

Code	Entity Name	Configuration File
2.1	Alert	alr.lct

Approvals Management Engine (AME)

Code	Entity Name	Configuration File
3.1	Transaction Types	afsload.lct
3.2	Attribute: Definitions	afsload.lct
3.3	Attribute: Usages	afsload.lct
3.4	Conditions	afsload.lct
3.5	Approver Group: Definitions	afsload.lct
3.6	Approver Group: Configuration	afsload.lct
3.7	Rule: Definitions	afsload.lct
3.8	Rule: Usages	afsload.lct

XDO

Code	Entity Name	Configuration File
4.1	Data Definitions	afsload.lct
4.2	XML Template	afsload.lct

Generic

Code	Entity Name	Configuration File
5.1	Responsibility	afscursp.lct
5.2	Users	afscursp.lct
5.3	Request Set	afcprset.lct
5.4	Request Set Link	afcprset.lct
5.5	SOA Gateway	afsload.lct

WFLOAD

Code	Entity Name
6.1	Workflow

Contributors

Author	GitHub & LinkedIn account
Ahmed El-Demasy (Original Author)	Github & LinkedIn

Contributing to the Oracle FNDLOAD scripts

We welcome you to join and contribute to the Oracle FNDLOAD Scripts. If you are interested in helping please don’t hesitate to contact on an e-mail: founder@egyptianprogrammers.com

Suggestions & Issues

If you find any issue or have a great idea in mind please create an issue on GitHub.