I am trying to modify and load default data. Part of the modification is to change time periods so that accounting year ends in March.
This results in a strange error. Error is strange because "customTimePeriodId" is a Primary Key and cannot be null. [image: image.png] [image: image.png] *Sample Data : * <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6010" periodTypeId="FISCAL_YEAR" fromDate="1995-04-01 00:00:00" thruDate="1996-03-31 23:59:59" isClosed="N" periodNum="1" periodName="1995" parentPeriodId=""/> <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6011" periodTypeId="FISCAL_QUARTER" fromDate="1995-04-01 00:00:00" thruDate="1995-06-30 23:59:59" isClosed="N" periodNum="2" periodName="1995/Q1" parentPeriodId="6010"/> <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6012" periodTypeId="FISCAL_QUARTER" fromDate="1995-07-01 00:00:00" thruDate="1995-09-30 23:59:59" isClosed="N" periodNum="3" periodName="1995/Q2" parentPeriodId="6010"/> <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6013" periodTypeId="FISCAL_QUARTER" fromDate="1995-10-01 00:00:00" thruDate="1995-12-31 23:59:59" isClosed="N" periodNum="4" periodName="1995/Q3" parentPeriodId="6010"/> <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6014" periodTypeId="FISCAL_QUARTER" fromDate="1996-01-01 00:00:00" thruDate="1996-03-31 23:59:59" isClosed="N" periodNum="5" periodName="1995/Q4" parentPeriodId="6010"/> <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6015" periodTypeId="FISCAL_YEAR" fromDate="1996-04-01 00:00:00" thruDate="1997-03-31 23:59:59" isClosed="N" periodNum="1" periodName="1996" parentPeriodId=""/> <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6016" periodTypeId="FISCAL_QUARTER" fromDate="1996-04-01 00:00:00" thruDate="1996-06-30 23:59:59" isClosed="N" periodNum="2" periodName="1996/Q1" parentPeriodId="6015"/> Start_Date End_Date FY Type ID Parent_ID Is_Current Period_Num 4/1/1995 3/31/1996 1995 FISCAL_YEAR 6010 N 1 4/1/1995 6/30/1995 1995/Q1 FISCAL_QUARTER 6011 6010 N 2 7/1/1995 9/30/1995 1995/Q2 FISCAL_QUARTER 6012 6010 N 3 10/1/1995 12/31/1995 1995/Q3 FISCAL_QUARTER 6013 6010 N 4 1/1/1996 3/31/1996 1995/Q4 FISCAL_QUARTER 6014 6010 N 5 4/1/1996 3/31/1997 1996 FISCAL_YEAR 6015 N 1 4/1/1996 6/30/1996 1996/Q1 FISCAL_QUARTER 6016 6015 N 2 7/1/1996 9/30/1996 1996/Q2 FISCAL_QUARTER 6017 6015 N 3 10/1/1996 12/31/1996 1996/Q3 FISCAL_QUARTER 6018 6015 N 4 1/1/1997 3/31/1997 1996/Q4 FISCAL_QUARTER 6019 6015 N 5 4/1/1997 3/31/1998 1997 FISCAL_YEAR 6020 N 1 4/1/1997 6/30/1997 1997/Q1 FISCAL_QUARTER 6021 6020 N 2 7/1/1997 9/30/1997 1997/Q2 FISCAL_QUARTER 6022 6020 N 3 10/1/1997 12/31/1997 1997/Q3 FISCAL_QUARTER 6023 6020 N 4 1/1/1998 3/31/1998 1997/Q4 FISCAL_QUARTER 6024 6020 N 5
