• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Fndload Value Set Download Upload Command

by admin

Following fndload commands are used to download and upload the Value Set. FNDLOAD can be executed as a concurrent program.

Some advantages when using FNDLOAD

  • Because downloaded data is stored in a text file, version administration is possible
  • There is nothing to worry to go to purchase because Investment = 0$
  • No learning curve. This is relief for developer and DBA
  • Fully supported and recommended by Oracle
  • Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
  • Pin-point when something happened and where (database) easily
  • Your AOL data migration process is now simplified and streamlined goal attained

Some disadvantages when using FNDLOAD

  • Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
  • UPLOAD_MODE=REPLACE only for menus
  • No validation against migrating database/instance sensitive data

FNDLOAD Command to download a Value set

FNDLOAD apps/<PWD> O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <LDT_FILE_NAME>.ldt VALUE_SET FLEX_VALUE_SET_NAME="<VALUE_SET_NAME>"

If value set has values then,

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <LDT_FILE_NAME>.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="<VALUE_SET_NAME>"

FNDLOAD Command to Upload a Value set

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct <LDT_FILE_NAME>.ldt

Filed Under: Oracle Apps

Some more articles you might also be interested in …

  1. How to Reset a Primavera P6 Application User Password
  2. How to read all modules assigned to user from Primavera P6 EPPM database
  3. Difference between Create Accounting – Cost Management and Create Accounting – Receiving
  4. How to check Oracle Apps/EBS version
  5. FNDLOAD Commands to Download Different Seed Data Types
  6. How to find customer number, site number, party number from invoice
  7. How to Change the P6 User Login Name in SQLite Database
  8. Application Engine Concepts
  9. PeopleSoft “Authorization Error – Contact your security administrator “
  10. Resetting an Application User’s Password in P6 Professional Using SQLite

You May Also Like

Primary Sidebar

Recent Posts

  • JavaFX ComboBox: Set a value to the combo box
  • Nginx load balancing
  • nginx 504 gateway time-out
  • Images preview with ngx_http_image_filter_module

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright