Wednesday, October 22, 2008

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"

2 comments:

oraclefusion said...

good article about the oracle concepts more more information visit
oracle Fusion

oracle fusion said...

Nice article and explanation is good,Thank you for sharing your experience on oracle concepts.It is very useful and informative article.For more details please visit our website.

Oracle Fusion HCM Online Training