Key Oracle Apps scripts and commands

-- Uploading and downloading concurrent programs
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ldt_name.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="cp_short_name"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct ldt_name.ldt CUSTOM_MODE=FORCE


-- Responsibility from program name
select * from fnd_responsibility_tl where responsibility_id in(select responsibility_id from fnd_responsibility where request_group_id in(select request_group_id from fnd_request_group_units where request_unit_id in(select concurrent_program_id from fnd_concurrent_programs where concurrent_program_name like '%%')))

-- Responsibility from program name
select * from fnd_responsibility_tl where responsibility_id in (select responsibility_id from fnd_responsibility where request_group_id in (select request_group_id from fnd_request_group_units where request_unit_id in (select concurrent_program_id from fnd_concurrent_programs_tl where user_concurrent_program_name like '%')))
-- Executable from concurrent program name
select e.executable_name,e.execution_file_name from fnd_concurrent_programs c , fnd_concurrent_programs_tl ct, fnd_executables e where e.executable_id = c.executable_id and c.concurrent_program_id = ct.concurrent_program_id and ct.user_concurrent_program_name like '%%'

-- Getting primary key constraint
SELECT tbl2.column_name FROM all_constraints tbl1, all_cons_columns tbl2 WHERE tbl1.owner = 'OWNER_NAME' and tbl1.table_name LIKE UPPER('%%') AND tbl1.constraint_type = 'P' AND tbl1.owner = tbl2.owner AND tbl1.constraint_name = tbl2.constraint_name

-- Getting Initiating element from formula result rules element
select init_e.element_name initating_element ,res_e.element_name result_element,ff.formula_name,frr.RESULT_RULE_TYPEfrom PAY_FORMULA_RESULT_RULES_f frr, pay_element_types_f init_e, pay_element_types_f res_e, PAY_STATUS_PROCESSING_RULES_f psr, ff_formulas_f ffwhere frr.element_type_id = res_e.element_type_idand frr.status_processing_rule_id = psr.status_processing_rule_idand psr.element_type_id = init_e.element_type_idand ff.formula_id = psr.formula_idand res_e.element_name like 'GK403B3%'

Downloading AOL components
http://www.apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples

1 - Printer Styles
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2 - Lookups
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name"

3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=’COL_ALL:REF_ALL:CTX_ONE:SEG_ALL’ APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"
Examples:Note <274528.1> - Note How To Download Single Context Using FNDLOAD For Descriptive Flexfield.Note <256573.1> - How To Download/Upload Descriptive Flexfield With Name $SRS$.

4 - Key Flexfield Structures
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=’COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL’ APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

5 - Concurrent Programs
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"

6 - Value Sets
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

7 - Value Sets with values
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

8 - Profile Options
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

8 - Request Groups
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

10 - Request Sets
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SETAPPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"
Examples:Note <247126.1> - How To Download Request Set Definition From One Instance And Upload On Another Instance

11 - Responsibilities
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

12 - Menus
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"