Skip to main content

LDT Commands in Oracle Apps

 Oracle Applications (Oracle E-Business Suite) use Loader Data files (LDT files) for migrating application configurations and data between instances.

What are LDT Files?

LDT files are plain text files used by the FNDLOAD utility in Oracle E-Business Suite to upload or download data from the database. They are commonly used for migrating setups, such as concurrent programs, value sets, and lookups, across different environments.

LDT Commands:

1.        Download Data to LDT File

FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct output_file.ldt FND_PROGRAM APPLICATION_SHORT_NAME="Application_Short_Name" CONCURRENT_PROGRAM_NAME="Program_Name"

2.        Upload Data from LDT File

FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct input_file.ldt

Key Parameters

  • apps/apps_pwd: The username and password for the Oracle Apps database.
  • 0 Y: Standard flags for FNDLOAD (0 indicates no error checking, Y indicates 'Yes' for upload/download).
  • DOWNLOAD/UPLOAD: The action to perform.
  • $FND_TOP/patch/115/import/afcpprog.lct: The location and name of the control file (LCT file) which defines the data structure.
  • output_file.ldt/input_file.ldt: The LDT file to write to or read from.
  • FND_PROGRAM: The entity to download or upload.
  • APPLICATION_SHORT_NAME: The short name of the application.
  • CONCURRENT_PROGRAM_NAME: The name of the concurrent program.

 

Concurrent Program:

Download Script

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXCUSTITEMCATASSIGN_P.ldt PROGRAM APPLICATION_SHORT_NAME= "XXCUST" CONCURRENT_PROGRAM_NAME="XXCUSTITEMCATASSIGN"

Upload script

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

 

Data Definition / Template:

Download Script

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXCUST_COST_SHEET_DTL_RPT_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME= "XXCUST" DATA_SOURCE_CODE="XXCUST_COST_SHEET_DTL_RPT"

Upload script

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

 

Lookups:

Download Script

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

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XXCUST_IMPREST_TYPE.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

 

 

Forms:

Download Script

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt FORM APPLICATION_SHORT_NAME= "XXCUST" FORM_NAME="XXCUST_PETTYCASH_ADV"

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt

 

 

Forms Function:

Download Script

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt FUNCTION FUNC_APP_SHORT_NAME= "XXCUST" FUNCTION_NAME="XXCUST_PETTYCASH_ADV"

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_PETTYCASH_ADV.ldt

 

 

Form Personalization:

Download Script

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

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXCUST_APPR_LIST.ldt

 

Messages:

Download Script

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXCUST_CHARGE_UPDATE_MESSAGE.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME= "XXCUST" MESSAGE_NAME="XXCUST_CHARGE_UPDATE_MESSAGE"

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXCUST_CHARGE_UPDATE_MESSAGE.ldt

 

Oracle Alerts:

Download Script

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XXCUST_PETTYCASH_APPR_ADJ.ldt ALR_ALERTS APPLICATION_SHORT_NAME= "XXCUST" ALERT_NAME="XXCUST_PETTYCASH_APPR_ADJ"

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XXCUST_PETTYCASH_APPR_ADJ.ldt

 

 

Responsibility:

 

Download Script

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

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXCUST_CUSTOM_REPORTS.ldt

 

 

Menus:

Download Script

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

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXCUST_CUST_PR_MENU.ldt

 

Value set:

Download Script

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXCUSTL_OU_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XXCUSTL_OU"

Upload script

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXCUSTL_OU_VS.ldt

 

 


Comments

Popular posts from this blog

API to Create & Update Price Adjustment and Order Lines

Important Tables: select header_id from oe_order_headers_all; select line_id from oe_order_lines_all; select list_header_id from qp_list_headers_all; select list_line_id from qp_list_lines; CREATE OR REPLACE PROCEDURE apps.xxapply_discount (p_header_id number) IS    v_api_version_number           number := 1;    v_return_status                varchar2 (2000);    v_msg_count                    number;    v_msg_data                     varchar2 (2000);    -- in variables --    v_header_rec                   oe_order_pub.header_rec_type;    v_line_tbl                     oe_order_pub.line_tbl_type;    v_action_request_tbl   ...

Uninvoiced Receipts Query Oracle r12

Uninvoiced Receipts: SELECT   pha.segment1 po_number,          TO_CHAR (pha.creation_date, 'DD-MON-RRRR') po_date,          (SELECT   vendor_name             FROM   ap_suppliers ap            WHERE   ap.vendor_id = pha.vendor_id)             supplier_name,          pla.quantity,          pla.unit_price,          pla.quantity * pla.unit_price AS line_amount,          (SELECT   concatenated_segments             FROM   gl_code_combinations_kfv gcc            WHERE   gcc.code_combination_id = pda.code_combination_id)             charge_account,          rsh...