FND LOAD Commands For Migration in Oracle Apps


FNDLOAD apps/appspasword 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXNGP_AR_TXN_UPD_EXCISE_INV.ldt PROGRAM APPLICATION_SHORT_NAME="XXNGP" CONCURRENT_PROGRAM_NAME="XXNGP_AR_TXN_UPD_EXCISE_INV"

FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXNGP_AR_TXN_UPD_EXCISE_INV.ldt PROGRAM APPLICATION_SHORT_NAME="XXNGP" CONCURRENT_PROGRAM_NAME="XXNGP_AR_TXN_UPD_EXCISE_INV"




Concurrent Program Download:

FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXNGPPREPAYINV.ldt PROGRAM APPLICATION_SHORT_NAME="XXNGP" CONCURRENT_PROGRAM_NAME="XXNGPPREPAYINV"

Upload:

FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXNGP57F4.ldt

Download a particular data definitions and its corresponding Templates:

FNDLOAD apps/appspwd@Hoststring 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXNGPPREPAYINV_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXNGP DATA_SOURCE_CODE=XXNGPPREPAYINV

Upload the data definitions and its corresponding Templates to an instance:

FNDLOAD apps/appspwd 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXNGP57F4_DD.ldt


Printer Styles:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

Lookups:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXNGP57F4_REPORT_COPIES.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXNGP" LOOKUP_TYPE="XXNGP57F4_REPORT_COPIES"

Descriptive Flexfield:

FNDLOAD apps/apps 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="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

Key Flexfield Structures:

FNDLOAD apps/apps 0 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"

Value Sets with values:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

Profile Options:

 FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

Request Groups:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

Request Sets:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET
APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"

Responsibilities:

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

Menus:

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

Forms Personalization:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES function_name=FUNCTION_NAME



Running the Fndload From the PL/SQL Procedure:



DECLARE
req_id fnd_concurrent_requests.request_id%TYPE;
BEGIN
fnd_global.apps_initialize(
user_id => 50515
,resp_id => 20420
,resp_appl_id => 1
);
req_id :=
fnd_request.submit_request
(application => ‘FND’
,program => ‘FNDLOAD’
,description => NULL
,start_time => NULL
,sub_request => FALSE
,argument1 => ‘DOWNLOAD’ —Mode - UPLOAD
,argument2 => ‘@fnd:patch/115/import/afcpque.lct’ —LCT File
,argument3 => ‘/tmp/concqueues.ldt’ —holding the data file directory 
,argument4 => ‘QUEUE’
,argument5 => ‘APPLICATION_SHORT_NAME=FND’
,argument6 => ‘CONCURRENT_QUEUE_NAME=STANDARD’
);
DBMS_OUTPUT.put_line(’req_id= ‘||req_id);
COMMIT;
END;

this ABOVE IS equivalent to: 
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpque.lct /tmp/concqueues.ldt QUEUE APPLICATION_SHORT_NAME=FND CONCURRENT_QUEUE_NAME=STANDARD

Comments

Popular posts from this blog

Oracle APPS Useful Queries

How to Apply Timers In Forms

Unix Shell Script For Oracle Apps