Fetching and Loading objects from Forms
Concurrent request
Fetch
-
FNDLOAD apps/<<APPSPASS>> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <<CONCURRENTPROGRAM>>.ldt PROGRAM APPLICATION_SHORT_NAME="<<APPSHORTNAME>>" CONCURRENT_PROGRAM_NAME="<<CONCURRENTPROGRAM>>"
Load
-
FNDLOAD apps/<<APPSPASS>> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $ICFND_TOP/bin/IC_GL_EX_CROSS_VAL_RULES.ldt
BI Publisher XDO difinition
This is setup under responsibility XML Publisher Administrator -> Data Definitions
Fetch
-
FNDLOAD apps/<APPSPASS>> O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <<CONCURRENTPROGRAM>>_XDO.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=<<APPSHORTNAME>> DATA_SOURCE_CODE=<<CONCURRENTPROGRAM>>
Load
-
FNDLOAD apps/<APPSPASS>> O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ICGL_CODECOMB_XDO.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=ICGL DATA_SOURCE_CODE=ICGL_CODECOMB
Value sets
Fetch
-
FNDLOAD apps/<<APPSPASS>> O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct <<VALUESET_NAME>>_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="<<VALUESET_NAME>>"
Load
-
FNDLOAD apps/<<APPSPASS>> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct <<VALUESET NAME>>_VS.ldt
NOTE: Profile options are also loaded this way
Personalisation
Fetch
-
FNDLOAD apps/<<APPSPASS>> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <<FORM_NAME>>_PER.ldt FND_FORM_CUSTOM_RULES function_name="<<FUNCTION NAME>>"
load
-
FNDLOAD apps/<<APPSPASS>> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <<FORM_NAME>>_PER.ldt
Alert
Fetch
-
FNDLOAD apps/prj01app O Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct IC_HR_DATACORRUPTION_ASS_OVERLAP.ldt ALR_ALERTS APPLICATION_SHORT_NAME="ICHR" ALERT_NAME="IC_HR_DATACORRUPTION_ASS_OVERLAP"
Load
-
FNDLOAD apps/${APPS_PWD:-nothing} 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct $ICFND_TOP/bin/IC_HR_DATACORRUPTION_ASS_OVERLAP.ldt CUSEOM_MODE=FORCE
Add report to request group
-
conn apps/&1;
-
-
SET DEFINE OFF
-
/
-
PROMPT Adding Conc. Program TO request GROUP
-
/
-
set serveroutput on;
-
BEGIN
-
-
IF NOT FND_PROGRAM.PROGRAM_IN_GROUP(program_short_name =>'ICGL_ORPHANCODES',
-
program_application => 'ICGL',
-
request_group =>'GL Concurrent Program Group',
-
group_application => 'SQLGL'
-
) THEN
-
BEGIN
-
dbms_output.put_line('can''t find program - adding it');
-
FND_PROGRAM.ADD_TO_GROUP(program_short_name =>'ICGL_ORPHANCODES',
-
program_application =>'ICGL',
-
request_group =>'GL Concurrent Program Group',
-
group_application => 'SQLGL'
-
);
-
EXCEPTION
-
WHEN OTHERS THEN
-
DBMS_OUTPUT.put_line('Error occured while adding the program ICGL_ORPHANCODES to request group :'||SQLERRM || ':' || NVL(SUBSTR(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE,0,3000),'NULL'));
-
END;
-
END IF;
-
END;
-
/
-
PROMPT Finished Adding Conc. Program TO request GROUP
-
/
-
COMMIT;
-
/
-
-
exit;
Web sources
https://blogs.oracle.com/prajkumar/entry/oracle_fndload_scripts
See also
XML Publisher instructions - XML Publisher Instructions
Google Juice
Extract Export Form Valueset Program CR Concurrent Program fnd load
RJM Article Type
Quick Reference