The FNDLOAD Utility uses different configuration files to download and upload different seed data types. This post will explain which configuration file (lct-file) is used for which defined seed data.
afcppstl.lct – Concurrent Program Printer Styles
STYLE
* NLS Upload only
– Download Parameters
— PRINTER_STYLE_NAME
aflvmlu.lct – Lookup types and codes
FND_LOOKUP_TYPE
– Sub-Entities
— FND_LOOKUP_VALUE
– Download Parameters
— VIEW_APPSNAME
— LOOKUP_TYPE
— SECURITY_GROUP
afffload.lct – Flexfield data
VALUE_SET
– Sub-Entities
— VSET_TABLE
— VSET_EVENT
– Download Parameters
— FLEX_VALUE_SET_NAME
DESC_FLEX
– Sub-Entities
— DFF_COLUMN
— DFF_REF_FIELD
— DFF_CONTEXT
— DFF_SEGMENT
– Download Parameters
— APPLICATION_SHORT_NAME
— DESCRIPTIVE_FLEXFIELD_NAME
— P_COLUMN_NAME
— P_REF_FIELD_NAME
— P_CONTEXT_CODE
— P_SEGMENT_NAME
— P_LEVEL
KEY_FLEX
– Sub-Entities
— KFF_COLUMN
— KFF_FLEX_QUAL
— KFF_SEGMENT_QUAL
— KFF_STRUCTURE
— KFF_WF_PROCESS
— KFF_SH_ALIAS
— KFF_CVR_RULE
— KFF_CVR_LINE
— KFF_SEGMENT
— KFF_FLEXQ_ASSIGN
— KFF_SEGQ_ASSIGN
– Download Parameters
— APPLICATION_SHORT_NAME
— ID_FLEX_CODE
— P_COLUMN_NAME
— P_FLEX_QUAL_NAME
— P_SEG_QUAL_NAME
— P_STRUCTURE_CODE
— P_WF_ITEM_TYPE
— P_SH_ALIAS_NAME
— P_CVR_RULE_NAME
— P_SEGMENT_NAME
— P_LEVEL
VALUE_SECURITY_RULE
– Sub-Entities
— VSEC_LINE
— VSEC_USAGE
– Download Parameters
— FLEX_VALUE_SET_NAME
— FLEX_VALUE_RULE_NAME
— PARENT_FLEX_VALUE_LOW
VALUE_ROLLUP_GROUP
– Download Parameters
— FLEX_VALUE_SET_NAME
— HIERARCHY_CODE
VALUE_SET_VALUE
– Sub-Entities
— VAL_NORM_HIERARCHY
— VAL_QUAL_VALUE
– Download Parameters
— FLEX_VALUE_SET_NAME
— PARENT_FLEX_VALUE_LOW
— FLEX_VALUE
afcpprog.lct – Concurrent Program Definitions
Includes flex entity definitions for concurrent program parameters. DO NOT use this config file directly to load flex data. Use afffload.lct configuration file.
PROGRAM
– Sub-Entities
— INCOMPATIBILITY
– Download Parameters
— CONCURRENT_PROGRAM_NAME
— APPLICATION_SHORT_NAME
EXECUTABLE
– Download Parameters
— EXECUTABLE_NAME
— APPLICATION_SHORT_NAME
afscprof.lct – Profiles and Profile Values
PROFILE
– Sub-Entities
— FND_PROFILE_OPTION_VALUES
– Download Parameters
— PROFILE_NAME
— APPLICATION_SHORT_NAME
afcpreqg.lct – Concurrent Request Groups
REQUEST_GROUP
– Sub-Entities
— REQUEST_GROUP_UNIT
– Download Parameters
— REQUEST_GROUP_NAME
— APPLICATION_SHORT_NAME
afcprset.lct – Concurrent Request Sets
REQ_SET
– Sub-Entities
— STAGE
– Download Parameters
— REQUEST_SET_NAME
— APPLICATION_SHORT_NAME
afscursp.lct – Security data (users, responsibilities, etc)
FND_USER
* Only upload if Apps schema passwords are identical
– Sub-Entities
— FND_USER_RESP_GROUPS
– Download Parameters
— USER_NAME
FND_SECURITY_GROUPS
– Download Parameters
— SECURITY_GROUP_KEY
FND_APPLICATION
* NLS Upload only
– Download Parameters
— APPLICATION_SHORT_NAME
FND_ORACLE_USERID
– Download Parameters
— ORACLE_USERNAME
FND_RESPONSIBILITY
– Sub-Entities
— FND_RESP_FUNCTIONS
– Download Parameters
— RESP_KEY
— APPLICATION_SHORT_NAME
FND_DATA_GROUPS
* NLS Upload only
– Sub-Entities
— FND_DATA_GROUP_UNITS
– Download Parameters
— DATA_GROUP_NAME
FND_ENABLED_PLSQL
– Download Parameters
— PLSQL_TYPE
— PLSQL_NAME
afsload.lct – Function Security Data
afsload.lct loads data for a Function and Data Security related entities:
- FORM
- FUNCTION
- MENU
- MENU_ENTRY
- OBJECT
- OBJECT_INSTANCE_SET
- GRANT
FORM
– Download Parameters
— APPLICATION_SHORT_NAME
— FORM_NAME
– Upload Parameter
— UPLOAD_MODE: NLS
FUNCTION
– Download Parameters
— FUNC_APP_SHORT_NAME
— FUNCTION_NAME
– Upload Parameter
— UPLOAD_MODE: NLS
MENU
– Sub-Entities
— ENTRY
– Download Parameters
— MENU_NAME
– Upload Parameter
— UPLOAD_MODE: NLS, MERGE and REPLACE
OBJECT
– Download Parameters
— OBJ_NAME
– Upload Parameter
— UPLOAD_MODE: NLS
OBJECT_INSTANCE_SET
– Download Parameters
— INSTANCE_SET_NAME
— INS_OBJ_NAME
– Upload Parameter
— UPLOAD_MODE: NLS
GRANT
– Download Parameters
— GNT_MENU_NAME
— GNT_ISN
— GNT_OBJ_NAME
– Upload Parameter
— UPLOAD_MODE: NLS, MERGE and REPLACE