Monday, November 14, 2011

FNDLOAD, ADJVAPRG commands


Upload/Download XML Data definition, RTF Templates in Oracle from UNIX


Following FNDLOAD command is used to download XML Publisher Template, RTF template and Data Definition:-   

FNDLOAD apps/pwd@SID 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=<APPL SHORT NAME> DATA_SOURCE_CODE=<Data Definition Code>


Following ADJVAPRG command is used to upload XML Publisher RTF Template and Data Definition:-


$ADJVAPRG oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD <APPS PWD> -JDBC_CONNECTION <Node:Port:SID> -LOB_TYPE TEMPLATE -APPS_SHORT_NAME <APPL SHORT NAME> -LOB_CODE <XML Templ Def Code> -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -NLS_LANG AMERICAN -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME <RTF Template file name>.rtf


Following ADJVAPRG command is used to upload XML Bursting file to the Data Definition:-

$ADJVAPRG oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD <APPS PWD> -JDBC_CONNECTION  <Node:Port:SID> -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME <Appl Short Name> -LOB_CODE <Data Def Code> -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE XML -NLS_LANG AMERICAN -FILE_CONTENT_TYPE 'application/xml' -FILE_NAME  ./<XML Bursting File Name>.xml


Following ADJVAPRG command is used to upload XML Data Template file to the Data Definition:- 

$ADJVAPRG oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD <APPS PWD> -JDBC_CONNECTION  <Node:Port:SID> -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME <Appl Short Name> -LOB_CODE <Data Def Code> -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE XML -NLS_LANG AMERICAN -FILE_CONTENT_TYPE 'application/xml' -FILE_NAME  ./<Data Template File Name>.xml
---------------------------------------------------------------------------------------
 Upload/Download commands for Foundation objects in Oracle from UNIX

Following FNDLOAD command is used to associate concurrent program to an existing request group:-

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD @fnd:patch/115/import/afcpreqg.lct <output file>.ldt REQUEST_GROUP APPLICATION_SHORT_NAME=<RG's APP> REQUEST_GROUP_NAME=<RG's NAME> UNIT_NAME=<CP's SHORT NAME>

Note: We can include more than 1 concurrent program in the Request Group ldt file by using % in the UNIT_NAME, example:-

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD @fnd:patch/115/import/afcpreqg.lct <output file>.ldt REQUEST_GROUP APPLICATION_SHORT_NAME=<RG's APP> REQUEST_GROUP_NAME=<RG's NAME> UNIT_NAME="XX_TEST_CONC_PROG%"

Following FNDLOAD command is used to download Oracle Alert definition:- 

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct <output file>.ldt ALR_ALERTS ALERT_NAME=<Alert Name>

Following FNDLOAD command is used to download Lookup Type:-  


FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=<Appl Short Name> LOOKUP_TYPE=<lookup name>


There is an interesting point to note here, i.e., if you want to restrict the ldt file to only one or a set of lookup codes it is not possible using the FNDLOAD command. The workaround is, after the ldt file is generated using the above command, modify the ldt file and remove all the Lookup Code definitions that you do not want to migrate.


First you will find the Lookup Type definition, example as follows(do not remove this from the ldt):
BEGIN FND_LOOKUP_TYPE "PA" "XX_LOOKUP_TYPE"
  APPLICATION_SHORT_NAME = "XX"
  CUSTOMIZATION_LEVEL = "E"
  OWNER = "ORACLE"
  LAST_UPDATE_DATE = "2001/01/01"
  MEANING = "XX_LOOKUP_TYPE"
  DESCRIPTION =
 "XX Lookup Type do not remove this"


You will find the Lookup code definition for all the lookup codes in the lookup type in the ldt file, example as follows(remove all the lookup code definitions that you do not want to migrate, from BEGIN FND_LOOKUP_VALUE to END FND_LOOKUP_VALUE from the ldt):

  BEGIN FND_LOOKUP_VALUE "XX_LOOKUP_CODE"
    ENABLED_FLAG = "Y"
    START_DATE_ACTIVE = "2001/01/01"
    OWNER = "SVISHNU"
    LAST_UPDATE_DATE = "
2001/01/01"
    MEANING = "XX_LOOKUP_CODE"
    DESCRIPTION = "XX_LOOKUP_CODE"
  END FND_LOOKUP_VALUE


Save the ldt file and the ldt file is all set to migrate to the target instance.
Note:- If the Lookup Type already exists in the target instance, this ldt file will only add to the existing Lookup codes with the below mentioned UPLOAD Lookup command


Following FNDLOAD command is used to upload Oracle Alert definition:-  

FNDLOAD apps/pwd@seeddb 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt

Following FNDLOAD command is used to download Descriptive Flexfield:-
 
FNDLOAD apps/pwd@seeddb 0 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=<APP SHORT NAME> DESCRIPTIVE_FLEXFIELD_NAME=<Desc flex name P_CONTEXT_CODE=<context name>

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME=<DFF Name>



Following FNDLOAD command is used to upload Descriptive Flexfield:-

FNDLOAD apps/pwd@seeddb 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt

No comments:

Post a Comment