• 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. Parameters Of Different Configuration Files To Download And Upload Seed Data Types
  2. Fndload Responsibility Download Upload Command
  3. FNDLOAD Commands to Download Different Seed Data Types
  4. How to find customer number, site number, party number from invoice
  5. How to Change the P6 User Login Name in SQLite Database
  6. Resetting an Application User’s Password in P6 Professional Using SQLite
  7. How to reset your forgotten Primavera P6 user password using database query
  8. How to delete and recreate Integrated WebLogic Server Default Domain in JDeveloper?
  9. How to check Oracle Apps/EBS version
  10. How to Reset a Primavera P6 Application User Password

You May Also Like

Primary Sidebar

Recent Posts

  • direnv: Shell extension to load and unload environment variables depending on the current directory
  • dircolors: Output commands to set the LS_COLOR environment variable and style ls, dir, etc
  • dillo: A lightweight web browser intended for slow computers
  • dig: DNS lookup utility

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright