Skip to main content

LDT Commands

1. Lookups
== =============
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"


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


2. Concurrent Program
== =============================
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_BLOG_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"


FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_BLOG_CP.ldt = WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


3. Profile
== =========
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_BLOG_PRF.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST"


$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_BLOG_PRF.ldt = WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


4. Request Set and Link
== ==============================
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_BLOG_RS.ldt REQ_SET REQUEST_SET_NAME='REQUEST_SET_NAME'


FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_BLOG_RS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


5. FND Message
== =====================
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_BLOG_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="MESSAGE_NAME%"


FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_BLOG_MESG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


6. D2K FORMS
== ==================
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_BLOG_FRM.ldt FORM FORM_NAME="FORM_NAME"


$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_BLOG_FRM.ldt = WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


7. Form Function
== =====================
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_BLOG_FUNC.ldt FUNCTION FUNCTION_NAME="FORM_FUNCTION_NAME"


$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_BLOG_FUNC.ldt = WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


8. Alerts
== =========
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_BLOG_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX = Alert Name"


FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_BLOG_ALR.ldt CUSTOM_MODE=FORCE


9. Value Set
== ==============
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_BLOG_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name"


$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_BLOG_VS.ldt = WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


10. Data Definition and Associated Template
=== ==========================================================
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XX_BLOG_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XX_SOURCE_CODE' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_SOURCE_CODE'


FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_BLOG_DD.ldt


11. DATA_TEMPLATE (Data Source .xml file)
=== ==========================================================
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD =DB_USERNAME apps =DB_PASSWORD apps =JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' =LOB_TYPE DATA_TEMPLATE =LOB_CODE XX_TEMPLATE =APPS_SHORT_NAME XXCUST =LANGUAGE en =lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct =LOG_FILE $LOG_FILE_NAME


java oracle.apps.xdo.oa.util.XDOLoader UPLOAD =DB_USERNAME apps =DB_PASSWORD apps =JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' =LOB_TYPE DATA_TEMPLATE =LOB_CODE XX_TEMPLATE =XDO_FILE_TYPE XML =FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml =APPS_SHORT_NAME XXCUST =NLS_LANG en =TERRITORY US =LOG_FILE $LOG_FILE_NAME


12. RTF TEMPLATE (Report Layout .rtf file)
=== =======================================================
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD =DB_USERNAME apps =DB_PASSWORD apps =JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' =LOB_TYPE TEMPLATE =LOB_CODE XX_TEMPLATE =APPS_SHORT_NAME XXCUST =LANGUAGE en =TERRITORY US =lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct =LOG_FILE $LOG_FILE_NAME


java oracle.apps.xdo.oa.util.XDOLoader UPLOAD =DB_USERNAME apps =DB_PASSWORD apps =JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' =LOB_TYPE TEMPLATE =LOB_CODE XX_TEMPLATE =XDO_FILE_TYPE RTF =FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf =APPS_SHORT_NAME XXCUST =NLS_LANG en =TERRITORY US =LOG_FILE $LOG_FILE_NAME

Labels:

Comments

Post a Comment

Popular posts from this blog

How to setup and use AME - Approval Management Engine

Approval Management Engine - AME For Purchase Requisition Approvals Purchase Requisitions can be routed for approval using the AME Approval Management Engine. This whitepaper describes how to setup AME for use with requisition approvals, and shows how a requisition approval list is built based on the AME setup. Approvers in the AME based approver list are assigned to the requisition based on the AME rules setup for the Purchase Requisition Approval transaction. Similar setup can be done for Requester Change Order Approval and for Internal Requisition Approval, although those are not specifically covered in this whitepaper. The screenshots provided are based on 11i.AME.B, and some of the navigation details are specific to 11i.AME.B. However, most of the details provided are applicable to 11i.AME.A and higher including R12. Assign AME Roles and Responsibilities AME responsibilities in 11i.AME.A are assigned directly to the users. However, In R12 or 11i.AME.B and higher, AME respons
Post a Comment
Read more

How to compile all INVALID objects in Oracle

There are five ways to recompile invalid objects in schema. DBMS_DDL DBMS_UTILITY UTL_RECOMP UTLRP.SQL Manually Recompile > Best Approach 1. DBMS_DDL This procedure is equivalent to the following SQL statement: ALTER PROCEDUREFUNCTIONPACKAGE [.] COMPILE [BODY] Syntax Exec dbms_ddl.alter_compile ( type , schema, name); Type : Must be either PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY or TRIGGER. Schema : Database Username Name : Objects name Example SQL> exec dbms_ddl.alter_compile ('PROCEDURE','SCOTT','TEST'); PL/SQL procedure successfully completed. 2. DBMS_UTILITY This procedure compiles all procedures, functions, packages, and triggers in the specified schema. Syntax Exec dbms_utility.compile_schema ( schema,compile all) Schema : Database Username Compile All : Object type ( procedure, function, packages,trigger) Example SQL> exec dbms_utility.compile_schema('SCOTT'); PL/SQL procedure successfully co
Post a Comment
Read more

Workflow Important Debug Queries

deq_time is not always populated in WF_DEFERRED. The best way to monitor is to check if there are any READY events select msg_state,count(*) from applsys.aq$wf_deferred  group by msg_state; For getting Item_Type and Display name for Runnable processes. SELECT WFA_ACT.ITEM_TYPE ITEM_TYPE ,   WFA_ACT.NAME PROCESS_NAME ,   WFA_ACT.DISPLAY_NAME DISPLAY_NAME FROM wf_activities_vl wfa_act WHERE wfa_act.runnable_flag = 'Y' AND wfa_act. type            = 'PROCESS' AND sysdate BETWEEN wfa_act.begin_date AND NVL(wfa_act.end_date, sysdate); Query to find records that are pending in each of the workflow agent listener queues SELECT 'select ''' || t.component_name || ' (queue_table: ' || p.queue_table ||        ')''||'' Count: ''||count(*) c from ' || p.owner || '.' || .queue_table ||        ' where deq_time is null and nvl(delay,enq_time)<sysdate-1/24  ||        nvl2(t.correlation_id,    
Post a Comment
Read more