This discussion is archived
2 Replies Latest reply: Dec 4, 2012 3:51 AM by 977192 RSS

Unable to generate proper LDTs using mks toolkit on windows server.

977192 Newbie
Currently Being Moderated
Hi Experts,

We have installed EBS12.0.3 on windows XP platforms and to access the unix commands we are using mks toolkit verison 9.2

But we are not able to generate the correct ldt files for data migration.

The fndload command used to download ldt for alert is as mentioned below:

FNDLOAD apps/apps 0 Y DOWNLOAD %ALR_TOP%/patch/115/import/alr.lct FILE_NAME.ldt ALR_ALERTS APPLICATION_SHORT_NAME='PER' Alert_name='XX Alert Name'

The generated ldt file is:

# $Header$

# dbdrv: exec fnd bin FNDLOAD bin &phase=daa+52 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @ALR:patch/115/import/alr.lct @~PROD:~PATH/~FILE
LANGUAGE = "US"
LDRCONFIG = "alr.lct"

#Source Database ODEV

#RELEASE_NAME 12.1.3

# -- Begin Entity Definitions --

DEFINE ALR_ALERTS
KEY APPLICATION_SHORT_NAME VARCHAR2(50)
KEY ALERT_NAME VARCHAR2(50)
CTX OWNER VARCHAR2(4000)
BASE ALERT_CONDITION_TYPE VARCHAR2(1)
BASE ENABLED_FLAG VARCHAR2(1)
BASE START_DATE_ACTIVE VARCHAR2(25)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE TABLE_APPLICATION_SHORT_NAME VARCHAR2(50)
BASE DESCRIPTION VARCHAR2(240)
BASE FREQUENCY_TYPE VARCHAR2(1)
BASE WEEKLY_CHECK_DAY VARCHAR2(3)
BASE MONTHLY_CHECK_DAY_NUM VARCHAR2(50)
BASE DAYS_BETWEEN_CHECKS VARCHAR2(50)
BASE CHECK_BEGIN_DATE VARCHAR2(25)
BASE DATE_LAST_CHECKED VARCHAR2(25)
BASE INSERT_FLAG VARCHAR2(1)
BASE UPDATE_FLAG VARCHAR2(1)
BASE DELETE_FLAG VARCHAR2(1)
BASE MAINTAIN_HISTORY_DAYS VARCHAR2(50)
BASE CHECK_TIME VARCHAR2(50)
BASE CHECK_START_TIME VARCHAR2(50)
BASE CHECK_END_TIME VARCHAR2(50)
BASE SECONDS_BETWEEN_CHECKS VARCHAR2(50)
BASE CHECK_ONCE_DAILY_FLAG VARCHAR2(1)
BASE SQL_STATEMENT_TEXT VARCHAR2(32000)
BASE ONE_TIME_ONLY_FLAG VARCHAR2(50)
BASE TABLE_NAME VARCHAR2(31)
BASE LAST_UPDATE_DATE VARCHAR2(10)

DEFINE ALR_RESPONSE_SETS
KEY RESP_SET_NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
BASE DESCRIPTION VARCHAR2(240)
BASE ENABLED_FLAG VARCHAR2(1)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE LAST_UPDATE_DATE VARCHAR2(10)

DEFINE ALR_RESPONSE_VARIABLES
KEY RESP_VAR_NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
BASE DESCRIPTION VARCHAR2(240)
BASE TYPE VARCHAR2(1)
BASE DEFAULT_VALUE VARCHAR2(240)
BASE DATA_TYPE VARCHAR2(1)
BASE DETAIL_MAX_LEN VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_RESPONSE_VARIABLES

DEFINE ALR_RESPONSE_ACTIONS
KEY RESPONSE_NAME VARCHAR2(240)
KEY SEQUENCE VARCHAR2(50)
CTX OWNER VARCHAR2(4000)
BASE ACTION_NAME VARCHAR2(80)
BASE ENABLED_FLAG VARCHAR2(1)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_RESPONSE_ACTIONS

DEFINE ALR_VALID_RESPONSES
KEY RESPONSE_NAME VARCHAR2(240)
CTX OWNER VARCHAR2(4000)
BASE TYPE VARCHAR2(1)
BASE RESPONSE_TEXT VARCHAR2(32000)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_VALID_RESPONSES
END ALR_RESPONSE_SETS

DEFINE ALR_ACTION_SETS
KEY NAME VARCHAR2(50)
CTX OWNER VARCHAR2(4000)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE ENABLED_FLAG VARCHAR2(1)
BASE RECIPIENTS_VIEW_ONLY_FLAG VARCHAR2(1)
BASE DESCRIPTION VARCHAR2(240)
BASE SUPPRESS_FLAG VARCHAR2(1)
BASE SUPPRESS_DAYS VARCHAR2(50)
BASE SEQUENCE VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)

DEFINE ALR_ACTION_SET_MEMBERS
CTX OWNER VARCHAR2(4000)
BASE ACTION_NAME VARCHAR2(80)
BASE GROUP_NAME VARCHAR2(80)
BASE GROUP_TYPE VARCHAR2(1)
BASE SEQUENCE VARCHAR2(50)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE ENABLED_FLAG VARCHAR2(1)
BASE SUMMARY_THRESHOLD VARCHAR2(50)
BASE ABORT_FLAG VARCHAR2(1)
BASE ERROR_ACTION_SEQUENCE VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ACTION_SET_MEMBERS

DEFINE ALR_ACTION_SET_OUTPUTS
KEY ACTION_SET_OUTPUT_NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
BASE SEQUENCE VARCHAR2(50)
BASE SUPPRESS_FLAG VARCHAR2(1)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ACTION_SET_OUTPUTS

DEFINE ALR_ACTION_SET_INPUTS
KEY ACTION_SET_INPUT_NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
BASE VALUE VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ACTION_SET_INPUTS
END ALR_ACTION_SETS

DEFINE ALR_ACTION_GROUPS
KEY NAME VARCHAR2(80)
KEY GROUP_TYPE VARCHAR2(1)
CTX OWNER VARCHAR2(4000)
BASE ACTION_GROUP_TYPE VARCHAR2(1)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE ENABLED_FLAG VARCHAR2(1)
BASE DESCRIPTION VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)

DEFINE ALR_ACTION_GROUP_MEMBERS
CTX OWNER VARCHAR2(4000)
BASE ACTION_NAME VARCHAR2(80)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE ENABLED_FLAG VARCHAR2(1)
BASE ACTION_LEVEL VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ACTION_GROUP_MEMBERS
END ALR_ACTION_GROUPS

DEFINE ALR_ACTIONS
KEY ACTION_NAME VARCHAR2(80)
KEY ACTION_END_DATE_ACTIVE VARCHAR2(25)
CTX OWNER VARCHAR2(4000)
BASE ACTION_TYPE VARCHAR2(1)
BASE ENABLED_FLAG VARCHAR2(1)
BASE DESCRIPTION VARCHAR2(240)
BASE ACTION_LEVEL_TYPE VARCHAR2(1)
BASE DATE_LAST_EXECUTED VARCHAR2(25)
BASE FILE_NAME VARCHAR2(240)
BASE ARGUMENT_STRING VARCHAR2(240)
BASE PROGRAM_APPLICATION_NAME VARCHAR2(50)
BASE CONCURRENT_PROGRAM_NAME VARCHAR2(30)
BASE LIST_APPLICATION_NAME VARCHAR2(50)
BASE LIST_NAME VARCHAR2(30)
BASE TO_RECIPIENTS VARCHAR2(240)
BASE CC_RECIPIENTS VARCHAR2(240)
BASE BCC_RECIPIENTS VARCHAR2(240)
BASE PRINT_RECIPIENTS VARCHAR2(240)
BASE PRINTER VARCHAR2(30)
BASE SUBJECT VARCHAR2(240)
BASE REPLY_TO VARCHAR2(240)
BASE RESPONSE_SET_NAME VARCHAR2(30)
BASE FOLLOW_UP_AFTER_DAYS VARCHAR2(50)
BASE COLUMN_WRAP_FLAG VARCHAR2(1)
BASE MAXIMUM_SUMMARY_MESSAGE_WIDTH VARCHAR2(50)
BASE BODY VARCHAR2(2000)
BASE VERSION_NUMBER VARCHAR2(50)
BASE LAST_UPDATE_DATE VARCHAR2(10)

DEFINE ALR_ACTION_OUTPUTS
KEY ACTION_OUT_NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
BASE CRITICAL_FLAG VARCHAR2(1)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ACTION_OUTPUTS
END ALR_ACTIONS

DEFINE ALR_ALERT_OUTPUTS
KEY NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
BASE SEQUENCE VARCHAR2(50)
BASE ENABLED_FLAG VARCHAR2(1)
BASE START_DATE_ACTIVE VARCHAR2(25)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE TITLE VARCHAR2(240)
BASE DETAIL_MAX_LEN VARCHAR2(50)
BASE SUMMARY_MAX_LEN VARCHAR2(50)
BASE DEFAULT_SUPPRESS_FLAG VARCHAR2(1)
BASE FORMAT_MASK VARCHAR2(30)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ALERT_OUTPUTS

DEFINE ALR_ALERT_INSTALLATIONS
KEY ORACLE_USERNAME VARCHAR2(30)
KEY DATA_GROUP_NAME VARCHAR2(240)
CTX OWNER VARCHAR2(4000)
BASE ENABLED_FLAG VARCHAR2(1)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ALERT_INSTALLATIONS

DEFINE ALR_ALERT_INPUTS
KEY NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
BASE ENABLED_FLAG VARCHAR2(1)
BASE START_DATE_ACTIVE VARCHAR2(25)
BASE END_DATE_ACTIVE VARCHAR2(25)
BASE TITLE VARCHAR2(240)
BASE DATA_TYPE VARCHAR2(1)
BASE DEFAULT_VALUE VARCHAR2(240)
BASE LAST_UPDATE_DATE VARCHAR2(10)
END ALR_ALERT_INPUTS
END ALR_ALERTS

# -- End Entity Definitions --


The same command works fine on linux using putty.
Am I missing anything or the issue might be because of the windows platform.
Please help us.

Thanks & Regards.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points