| Problems Uploading with FNDLOAD [message #282816] |
Fri, 23 November 2007 16:33  |
trowsdale
Messages: 17
Registered: April 2005
|
Junior Member |
|
|
Platform: Oracle Applications 11.5.9
Hi,
We are having problems when trying to upload Concurrent Programs with FNDLOAD.
We have no trouble downloading the LDT file.
When uploading, these sections of the LDT work correctly:
- BEGIN EXECUTABLE.....
- BEGIN VALUE_SET.....
However, these sections don't seem to be working, or only work partially:
- BEGIN DESC_FLEX...
- BEGIN PROGRAM...
Specifically, the Concurrent Program Parameters are not being updated (not being added to, or removed when needed).
(Please refer to the attached LDT file)
Thanks for any help!
Bill Trowsdale
# $Header$
# dbdrv: exec fnd bin FNDLOAD bin &phase=daa+56 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @~PROD:~PATH/~FILE
LANGUAGE = "US"
LDRCONFIG = "afcpprog.lct 115.40"
#Source Database fintd1
#RELEASE_NAME 11.5.9
# -- Begin Entity Definitions --
DEFINE PROGRAM
KEY CONCURRENT_PROGRAM_NAME VARCHAR2(30)
KEY APPLICATION_SHORT_NAME VARCHAR2(50)
CTX OWNER VARCHAR2(4000)
BASE LAST_UPDATE_DATE VARCHAR2(75)
TRANS USER_CONCURRENT_PROGRAM_NAME VARCHAR2(240)
BASE EXEC REFERENCES EXECUTABLE
BASE EXECUTION_METHOD_CODE VARCHAR2(1)
BASE ARGUMENT_METHOD_CODE VARCHAR2(1)
BASE QUEUE_CONTROL_FLAG VARCHAR2(1)
BASE QUEUE_METHOD_CODE VARCHAR2(1)
BASE REQUEST_SET_FLAG VARCHAR2(1)
BASE ENABLED_FLAG VARCHAR2(1)
BASE PRINT_FLAG VARCHAR2(1)
BASE RUN_ALONE_FLAG VARCHAR2(1)
BASE SRS_FLAG VARCHAR2(1)
TRANS DESCRIPTION VARCHAR2(240)
BASE CLASS_APPLICATION VARCHAR2(50)
BASE CONCURRENT_CLASS_NAME VARCHAR2(30)
BASE EXECUTION_OPTIONS VARCHAR2(250)
BASE SAVE_OUTPUT_FLAG VARCHAR2(1)
BASE REQUIRED_STYLE VARCHAR2(1)
BASE OUTPUT_PRINT_STYLE VARCHAR2(30)
BASE PRINTER_NAME VARCHAR2(30)
BASE MINIMUM_WIDTH VARCHAR2(50)
BASE MINIMUM_LENGTH VARCHAR2(50)
BASE REQUEST_PRIORITY VARCHAR2(50)
BASE ATTRIBUTE_CATEGORY VARCHAR2(30)
BASE ATTRIBUTE1 VARCHAR2(150)
BASE ATTRIBUTE2 VARCHAR2(150)
BASE ATTRIBUTE3 VARCHAR2(150)
BASE ATTRIBUTE4 VARCHAR2(150)
BASE ATTRIBUTE5 VARCHAR2(150)
BASE ATTRIBUTE6 VARCHAR2(150)
BASE ATTRIBUTE7 VARCHAR2(150)
BASE ATTRIBUTE8 VARCHAR2(150)
BASE ATTRIBUTE9 VARCHAR2(150)
BASE ATTRIBUTE10 VARCHAR2(150)
BASE ATTRIBUTE11 VARCHAR2(150)
BASE ATTRIBUTE12 VARCHAR2(150)
BASE ATTRIBUTE13 VARCHAR2(150)
BASE ATTRIBUTE14 VARCHAR2(150)
BASE ATTRIBUTE15 VARCHAR2(150)
BASE OUTPUT_FILE_TYPE VARCHAR2(4)
BASE RESTART VARCHAR2(1)
BASE NLS_COMPLIANT VARCHAR2(1)
BASE CD_PARAMETER VARCHAR2(240)
BASE INCREMENT_PROC VARCHAR2(61)
BASE MLS_EXEC REFERENCES EXECUTABLE
BASE ENABLE_TIME_STATISTICS VARCHAR2(1)
BASE SECURITY_GROUP_NAME VARCHAR2(30)
BASE RESOURCE_CONSUMER_GROUP VARCHAR2(30)
BASE ROLLBACK_SEGMENT VARCHAR2(30)
BASE OPTIMIZER_MODE VARCHAR2(30)
BASE REFRESH_PORTLET VARCHAR2(1)
BASE ACTIVITY_SUMMARIZER VARCHAR2(51)
BASE PROGRAM_TYPE VARCHAR2(1)
BASE ALLOW_MULTIPLE_PENDING_REQUEST VARCHAR2(1)
BASE SRS_FLEX REFERENCES DESC_FLEX
BASE AUTO_ANNOTATION VARCHAR2(32000)
BASE TEMPLATE_APPL_SHORT_NAME VARCHAR2(50)
BASE TEMPLATE_CODE VARCHAR2(80)
DEFINE ANNOTATION
KEY CONCURRENT_PROGRAM_NAME3 VARCHAR2(30)
KEY APPLICATION_SHORT_NAME3 VARCHAR2(50)
CTX OWNER VARCHAR2(4000)
BASE LAST_UPDATE_DATE VARCHAR2(75)
BASE PROGRAM_ANNOTATION VARCHAR2(32000)
END ANNOTATION
DEFINE INCOMPATABILITY
KEY CONCURRENT_PROGRAM_NAME2 VARCHAR2(30)
KEY APPLICATION_SHORT_NAME2 VARCHAR2(50)
CTX OWNER VARCHAR2(4000)
BASE LAST_UPDATE_DATE VARCHAR2(75)
BASE RUNNING_TYPE VARCHAR2(1)
BASE TO_RUN_TYPE VARCHAR2(1)
BASE INCOMPATIBILITY_TYPE VARCHAR2(1)
END INCOMPATABILITY
END PROGRAM
DEFINE EXECUTABLE
KEY EXECUTABLE_NAME VARCHAR2(30)
KEY APPLICATION_SHORT_NAME VARCHAR2(50)
CTX OWNER VARCHAR2(4000)
BASE LAST_UPDATE_DATE VARCHAR2(75)
BASE EXECUTION_METHOD_CODE VARCHAR2(1)
BASE EXECUTION_FILE_NAME VARCHAR2(61)
BASE SUBROUTINE_NAME VARCHAR2(30)
BASE EXECUTION_FILE_PATH VARCHAR2(510)
TRANS USER_EXECUTABLE_NAME VARCHAR2(240)
TRANS DESCRIPTION VARCHAR2(240)
END EXECUTABLE
DEFINE DESC_FLEX
KEY APPLICATION_SHORT_NAME VARCHAR2(50)
KEY DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE TABLE_APPLICATION_SHORT_NAME VARCHAR2(50)
BASE APPLICATION_TABLE_NAME VARCHAR2(30)
BASE CONTEXT_COLUMN_NAME VARCHAR2(30)
BASE CONTEXT_REQUIRED_FLAG VARCHAR2(1)
BASE CONTEXT_USER_OVERRIDE_FLAG VARCHAR2(1)
BASE CONCATENATED_SEGMENT_DELIMITER VARCHAR2(1)
BASE FREEZE_FLEX_DEFINITION_FLAG VARCHAR2(1)
BASE PROTECTED_FLAG VARCHAR2(1)
BASE DEFAULT_CONTEXT_FIELD_NAME VARCHAR2(200)
BASE DEFAULT_CONTEXT_VALUE VARCHAR2(30)
BASE CONTEXT_DEFAULT_TYPE VARCHAR2(1)
BASE CONTEXT_DEFAULT_VALUE VARCHAR2(2000)
BASE CONTEXT_OVERRIDE_VALUE_SET_NAM REFERENCES VALUE_SET
BASE CONTEXT_RUNTIME_PROPERTY_FUNCT VARCHAR2(2000)
TRANS TITLE VARCHAR2(60)
TRANS FORM_CONTEXT_PROMPT VARCHAR2(45)
TRANS DESCRIPTION VARCHAR2(240)
DEFINE DFF_CONTEXT
KEY DESCRIPTIVE_FLEX_CONTEXT_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE ENABLED_FLAG VARCHAR2(1)
BASE GLOBAL_FLAG VARCHAR2(1)
TRANS DESCRIPTIVE_FLEX_CONTEXT_NAME VARCHAR2(80)
TRANS DESCRIPTION VARCHAR2(240)
DEFINE DFF_SEGMENT
KEY END_USER_COLUMN_NAME VARCHAR2(30)
KEY APPLICATION_COLUMN_NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE COLUMN_SEQ_NUM VARCHAR2(50)
BASE ENABLED_FLAG VARCHAR2(1)
BASE DISPLAY_FLAG VARCHAR2(1)
BASE REQUIRED_FLAG VARCHAR2(1)
BASE SECURITY_ENABLED_FLAG VARCHAR2(1)
BASE FLEX_VALUE_SET_NAME REFERENCES VALUE_SET
BASE DISPLAY_SIZE VARCHAR2(50)
BASE MAXIMUM_DESCRIPTION_LEN VARCHAR2(50)
BASE CONCATENATION_DESCRIPTION_LEN VARCHAR2(50)
BASE RANGE_CODE VARCHAR2(1)
BASE DEFAULT_TYPE VARCHAR2(1)
BASE DEFAULT_VALUE VARCHAR2(2000)
BASE RUNTIME_PROPERTY_FUNCTION VARCHAR2(2000)
BASE SRW_PARAM VARCHAR2(30)
TRANS FORM_LEFT_PROMPT VARCHAR2(80)
TRANS FORM_ABOVE_PROMPT VARCHAR2(80)
TRANS DESCRIPTION VARCHAR2(240)
END DFF_SEGMENT
END DFF_CONTEXT
DEFINE DFF_REF_FIELD
KEY DEFAULT_CONTEXT_FIELD_NAME VARCHAR2(200)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
TRANS DESCRIPTION VARCHAR2(240)
END DFF_REF_FIELD
DEFINE DFF_COLUMN
KEY COLUMN_NAME VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE FLEXFIELD_USAGE_CODE VARCHAR2(1)
END DFF_COLUMN
END DESC_FLEX
DEFINE VALUE_SET
KEY FLEX_VALUE_SET_NAME VARCHAR2(60)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE VALIDATION_TYPE VARCHAR2(1)
BASE PROTECTED_FLAG VARCHAR2(1)
BASE SECURITY_ENABLED_FLAG VARCHAR2(1)
BASE LONGLIST_FLAG VARCHAR2(1)
BASE FORMAT_TYPE VARCHAR2(1)
BASE MAXIMUM_SIZE VARCHAR2(50)
BASE NUMBER_PRECISION VARCHAR2(50)
BASE ALPHANUMERIC_ALLOWED_FLAG VARCHAR2(1)
BASE UPPERCASE_ONLY_FLAG VARCHAR2(1)
BASE NUMERIC_MODE_ENABLED_FLAG VARCHAR2(1)
BASE MINIMUM_VALUE VARCHAR2(150)
BASE MAXIMUM_VALUE VARCHAR2(150)
BASE PARENT_FLEX_VALUE_SET_NAME VARCHAR2(60)
BASE DEPENDANT_DEFAULT_VALUE VARCHAR2(60)
BASE DEPENDANT_DEFAULT_MEANING VARCHAR2(240)
TRANS DESCRIPTION VARCHAR2(240)
DEFINE VSET_VALUE
KEY PARENT_FLEX_VALUE_LOW VARCHAR2(60)
KEY FLEX_VALUE VARCHAR2(150)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE ENABLED_FLAG VARCHAR2(1)
BASE SUMMARY_FLAG VARCHAR2(1)
BASE START_DATE_ACTIVE VARCHAR2(50)
BASE END_DATE_ACTIVE VARCHAR2(50)
BASE PARENT_FLEX_VALUE_HIGH VARCHAR2(60)
BASE ROLLUP_HIERARCHY_CODE VARCHAR2(30)
BASE HIERARCHY_LEVEL VARCHAR2(50)
BASE COMPILED_VALUE_ATTRIBUTES VARCHAR2(2000)
BASE VALUE_CATEGORY VARCHAR2(30)
BASE ATTRIBUTE1 VARCHAR2(240)
BASE ATTRIBUTE2 VARCHAR2(240)
BASE ATTRIBUTE3 VARCHAR2(240)
BASE ATTRIBUTE4 VARCHAR2(240)
BASE ATTRIBUTE5 VARCHAR2(240)
BASE ATTRIBUTE6 VARCHAR2(240)
BASE ATTRIBUTE7 VARCHAR2(240)
BASE ATTRIBUTE8 VARCHAR2(240)
BASE ATTRIBUTE9 VARCHAR2(240)
BASE ATTRIBUTE10 VARCHAR2(240)
BASE ATTRIBUTE11 VARCHAR2(240)
BASE ATTRIBUTE12 VARCHAR2(240)
BASE ATTRIBUTE13 VARCHAR2(240)
BASE ATTRIBUTE14 VARCHAR2(240)
BASE ATTRIBUTE15 VARCHAR2(240)
BASE ATTRIBUTE16 VARCHAR2(240)
BASE ATTRIBUTE17 VARCHAR2(240)
BASE ATTRIBUTE18 VARCHAR2(240)
BASE ATTRIBUTE19 VARCHAR2(240)
BASE ATTRIBUTE20 VARCHAR2(240)
BASE ATTRIBUTE21 VARCHAR2(240)
BASE ATTRIBUTE22 VARCHAR2(240)
BASE ATTRIBUTE23 VARCHAR2(240)
BASE ATTRIBUTE24 VARCHAR2(240)
BASE ATTRIBUTE25 VARCHAR2(240)
BASE ATTRIBUTE26 VARCHAR2(240)
BASE ATTRIBUTE27 VARCHAR2(240)
BASE ATTRIBUTE28 VARCHAR2(240)
BASE ATTRIBUTE29 VARCHAR2(240)
BASE ATTRIBUTE30 VARCHAR2(240)
BASE ATTRIBUTE31 VARCHAR2(240)
BASE ATTRIBUTE32 VARCHAR2(240)
BASE ATTRIBUTE33 VARCHAR2(240)
BASE ATTRIBUTE34 VARCHAR2(240)
BASE ATTRIBUTE35 VARCHAR2(240)
BASE ATTRIBUTE36 VARCHAR2(240)
BASE ATTRIBUTE37 VARCHAR2(240)
BASE ATTRIBUTE38 VARCHAR2(240)
BASE ATTRIBUTE39 VARCHAR2(240)
BASE ATTRIBUTE40 VARCHAR2(240)
BASE ATTRIBUTE41 VARCHAR2(240)
BASE ATTRIBUTE42 VARCHAR2(240)
BASE ATTRIBUTE43 VARCHAR2(240)
BASE ATTRIBUTE44 VARCHAR2(240)
BASE ATTRIBUTE45 VARCHAR2(240)
BASE ATTRIBUTE46 VARCHAR2(240)
BASE ATTRIBUTE47 VARCHAR2(240)
BASE ATTRIBUTE48 VARCHAR2(240)
BASE ATTRIBUTE49 VARCHAR2(240)
BASE ATTRIBUTE50 VARCHAR2(240)
TRANS FLEX_VALUE_MEANING VARCHAR2(150)
TRANS DESCRIPTION VARCHAR2(240)
DEFINE VSET_VALUE_QUAL_VALUE
KEY ID_FLEX_APPLICATION_SHORT_NAME VARCHAR2(50)
KEY ID_FLEX_CODE VARCHAR2(4)
KEY SEGMENT_ATTRIBUTE_TYPE VARCHAR2(30)
KEY VALUE_ATTRIBUTE_TYPE VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE COMPILED_VALUE_ATTRIBUTE_VALUE VARCHAR2(2000)
END VSET_VALUE_QUAL_VALUE
DEFINE VSET_VALUE_HIERARCHY
KEY RANGE_ATTRIBUTE VARCHAR2(1)
KEY CHILD_FLEX_VALUE_LOW VARCHAR2(60)
KEY CHILD_FLEX_VALUE_HIGH VARCHAR2(60)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE START_DATE_ACTIVE VARCHAR2(50)
BASE END_DATE_ACTIVE VARCHAR2(50)
END VSET_VALUE_HIERARCHY
END VSET_VALUE
DEFINE VSET_QUALIFIER
KEY ID_FLEX_APPLICATION_SHORT_NAME VARCHAR2(50)
KEY ID_FLEX_CODE VARCHAR2(4)
KEY SEGMENT_ATTRIBUTE_TYPE VARCHAR2(30)
KEY VALUE_ATTRIBUTE_TYPE VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE ASSIGNMENT_ORDER VARCHAR2(50)
BASE ASSIGNMENT_DATE VARCHAR2(50)
END VSET_QUALIFIER
DEFINE VSET_ROLLUP_GROUP
KEY HIERARCHY_CODE VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
TRANS HIERARCHY_NAME VARCHAR2(30)
TRANS DESCRIPTION VARCHAR2(240)
END VSET_ROLLUP_GROUP
DEFINE VSET_SECURITY_RULE
KEY FLEX_VALUE_RULE_NAME VARCHAR2(30)
KEY PARENT_FLEX_VALUE_LOW VARCHAR2(60)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE PARENT_FLEX_VALUE_HIGH VARCHAR2(60)
TRANS ERROR_MESSAGE VARCHAR2(240)
TRANS DESCRIPTION VARCHAR2(240)
DEFINE VSET_SECURITY_USAGE
KEY APPLICATION_SHORT_NAME VARCHAR2(50)
KEY RESPONSIBILITY_KEY VARCHAR2(30)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE PARENT_FLEX_VALUE_HIGH VARCHAR2(60)
END VSET_SECURITY_USAGE
DEFINE VSET_SECURITY_LINE
KEY INCLUDE_EXCLUDE_INDICATOR VARCHAR2(1)
KEY FLEX_VALUE_LOW VARCHAR2(60)
KEY FLEX_VALUE_HIGH VARCHAR2(60)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE PARENT_FLEX_VALUE_HIGH VARCHAR2(60)
END VSET_SECURITY_LINE
END VSET_SECURITY_RULE
DEFINE VSET_EVENT
KEY EVENT_CODE VARCHAR2(1)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE USER_EXIT VARCHAR2(32000)
END VSET_EVENT
DEFINE VSET_TABLE
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE TABLE_APPLICATION_SHORT_NAME VARCHAR2(50)
BASE APPLICATION_TABLE_NAME VARCHAR2(240)
BASE SUMMARY_ALLOWED_FLAG VARCHAR2(1)
BASE VALUE_COLUMN_NAME VARCHAR2(240)
BASE VALUE_COLUMN_TYPE VARCHAR2(1)
BASE VALUE_COLUMN_SIZE VARCHAR2(50)
BASE ID_COLUMN_NAME VARCHAR2(240)
BASE ID_COLUMN_TYPE VARCHAR2(1)
BASE ID_COLUMN_SIZE VARCHAR2(50)
BASE MEANING_COLUMN_NAME VARCHAR2(240)
BASE MEANING_COLUMN_TYPE VARCHAR2(1)
BASE MEANING_COLUMN_SIZE VARCHAR2(50)
BASE ENABLED_COLUMN_NAME VARCHAR2(240)
BASE COMPILED_ATTRIBUTE_COLUMN_NAME VARCHAR2(240)
BASE HIERARCHY_LEVEL_COLUMN_NAME VARCHAR2(240)
BASE START_DATE_COLUMN_NAME VARCHAR2(240)
BASE END_DATE_COLUMN_NAME VARCHAR2(240)
BASE SUMMARY_COLUMN_NAME VARCHAR2(240)
BASE ADDITIONAL_WHERE_CLAUSE VARCHAR2(32000)
BASE ADDITIONAL_QUICKPICK_COLUMNS VARCHAR2(240)
END VSET_TABLE
DEFINE VSET_DEPENDS_ON
KEY IND_FLEX_VALUE_SET_NAME VARCHAR2(60)
CTX OWNER VARCHAR2(4000)
CTX LAST_UPDATE_DATE VARCHAR2(50)
BASE IND_VALIDATION_TYPE VARCHAR2(1)
BASE DEP_VALIDATION_TYPE VARCHAR2(1)
END VSET_DEPENDS_ON
END VALUE_SET
# -- End Entity Definitions --
BEGIN EXECUTABLE "xxpsc_ls_ye_disability_rollove" "XXPSC"
OWNER = "ANONYMOUS"
LAST_UPDATE_DATE = "2006/11/24"
EXECUTION_METHOD_CODE = "I"
EXECUTION_FILE_NAME = "xxpsc_ls_ye_dis_rollover_pkg.main"
USER_EXECUTABLE_NAME = "xxpsc_ls_ye_dis_rollover"
END EXECUTABLE
BEGIN VALUE_SET "GOS_LS_DIS_B1_PAY_PERIOD_ID"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 15:45:59"
VALIDATION_TYPE = "F"
PROTECTED_FLAG = "N"
SECURITY_ENABLED_FLAG = "N"
LONGLIST_FLAG = "N"
FORMAT_TYPE = "C"
MAXIMUM_SIZE = "30"
ALPHANUMERIC_ALLOWED_FLAG = "Y"
UPPERCASE_ONLY_FLAG = "N"
NUMERIC_MODE_ENABLED_FLAG = "N"
DESCRIPTION =
"List of Pay Periods for GOS BEN LS Disability Carryover (B1 Only)"
BEGIN VSET_TABLE
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 15:49:05"
TABLE_APPLICATION_SHORT_NAME = "PER"
APPLICATION_TABLE_NAME = "PER_TIME_PERIODS"
SUMMARY_ALLOWED_FLAG = "N"
VALUE_COLUMN_NAME = "PERIOD_NAME"
VALUE_COLUMN_TYPE = "C"
VALUE_COLUMN_SIZE = "30"
ID_COLUMN_NAME = "TIME_PERIOD_ID"
ID_COLUMN_TYPE = "C"
ID_COLUMN_SIZE = "15"
ENABLED_COLUMN_NAME = "'Y'"
COMPILED_ATTRIBUTE_COLUMN_NAME = "NULL"
HIERARCHY_LEVEL_COLUMN_NAME = "NULL"
START_DATE_COLUMN_NAME = "to_date(null)"
END_DATE_COLUMN_NAME = "to_date(null)"
SUMMARY_COLUMN_NAME = "'N'"
ADDITIONAL_WHERE_CLAUSE =
"WHERE payroll_id IN \n\
(SELECT payroll_id\n\
FROM pay_all_payrolls_f\n\
WHERE SUBSTR(payroll_name,-2,2) = 'B1'\n\
AND SYSDATE BETWEEN effective_start_date AND effective_end_date)\n\
ORDER BY period_name DESC"
ADDITIONAL_QUICKPICK_COLUMNS =
"PER_TIME_PERIODS.START_DATE \"Start Date\"(*),\n\
PER_TIME_PERIODS.END_DATE \"End Date\"(*)"
END VSET_TABLE
END VALUE_SET
BEGIN VALUE_SET "GOS_LS_DIS_B2_PAY_PERIOD_ID"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 15:50:48"
VALIDATION_TYPE = "F"
PROTECTED_FLAG = "N"
SECURITY_ENABLED_FLAG = "N"
LONGLIST_FLAG = "N"
FORMAT_TYPE = "C"
MAXIMUM_SIZE = "30"
ALPHANUMERIC_ALLOWED_FLAG = "Y"
UPPERCASE_ONLY_FLAG = "N"
NUMERIC_MODE_ENABLED_FLAG = "N"
DESCRIPTION =
"List of Pay Periods for GOS BEN LS Disability Carryover (B2 Only)"
BEGIN VSET_TABLE
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 15:51:09"
TABLE_APPLICATION_SHORT_NAME = "PER"
APPLICATION_TABLE_NAME = "PER_TIME_PERIODS"
SUMMARY_ALLOWED_FLAG = "N"
VALUE_COLUMN_NAME = "PERIOD_NAME"
VALUE_COLUMN_TYPE = "C"
VALUE_COLUMN_SIZE = "30"
ID_COLUMN_NAME = "TIME_PERIOD_ID"
ID_COLUMN_TYPE = "C"
ID_COLUMN_SIZE = "15"
ENABLED_COLUMN_NAME = "'Y'"
COMPILED_ATTRIBUTE_COLUMN_NAME = "NULL"
HIERARCHY_LEVEL_COLUMN_NAME = "NULL"
START_DATE_COLUMN_NAME = "to_date(null)"
END_DATE_COLUMN_NAME = "to_date(null)"
SUMMARY_COLUMN_NAME = "'N'"
ADDITIONAL_WHERE_CLAUSE =
"WHERE payroll_id IN \n\
(SELECT payroll_id\n\
FROM pay_all_payrolls_f\n\
WHERE SUBSTR(payroll_name,-2,2) = 'B2'\n\
AND SYSDATE BETWEEN effective_start_date AND effective_end_date)\n\
ORDER BY period_name DESC"
ADDITIONAL_QUICKPICK_COLUMNS =
"PER_TIME_PERIODS.START_DATE \"Start Date\"(*),\n\
PER_TIME_PERIODS.END_DATE \"End Date\"(*)"
END VSET_TABLE
END VALUE_SET
BEGIN VALUE_SET "GOS_LS_DIS_M1_PAY_PERIOD_ID"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 15:52:13"
VALIDATION_TYPE = "F"
PROTECTED_FLAG = "N"
SECURITY_ENABLED_FLAG = "N"
LONGLIST_FLAG = "N"
FORMAT_TYPE = "C"
MAXIMUM_SIZE = "30"
ALPHANUMERIC_ALLOWED_FLAG = "Y"
UPPERCASE_ONLY_FLAG = "N"
NUMERIC_MODE_ENABLED_FLAG = "N"
DESCRIPTION =
"List of Pay Periods for GOS BEN LS Disability Carryover (M1 Only)"
BEGIN VSET_TABLE
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 15:52:31"
TABLE_APPLICATION_SHORT_NAME = "PER"
APPLICATION_TABLE_NAME = "PER_TIME_PERIODS"
SUMMARY_ALLOWED_FLAG = "N"
VALUE_COLUMN_NAME = "PERIOD_NAME"
VALUE_COLUMN_TYPE = "C"
VALUE_COLUMN_SIZE = "30"
ID_COLUMN_NAME = "TIME_PERIOD_ID"
ID_COLUMN_TYPE = "C"
ID_COLUMN_SIZE = "15"
ENABLED_COLUMN_NAME = "'Y'"
COMPILED_ATTRIBUTE_COLUMN_NAME = "NULL"
HIERARCHY_LEVEL_COLUMN_NAME = "NULL"
START_DATE_COLUMN_NAME = "to_date(null)"
END_DATE_COLUMN_NAME = "to_date(null)"
SUMMARY_COLUMN_NAME = "'N'"
ADDITIONAL_WHERE_CLAUSE =
"WHERE payroll_id IN \n\
(SELECT payroll_id\n\
FROM pay_all_payrolls_f\n\
WHERE SUBSTR(payroll_name,-2,2) = 'M1'\n\
AND SYSDATE BETWEEN effective_start_date AND effective_end_date)\n\
ORDER BY period_name DESC"
ADDITIONAL_QUICKPICK_COLUMNS =
"PER_TIME_PERIODS.START_DATE \"Start Date\"(*),\n\
PER_TIME_PERIODS.END_DATE \"End Date\"(*)"
END VSET_TABLE
END VALUE_SET
BEGIN DESC_FLEX "XXPSC" "$SRS$.XXPSC_LS_YE_DIS_ROLLOVER"
OWNER = "ANONYMOUS"
LAST_UPDATE_DATE = "2006/11/24 00:00:00"
TABLE_APPLICATION_SHORT_NAME = "FND"
APPLICATION_TABLE_NAME = "FND_SRS_MASTER"
CONTEXT_COLUMN_NAME = "STRUCTURE_COLUMN"
CONTEXT_REQUIRED_FLAG = "N"
CONTEXT_USER_OVERRIDE_FLAG = "N"
CONCATENATED_SEGMENT_DELIMITER = ":"
FREEZE_FLEX_DEFINITION_FLAG = "Y"
PROTECTED_FLAG = "S"
CONTEXT_OVERRIDE_VALUE_SET_NAM = ""
TITLE = "$SRS$.XXPSC_LS_YE_DIS_ROLLOVER"
FORM_CONTEXT_PROMPT = "Context Value"
BEGIN DFF_CONTEXT "Global Data Elements"
OWNER = "ANONYMOUS"
LAST_UPDATE_DATE = "2006/11/24 00:00:00"
ENABLED_FLAG = "Y"
GLOBAL_FLAG = "Y"
DESCRIPTIVE_FLEX_CONTEXT_NAME = "Global Data Elements"
BEGIN DFF_SEGMENT "Effective Date" "ATTRIBUTE1"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:09:39"
COLUMN_SEQ_NUM = "10"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "FND_STANDARD_DATE"
DISPLAY_SIZE = "11"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "Effective Date"
FORM_ABOVE_PROMPT = "Effective Date"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "p_b1_time_period_id_from" "ATTRIBUTE6"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:00:53"
COLUMN_SEQ_NUM = "11"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "GOS_LS_DIS_B1_PAY_PERIOD_ID"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "B1 Period From"
FORM_ABOVE_PROMPT = "B1 Period From"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "p_b1_time_period_id_to" "ATTRIBUTE7"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:05:20"
COLUMN_SEQ_NUM = "12"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "GOS_LS_DIS_B1_PAY_PERIOD_ID"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "To"
FORM_ABOVE_PROMPT = "To"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "p_b2_time_period_id_from" "ATTRIBUTE8"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:05:20"
COLUMN_SEQ_NUM = "13"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "GOS_LS_DIS_B2_PAY_PERIOD_ID"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "B2 Period From"
FORM_ABOVE_PROMPT = "B2 Period From"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "p_b2_time_period_id_to" "ATTRIBUTE9"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:05:20"
COLUMN_SEQ_NUM = "14"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "GOS_LS_DIS_B2_PAY_PERIOD_ID"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "To"
FORM_ABOVE_PROMPT = "To"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "p_m1_time_period_id_from" "ATTRIBUTE10"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:05:20"
COLUMN_SEQ_NUM = "15"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "GOS_LS_DIS_M1_PAY_PERIOD_ID"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "M1 Period From"
FORM_ABOVE_PROMPT = "M1 Period From"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "p_m1_time_period_id_to" "ATTRIBUTE11"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:05:20"
COLUMN_SEQ_NUM = "16"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "GOS_LS_DIS_M1_PAY_PERIOD_ID"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "To"
FORM_ABOVE_PROMPT = "To"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "Premium Percent" "ATTRIBUTE2"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 15:53:35"
COLUMN_SEQ_NUM = "20"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "FND_NUMBER15_REQUIRED"
DISPLAY_SIZE = "15"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "Premium Percent"
FORM_ABOVE_PROMPT = "Premium Percent"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "Validate Only" "ATTRIBUTE3"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:09:39"
COLUMN_SEQ_NUM = "30"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "Yes_No"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
DEFAULT_TYPE = "C"
DEFAULT_VALUE = "No"
FORM_LEFT_PROMPT = "Validate Only"
FORM_ABOVE_PROMPT = "Validate Only"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "org_email" "ATTRIBUTE4"
OWNER = "BTROWSDALE"
LAST_UPDATE_DATE = "2007/11/21 16:09:39"
COLUMN_SEQ_NUM = "40"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "N"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "FND_CHAR240"
DISPLAY_SIZE = "30"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
FORM_LEFT_PROMPT = "Override email"
FORM_ABOVE_PROMPT = "Override email"
END DFF_SEGMENT
BEGIN DFF_SEGMENT "p_occurred_date" "ATTRIBUTE5"
OWNER = "ANONYMOUS"
LAST_UPDATE_DATE = "2006/04/10 00:00:00"
COLUMN_SEQ_NUM = "50"
ENABLED_FLAG = "Y"
DISPLAY_FLAG = "Y"
REQUIRED_FLAG = "Y"
SECURITY_ENABLED_FLAG = "N"
FLEX_VALUE_SET_NAME = "FND_STANDARD_DATE"
DISPLAY_SIZE = "11"
MAXIMUM_DESCRIPTION_LEN = "50"
CONCATENATION_DESCRIPTION_LEN = "25"
DEFAULT_TYPE = "D"
SRW_PARAM = "p_occurred_date"
FORM_LEFT_PROMPT = "Occurred Date"
FORM_ABOVE_PROMPT = "Occurred Date"
DESCRIPTION = "Occurred date used on life event"
END DFF_SEGMENT
END DFF_CONTEXT
END DESC_FLEX
BEGIN PROGRAM "XXPSC_LS_YE_DIS_ROLLOVER" "XXPSC"
OWNER = "ANONYMOUS"
LAST_UPDATE_DATE = "2006/11/24"
USER_CONCURRENT_PROGRAM_NAME = "GOS - Ben Year End Disability Rollover"
EXEC = "xxpsc_ls_ye_disability_rollove" "XXPSC"
EXECUTION_METHOD_CODE = "I"
ARGUMENT_METHOD_CODE = "4"
QUEUE_CONTROL_FLAG = "N"
QUEUE_METHOD_CODE = "I"
REQUEST_SET_FLAG = "N"
ENABLED_FLAG = "Y"
PRINT_FLAG = "Y"
RUN_ALONE_FLAG = "N"
SRS_FLAG = "Y"
SAVE_OUTPUT_FLAG = "Y"
REQUIRED_STYLE = "N"
OUTPUT_FILE_TYPE = "TEXT"
RESTART = "Y"
NLS_COMPLIANT = "Y"
MLS_EXEC = "" ""
ENABLE_TIME_STATISTICS = "N"
SRS_FLEX = "XXPSC" "$SRS$.XXPSC_LS_YE_DIS_ROLLOVER"
AUTO_ANNOTATION =
"/**\n\
* @param Effective%_Date Effective Date\n\
* @rep:paraminfo {@rep:type FND_STANDARD_DATE} {@rep:displayed Y} {@rep:required}\n\
* @param p_b1_time_period_id_from B1 Period From\n\
* @rep:paraminfo {@rep:type GOS_LS_DIS_B1_PAY_PERIOD_ID} {@rep:displayed Y} {@rep:required}\n\
* @param p_b1_time_period_id_to To\n\
* @rep:paraminfo {@rep:type GOS_LS_DIS_B1_PAY_PERIOD_ID} {@rep:displayed Y} {@rep:required}\n\
* @param p_b2_time_period_id_from B2 Period From\n\
* @rep:paraminfo {@rep:type GOS_LS_DIS_B2_PAY_PERIOD_ID} {@rep:displayed Y} {@rep:required}\n\
* @param p_b2_time_period_id_to To\n\
* @rep:paraminfo {@rep:type GOS_LS_DIS_B2_PAY_PERIOD_ID} {@rep:displayed Y} {@rep:required}\n\
* @param p_m1_time_period_id_from M1 Period From\n\
* @rep:paraminfo {@rep:type GOS_LS_DIS_M1_PAY_PERIOD_ID} {@rep:displayed Y} {@rep:required}\n\
* @param p_m1_time_period_id_to To\n\
* @rep:paraminfo {@rep:type GOS_LS_DIS_M1_PAY_PERIOD_ID} {@rep:displayed Y} {@rep:required}\n\
* @param Premium%_Percent Premium Percent\n\
* @rep:paraminfo {@rep:type FND_NUMBER15_REQUIRED} {@rep:displayed Y} {@rep:required}\n\
* @param Validate%_Only Validate Only\n\
* @rep:paraminfo {@rep:type Yes_No} {@rep:displayed Y} {@rep:required}\n\
* @param org_email Override email\n\
* @rep:paraminfo {@rep:type FND_CHAR240} {@rep:displayed Y}\n\
* @param p_occurred_date Occurred date used on life event\n\
* @rep:paraminfo {@rep:type FND_STANDARD_DATE} {@rep:displayed Y} {@rep:required}\n\
*/"
END PROGRAM
|
|
|
|
| Re: Problems Uploading with FNDLOAD [message #282846 is a reply to message #282816] |
Sat, 24 November 2007 03:00  |
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
|
Member |
|
|
Hi,
Only issue I've had in the past is if the entities attempting to be uploaded via FNDLOAD have been updated (last_update_date) since the FNDLOAD was extracted, then the changes won't be made.
Check the log file.
Gareth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
