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

Post a Comment

Popular posts from this blog

Queries For Oracle Interface Errors Records.

Below are the queries to get the error records information while processing interface data. AP Invoices:   SELECT    airl.last_update_date process_date,    HU.NAME,   nvl(ail.invoice_line_id,aii.invoice_id) process_id,   'AP' module,   'Import AP Invoice' interface_name,   aii.source source,   NVL(SUBSTR( ail.dist_code_concatenated,1,instr(ail.dist_code_concatenated,'.',1,1)-1),'ALL') company,   'ERROR' status,   ail.line_type_lookup_code ,   airl.parent_table ,   ail.description ,   NVL(ail.distribution_set_name,dist_code_concatenated) ,   pvsa.vendor_site_code ,   listagg(NVL(airl.reject_lookup_code,'AP_INV_ERROR') ,';') within group (order by NVL(airl.reject_lookup_code,'AP_INV_ERROR')) error_code,   listagg(flv.meaning,';')  within group (order by NVL(flv.meaning,'AP_INV_ERROR'))error_summary,   NULL error_details,   pv.vendor_name ,   pv.segment1 ,   aii.invoice_amount,   aii.i
Read more

Customising PO Output For Communication Report in Oracle Purchasing

Image
PO Print PDF Report: Oracle EBS provided  a standard functionality to print the PO report directly from the PO form itself by clicking tools menu and view PDF option. Once we select that option output will be rendered in PDF format in the browser instantly. Internally it will run the concurrent program 'PO Output For Communication'. This concurrent program is of JAVA type which will uses the seeded package  'PO_COMMUNICATION_PVT'  for generating the XML data and later this XML data will be processed and formatted by using the XSL template of data definition 'Standard Purchase Order Data Source' in case of standard PO's. Oracle by default will provide one standard BI publisher template for this. In case if we want to have custom layout for this report we can build a new template for the same data definition and this template has to be used while doing the setup for PO Document types. Creating Custom Template and Setup this for PO Document type: To c
Read more

Oracle APPS Useful Queries

                       ACCOUNT PAYABLES Payable Open Interface Rejection:   SELECT ail.* FROM AP_INVOICES_INTERFACE ai ,   ap_invoice_lines_interface ail ,   ap_interface_rejections AIR WHERE ai.GROUP_ID='EO_AUG-13_010813_443' AND ai.status    ='REJECTED' AND ai.invoice_id=ail.invoice_id   --and ail.dist_code_concatenated='66810-00-999-00000000-00000000-00000-FI100' AND air.parent_id = DECODE(air.parent_table,'AP_INVOICES_INTERFACE',AI.INVOICE_ID,'AP_INVOICE_LINES_INTERFACE',ail.invoice_line_id,NULL) ORDER BY 2; AP Invoices Query: /*+INDEX (AP_INVOICES_ALL [XXDG_TEST]) */ SELECT  apia.invoice_id,        alc.displayed_field "Invoice Type",        apia.invoice_num "Invoice Number",        apia.invoice_date "Invoice Date",        apia.gl_date   "Invoice GL Date",        nvl(apia.VOUCHER_NUM,doc_sequence_value)"Voucher Number",        apia.description inv_Description,  
Read more