How to troubleshoot missing customTimePeriodId

[Shamit Verma]

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.

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