FNDLOAD usage

Submitted by code_admin on Fri, 07/20/2018 - 13:15

Fetching and Loading objects from Forms

Concurrent request

Fetch

  1. 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

  1. 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

  1. 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

  1. 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

  1. 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

  1. 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

  1. 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

  1. FNDLOAD apps/<<APPSPASS>> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <<FORM_NAME>>_PER.ldt

Alert

Fetch

  1. 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

  1. 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

  1. conn apps/&1;
  2.  
  3. SET DEFINE OFF
  4. /
  5. PROMPT Adding Conc. Program TO request GROUP
  6. /
  7. set serveroutput on;
  8. BEGIN
  9.  
  10.    IF NOT FND_PROGRAM.PROGRAM_IN_GROUP(program_short_name  =>'ICGL_ORPHANCODES',
  11.                                     program_application => 'ICGL',
  12.                                     request_group       =>'GL Concurrent Program Group',
  13.                                     group_application   => 'SQLGL'
  14.                                     ) THEN
  15.      BEGIN
  16.           dbms_output.put_line('can''t find program - adding it');
  17.           FND_PROGRAM.ADD_TO_GROUP(program_short_name     =>'ICGL_ORPHANCODES',
  18.                                       program_application =>'ICGL',
  19.                                       request_group       =>'GL Concurrent Program Group',
  20.                                       group_application   => 'SQLGL'
  21.                                       );
  22.      EXCEPTION
  23.           WHEN OTHERS THEN
  24.                   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'));
  25.      END;
  26.   END IF;
  27. END;
  28. /
  29. PROMPT Finished Adding Conc. Program TO request GROUP
  30. /
  31. COMMIT;
  32. /
  33.  
  34. 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

Tags

RJM Article Type
Quick Reference