Using FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database.The Conversion between database format and text file format is specified by a configuration file.

 

It can be done for the following list

 · Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Concurrent Manager Schedules

Advantages when using FNDLOAD 

 1. Because downloaded data is stored in a text file, version administration is possible
2. No learning curve. this is relief for developer/dbas
3. Fully supported and recommended by Oracle
4. Capture the migrations in a file and use it during installations(log file).
5. Pin-point when something happened and where (database) easily
6. AOL data migration process is now simplified!

Disadvantages 

1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. No validation against migrating database/instance sensitive data

Interface Table

GL_BUDGET_INTERFACE is used to upload budget data into your Oracle General Ledger application from an external source. Each row includes one fiscal year’s worth of budget amounts for an account. When you load this table, you must supply all NOT NULL columns with data. In addition, you must supply a valid account combination in the SEGMENT columns appropriate to your chart of accounts. Finally, you must supply the budget amounts in the appropriate AMOUNT columns.

The mandatory (not null) columns of the Interface table are,

• BUDGET_NAME
• BUDGET_ENTITY_NAME (the budget organization)
• CURRENCY_CODE
• FISCAL_YEAR
• UPDATE_LOGIC_TYPE (A for Add, R for Replace)

Other important columns are,

• SET_OF_BOOKS_ID
• BUDGET_VERSION_ID
• PERIOD1_AMOUNT through PERIOD60_AMOUNT
• SEGMENT1 through SEGMENT30

Validations

• Budget Name and Budget Entity Name
• Currency Code
• Account Segments(Code Combination in GL_CODE_COMBINATIONS Table)

To upload a budget

1. Navigate to the Upload Budget window (Budgets > Enter > Upload).
2. Enter the Budget and Budget Organization.
3. click Upload.

General Ledger submits a concurrent process to upload budget information from the GL_BUDGET_INTERFACE table.

Budget Upload Validation

Budget Upload validates all of your budget information for compatibility with General Ledger. Budget Upload also checks to make sure that the following conditions are true:

• Your account is assigned to a budget organization

• The budget entry type for your account is Entered

• Your budget is not Frozen

• Your budget organization is not Frozen

• Your budget fiscal year is open for your budget

Once updated, General Ledger automatically deletes the rows of budget records in the Budget Interface table.

Base Tables

• GL_BUDGETS
• GL_BUDGET_ASSIGNMENTS
• GL_BUDGET_TYPES