• 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

How To Download Single Context Using FNDLOAD For Descriptive Flexfield

by admin

Descriptive Flexfields has many Context Codes based on the value of the reference field and there is a need of downloading a specific Context and then upload to other instances.

Example 1

Downloading ‘Global Data Element’ and all context codes that start with JA for all Descriptive Flexfields that start with JG.

$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="JG" DESCRIPTIVE_FLEXFIELD_NAME="JG%" P_LEVEL="COL_ALL:REF_ALL:CTX_ONE" DESCRIPTIVE_FLEX_CONTEXT_CODE="JA%"

Example 2

Downloading ‘Global Data Element’ and context codes is specifically LOCATION1 for Descriptive Flexfield HR_LOCATIONS.

$ FNDLOAD apps/password 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="PER" DESCRIPTIVE_FLEXFIELD_NAME="HR_LOCATIONS" DESCRIPTIVE_FLEX_CONTEXT_CODE="LOCATION1" P_LEVEL="COL_ALL:REF_ALL:CTX_ONE:SEG_ALL"

Example 3

$ FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="PER" DESCRIPTIVE_FLEXFIELD_NAME="Assignment Developer DF" DESCRIPTIVE_FLEX_CONTEXT_CODE="Interfaces"

Uploading the .ldt file:

$ FNDLOAD apps/password 0 Y UPLOAD @FND:patch/115/import/afffload.lct output.ldt

Filed Under: Oracle Apps

Some more articles you might also be interested in …

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

You May Also Like

Primary Sidebar

Recent Posts

  • protonvpn-cli Command Examples in Linux
  • protonvpn-cli connect Command Examples
  • procs Command Examples in Linux
  • prlimit: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright