Previous | Next | Contents | Index | Navigation | Glossary | Library |
Download database information to a text file
The text file is human-readable and portable, and can be examined and modified with any editor. Generally, a "developer key" is used to identify records written out to text files. In other words, the PROFILE_OPTION_NAME, not the PROFILE_OPTION_ID, is used to identify records.
Upload (merge) the information in a text file to the database
If a row is already correct in the database, it is not touched. If a row exists, but has different attributes, the row is updated. If a row does not exist, a new row is inserted. No rows are deleted, even if they are absent from the uploaded file.
These download and upload capabilities allow profile value information that is defined in one database to be easily propagated to other databases. This is useful for delivering Oracle Applications seed data to customers, as well as for copying customer profile definitions from a primary site to other sites.
The text file version of profile value data is also useful for bulk editing operations, which can be accomplished more efficiently with a text editor than with a form.
FNDVLOAD <username/password> 0 Y <appsname> <filename> UPLOAD | DOWNLOAD
where
<username/ password> | is the APPLSYS account |
<appsname> | is an application short name or "LOCAL" |
<filename> | is the file that will be read or written |
The location of the file is determined by the <appsname> and <filename> arguments. <appsname> indicates whether the file is in the install/import directory for a particular application, or whether it is in the local directory.
Appsname | File | Location |
---|---|---|
<APP> | <file> | $<APP_TOP>/install/import/<file>.slt |
LOCAL | <file> | <file> |
Table 1 - 33. (Page 1 of 1) |
FNDVLOAD applsys/fnd 0 Y FND install/import/FND.vlt UPLOAD
references file "$FND_TOP/install/import/FND.vlt"
FNDVLOAD applsys/fnd 0 Y FND.vlt UPLOAD
references file "FND.vlt"
FNDVLOAD applsys/fnd 0 Y FND FND.vlt DOWNLOAD
will download all profile values to the file FND.vlt
FNDVLOAD applsys/fnd 0 Y FND FND.vlt UPLOAD
will upload everything in the file FND.vlt to the database
The file consists of a series of text lines, each of which must be less than 1024 bytes in length (when written, no line will exceed 80 bytes in length).
A line may be a comment line, meaning it has no effect on the data contained in the file. Comment lines begin with a "#" and end with a newline.
# This is a comment line
The information in the file consists of a series of tokens delimited by white space. Note that a token may itself contain a space, in which case it is delimited with double-quote marks. Tokens may not contain non-printing characters unless they are preceded by the "escape" character, which is a backslash. Predefined escapes are:
String | Meaning |
---|---|
\e | Escape |
\n | Newline |
\r | Carriage return |
\b | Backspace |
\v | Vertical tab |
\f | Form feed |
\" | The double quote itself |
\\ | The backslash itself |
Table 1 - 34. (Page 2 of 2) |
The file starts with three lines as follows:
LANGUAGE = "AMERICAN" CODESET = "WE8ISO8859P1" TRANSLATED = "Y"
These lines indicate the NLS_LANG language and codeset of the file and the current translation status of any translated column values.
Then there is a series of object definitions of the format:
BEGIN <level type> <level identifier> PROFILE <profile name> = <profile value> ... END <level type>
There are four types of levels in the file: SITE, APPLICATION, RESPONSIBILITY, and USER. Each level type has some identifier, followed by a series of profile values. If a profile value is not specified on a given level, it will not be written to the file on a DOWNLOAD, and the current setting will not be changed on an UPLOAD.
BEGIN SITE PROFILE <profile name: 80 chars> = <profile value: 240 chars> ... END SITE
Example:
BEGIN SITE PROFILE ACCOUNT_ISSUE_TXN = 1 PROFILE AR_ADJUST_CREDIT_UNCONFIRMED_INVOICE = NONE PROFILE AR_ALLOW_BATCHING = B PROFILE AR_ALLOW_TAX_CODE_OVERRIDE = N PROFILE AR_ALLOW_TAX_UPDATE = Y PROFILE AR_CHANGE_CUST_NAME = Y PROFILE AR_CHANGE_CUST_ON_TRX = Y PROFILE AR_CMERGE_SET_SIZE = 1 PROFILE AR_GLPOST_BALANCE_CHECK_FLAG = Y PROFILE AR_ITEM_FLEXFIELD_MODE = M END SITE
BEGIN APPLICATION <applname> PROFILE <profile name: 80 chars> = <profile value: 240 chars> ... END APPLICATION
Example:
BEGIN APPLICATION BOM PROFILE CURRENCY:NEGATIVE_FORMAT = 3 PROFILE SHARED_MESG_APPL_ID = 700 END APPLICATION
BEGIN RESPONSIBILITY <applname> <respname> PROFILE <profile name: 80 chars> = <profile value: 240 chars> ... END RESPONSIBILITY
Example:
BEGIN RESPONSIBILITY AX "AX General Ledger User" PROFILE AX_APPLICATION_ID = 101 PROFILE AX_APPLICATION_NAME = "Oracle General Ledger" END RESPONSIBILITY
BEGIN USER <username> PROFILE <profile name: 80 chars> = <profile value: 240 chars ... END USER
Example:
BEGIN USER DATAMERGE PROFILE BOM:UPDATE_RESOURCE_UOM = 2 PROFILE QUICKPICK:AUTOREDUCTION = Y PROFILE SAVE_SEARCH_ITEMS = N END USER
# # $Header$ # LANGUAGE = "AMERICAN" CODESET = "US7ASCII" TRANSLATED = "Y"#
BEGIN SITE PROFILE ACCOUNT_ISSUE_TXN = 1 PROFILE AR_ADJUST_CREDIT_UNCONFIRMED_INVOICE = NONE PROFILE AR_ALLOW_BATCHING = B PROFILE AR_ALLOW_TAX_CODE_OVERRIDE = N PROFILE AR_ALLOW_TAX_UPDATE = Y PROFILE AR_CHANGE_CUST_NAME = Y PROFILE AR_CHANGE_CUST_ON_TRX = Y PROFILE AR_CMERGE_SET_SIZE = 1 PROFILE AR_GLPOST_BALANCE_CHECK_FLAG = Y PROFILE AR_ITEM_FLEXFIELD_MODE = M PROFILE AR_OVERRIDE_ADJUSTMENT_ACTIVITY_ACCOUNT = Y PROFILE AR_PA_CODE = 1 PROFILE AS_MANAGING_EMPLOYEE_HAS_ACCESS_FLAG = Y PROFILE AS_NOTES_UPDATE_DAY_RANGE = 1 PROFILE AS_TERR_MIN_NUM_PARALLEL_PROC = 100 PROFILE AS_TERR_NUM_CHILD_PROCESSES = 5 PROFILE ATCHMT_SET_INDICATOR = Y PROFILE AUDITTRAIL:ACTIVATE = N PROFILE AUTOCOMMIT = N PROFILE BASE_LANGUAGE = 0 PROFILE BOM:CHECK_DUPL_CONFIG = 2 PROFILE BOM:CONFIG_INHERIT_OP_SEQ = 2 PROFILE BOM:CONFIG_ITEM_DELIMITER = * PROFILE BOM:CONFIG_ITEM_TYPE = I PROFILE BOM:DEFAULT_BOM_LEVELS = 1 PROFILE BOM:ITEM_SEQUENCE_INCREMENT = 10 PROFILE BOM:MODEL_ITEM_ACCESS = 1 PROFILE BOM:PLANNING_ITEM_ACCESS = 1 PROFILE BOM:STANDARD_ITEM_ACCESS = 1 PROFILE BOM:UPDATE_RESOURCE_UOM = 2 PROFILE BUDGETARY_CONTROL_OPTION = 0 PROFILE CONC_COPIES = 0 PROFILE CONC_HOLD = N PROFILE CONC_PMON_METHOD = RDBMS PROFILE CONC_PRIORITY = 50 PROFILE CONC_REPORT_ACCESS_LEVEL = U PROFILE CONC_SAVE_OUTPUT = Y PROFILE CONC_SINGLE_THREAD = N PROFILE CST_EXCHANGE_RATE_TYPE = 2 PROFILE CST_RU_WAIT_FOR_LOCKS = 2 PROFILE CST_UPDATE_COSTS = 1 PROFILE CST_UPDATE_DEBUG = 1 PROFILE CST_VIEW_COSTS = 1 PROFILE CURRENCY:MIXED_PRECISION = 2 PROFILE CURRENCY:NEGATIVE_FORMAT = 0 PROFILE CURRENCY:POSITIVE_FORMAT = 0 PROFILE CURRENCY:THOUSANDS_SEPARATOR = Y PROFILE CURRENCY_CONVERSION_TYPE = Corporate PROFILE CYCLE_COUNT_APPROVALS_TXN = 1 PROFILE CYCLE_COUNT_ENTRIES_TXN = 1 PROFILE DIAGNOSTICS = N PROFILE DISPLAY_INVERSE_RATE = N PROFILE ENG:ENG_ITEM_ECN_ACCESS = 1 PROFILE ENG:MANDATORY_ECO_DEPT = 2 PROFILE ENG:MODEL_ITEM_ECN_ACCESS = 1 PROFILE ENG:PLANNING_ITEM_ECN_ACCESS = 1 PROFILE ENG:STANDARD_ITEM_ECN_ACCESS = 1 PROFILE ENG_SYSTEM_AUTONUMBERING = 2 END SITE
BEGIN APPLICATION BOM PROFILE CURRENCY:NEGATIVE_FORMAT = 3 PROFILE SHARED_MESG_APPL_ID = 700 END APPLICATION
BEGIN APPLICATION CRP PROFILE SHARED_MESG_APPL_ID = 700 END APPLICATION
BEGIN APPLICATION ENG PROFILE CURRENCY:NEGATIVE_FORMAT = 3 PROFILE SHARED_MESG_APPL_ID = 700 END APPLICATION
BEGIN APPLICATION INV PROFILE INV_STATUS_DEFAULT = Active PROFILE INV_UOM_DEFAULT = Each END APPLICATION
BEGIN APPLICATION MRP PROFILE CURRENCY:NEGATIVE_FORMAT = 3 PROFILE SHARED_MESG_APPL_ID = 700 END APPLICATION
BEGIN APPLICATION PA PROFILE PA_NUM_CDL_PER_SET = 2000 PROFILE PA_NUM_EXPENDITURES_PER_SET = 500 PROFILE PA_NUM_EXP_ITEMS_PER_SET = 1000 PROFILE PA_RULE_BASED_OPTIMIZER = N PROFILE PA_STRMLN_SLEEP_INTERVAL = 60 END APPLICATION
BEGIN APPLICATION PAY PROFILE DATETRACK:DELETE_MODE = PROMPT PROFILE DATETRACK:ENABLED = Y PROFILE DATETRACK:OVERRIDE_MODE = PROMPT PROFILE DATETRACK:UPDATE_MODE = PROMPT PROFILE HR_USER_TYPE = INT PROFILE PER_BUSINESS_GROUP_ID = 0 END APPLICATION
BEGIN APPLICATION QA PROFILE QA_ACTION_PROCESSING_MODE = 2 PROFILE QA_BLIND_ENTRY = 2 END APPLICATION
BEGIN RESPONSIBILITY AX "AX General Ledger User" PROFILE AX_APPLICATION_ID = 101 PROFILE AX_APPLICATION_NAME = "Oracle General Ledger" END RESPONSIBILITY
BEGIN RESPONSIBILITY AX "AX Payables Supervisor" PROFILE AX_APPLICATION_NAME = "Oracle Payables" END RESPONSIBILITY
BEGIN RESPONSIBILITY AX "AX Payables User" PROFILE AX_APPLICATION_NAME = "Oracle Payables" END RESPONSIBILITY
BEGIN RESPONSIBILITY AX "AX Receivables Supervisor" PROFILE AX_APPLICATION_NAME = "Oracle Receivables" END RESPONSIBILITY
BEGIN RESPONSIBILITY AX "AX Receivables User" PROFILE AX_APPLICATION_NAME = "Oracle Receivables" END RESPONSIBILITY
BEGIN RESPONSIBILITY CN "Sales Compensation Super User" PROFILE CN_ALLOW_CREATE_PAYRUNS = Y END RESPONSIBILITY
BEGIN RESPONSIBILITY PA "PB Accounting Supervisor" PROFILE PA_SUPER_PROJECT = Y END RESPONSIBILITY
BEGIN RESPONSIBILITY PA "PB Administrator" PROFILE PA_SUPER_PROJECT = Y END RESPONSIBILITY
BEGIN RESPONSIBILITY PA "PC Accounting Supervisor" PROFILE PA_SUPER_PROJECT = Y END RESPONSIBILITY
BEGIN RESPONSIBILITY PA "PC Administrator" PROFILE PA_SUPER_PROJECT = Y END RESPONSIBILITY
BEGIN RESPONSIBILITY PAY "Oracle Human Resources with Payroll" PROFILE HR_USER_TYPE = INT END RESPONSIBILITY
BEGIN RESPONSIBILITY PER "Oracle Human Resources" PROFILE HR_USER_TYPE = PER END RESPONSIBILITY
BEGIN RESPONSIBILITY QA Quality PROFILE QA_BLIND_ENTRY = 2 END RESPONSIBILITY
BEGIN RESPONSIBILITY SQLGL "General Ledger Budget User" PROFILE CONC_SINGLE_THREAD = N END RESPONSIBILITY
BEGIN RESPONSIBILITY SQLGL "General Ledger Supervisor" PROFILE CONC_SINGLE_THREAD = N END RESPONSIBILITY
BEGIN USER DATAMERGE PROFILE BOM:UPDATE_RESOURCE_UOM = 2 PROFILE QUICKPICK:AUTOREDUCTION = Y PROFILE SAVE_SEARCH_ITEMS = N END USER
BEGIN USER SYSADMIN PROFILE SHARED_MESG_APPL_ID = 700 END USER
Previous | Next | Contents | Index | Navigation | Glossary | Library |