إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

Massallocation


لا توجد ردود على هذا الموضوع

#1 karimla131

karimla131

    عضو

  • الأعضــاء
  • 17 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 29 December 2011 - 07:35 PM

السلام عليكم ..

أنا عندي مشكلة في ال massallocation لما بعمل لها generat بتديني ال error ده ::

MassAllocation Batch Name: MASSALL_44									 From Period: JAN-12			 To Period: JAN-12
 
	Period: JAN-12
 
Failure detected. Please see log file.
 
 
 
 
													***** End of Report *****

وهذا هو ملف ال log

+---------------------------------------------------------------------------+
General Ledger: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLAMAS module: Run MassAllocations
+---------------------------------------------------------------------------+
Current system time is 29-DEC-2011 18:26:41
+---------------------------------------------------------------------------+
 
>> glamai() 29-DEC-2011 18:26:41
**************************************************
		29-DEC-2011 18:26:41
AMAS0010: General Ledger MassAllocations Log File
**************************************************
command_mode = C
access set id = 1282
incremental mode = N
average journal flag = N
ledger id override value = 1078
ledger override currency = EGP
balance segment override value = 01
allocation batch id = 10080
period = JAN-12
journal effective date = 2012/01/01 00:00:00
calc effective date = 2012/01/01 00:00:00
>> glasob() 29-DEC-2011 18:26:42
>> gluini() 29-DEC-2011 18:26:42
>> glugsn() 29-DEC-2011 18:26:42
<< glugsn() 29-DEC-2011 18:26:42
<< gluini() 29-DEC-2011 18:26:42
	accounted period type = 205
	chart_of_accounts_id = 53582
	number of flexfield segments = 4
	balancing segment name = SEGMENT1
	management segment name = NA
	security segment name = NA
	flexfield delimiter = '.'
	active segments =
	   SEGMENT1
	   SEGMENT2
	   SEGMENT3
	   SEGMENT4
	flex value sets =
	   1025287
	   1025288
	   1025289
	   1025290
	account segment = SEGMENT3
	account segment length= 7
	flexfield length = 18
<< glasob() 29-DEC-2011 18:26:42
>> glasys() 29-DEC-2011 18:26:42
  ***********************************************
  * Warning: profile option has not been set up:*
  * GL: Number of Records to Process at Once	*
  ***********************************************
  ***********************************************
  * Warning: profile option has not been set up:*
  * GL: Number of Accounts In Memory			*
  ***********************************************
	foundation user id = 1013435
	foundation user name = K.KHALIL
	concurrent request id = 5811787
	number of target records to process at a time = 1000
	number of flexfields to cache = 2500
	cache control segment = SEGMENT3
	length of control segment = 7
	length of flexfield = 18
<< glasys() 29-DEC-2011 18:26:42
>> glavcmd() 29-DEC-2011 18:26:42
SHRD0117: Inserted 1 record(s) into gl_alloc_history
 
<< glavcmd() 29-DEC-2011 18:26:42
>> glacab() 29-DEC-2011 18:26:42
glacab() - tf = 1, sqlerrd[2] = 1
glacab--loopcnt = 1 and size 2b Malloced is 984
<< glacab() 29-DEC-2011 18:26:42
>> glapst() 29-DEC-2011 18:26:42
glapst() - pst0_stmt.arr =
SELECT   period_name,
to_char(start_date, 'YYYY/MM/DD'),
to_char(end_date, 'YYYY/MM/DD'),
to_number(to_char(start_date,'J')),
to_number(to_char(end_date,'J')),
period_type,
period_year,
period_num,
adjustment_period_flag
FROM	 gl_periods
WHERE  period_set_name ='Cal_44'
AND	  period_type ='205'
ORDER BY period_year, period_num
AMAS0025: glapst() - Found 26 periods (COA=53582)
control->coa_rec.pstat[0].period_name = JAN-11
control->coa_rec.pstat[0].start_date = 2011/01/01
control->coa_rec.pstat[0].end_date = 2011/01/31
control->coa_rec.pstat[0].jstart_date = 2455563
control->coa_rec.pstat[0].jend_date = 2455593
control->coa_rec.pstat[0].period_type = 205
control->coa_rec.pstat[0].period_year = 2011
control->coa_rec.pstat[0].period_num = 1
control->coa_rec.pstat[1].period_name = FEB-11
control->coa_rec.pstat[1].start_date = 2011/02/01
control->coa_rec.pstat[1].end_date = 2011/02/28
control->coa_rec.pstat[1].jstart_date = 2455594
control->coa_rec.pstat[1].jend_date = 2455621
control->coa_rec.pstat[1].period_type = 205
control->coa_rec.pstat[1].period_year = 2011
control->coa_rec.pstat[1].period_num = 2
control->coa_rec.pstat[2].period_name = MAR-11
control->coa_rec.pstat[2].start_date = 2011/03/01
control->coa_rec.pstat[2].end_date = 2011/03/31
control->coa_rec.pstat[2].jstart_date = 2455622
control->coa_rec.pstat[2].jend_date = 2455652
control->coa_rec.pstat[2].period_type = 205
control->coa_rec.pstat[2].period_year = 2011
control->coa_rec.pstat[2].period_num = 3
control->coa_rec.pstat[3].period_name = APR-11
control->coa_rec.pstat[3].start_date = 2011/04/01
control->coa_rec.pstat[3].end_date = 2011/04/30
control->coa_rec.pstat[3].jstart_date = 2455653
control->coa_rec.pstat[3].jend_date = 2455682
control->coa_rec.pstat[3].period_type = 205
control->coa_rec.pstat[3].period_year = 2011
control->coa_rec.pstat[3].period_num = 4
control->coa_rec.pstat[4].period_name = MAY-11
control->coa_rec.pstat[4].start_date = 2011/05/01
control->coa_rec.pstat[4].end_date = 2011/05/31
control->coa_rec.pstat[4].jstart_date = 2455683
control->coa_rec.pstat[4].jend_date = 2455713
control->coa_rec.pstat[4].period_type = 205
control->coa_rec.pstat[4].period_year = 2011
control->coa_rec.pstat[4].period_num = 5
control->coa_rec.pstat[5].period_name = JUN-11
control->coa_rec.pstat[5].start_date = 2011/06/01
control->coa_rec.pstat[5].end_date = 2011/06/30
control->coa_rec.pstat[5].jstart_date = 2455714
control->coa_rec.pstat[5].jend_date = 2455743
control->coa_rec.pstat[5].period_type = 205
control->coa_rec.pstat[5].period_year = 2011
control->coa_rec.pstat[5].period_num = 6
control->coa_rec.pstat[6].period_name = JUL-11
control->coa_rec.pstat[6].start_date = 2011/07/01
control->coa_rec.pstat[6].end_date = 2011/07/31
control->coa_rec.pstat[6].jstart_date = 2455744
control->coa_rec.pstat[6].jend_date = 2455774
control->coa_rec.pstat[6].period_type = 205
control->coa_rec.pstat[6].period_year = 2011
control->coa_rec.pstat[6].period_num = 7
control->coa_rec.pstat[7].period_name = AUG-11
control->coa_rec.pstat[7].start_date = 2011/08/01
control->coa_rec.pstat[7].end_date = 2011/08/31
control->coa_rec.pstat[7].jstart_date = 2455775
control->coa_rec.pstat[7].jend_date = 2455805
control->coa_rec.pstat[7].period_type = 205
control->coa_rec.pstat[7].period_year = 2011
control->coa_rec.pstat[7].period_num = 8
control->coa_rec.pstat[8].period_name = SEP-11
control->coa_rec.pstat[8].start_date = 2011/09/01
control->coa_rec.pstat[8].end_date = 2011/09/30
control->coa_rec.pstat[8].jstart_date = 2455806
control->coa_rec.pstat[8].jend_date = 2455835
control->coa_rec.pstat[8].period_type = 205
control->coa_rec.pstat[8].period_year = 2011
control->coa_rec.pstat[8].period_num = 9
control->coa_rec.pstat[9].period_name = OCT-11
control->coa_rec.pstat[9].start_date = 2011/10/01
control->coa_rec.pstat[9].end_date = 2011/10/31
control->coa_rec.pstat[9].jstart_date = 2455836
control->coa_rec.pstat[9].jend_date = 2455866
control->coa_rec.pstat[9].period_type = 205
control->coa_rec.pstat[9].period_year = 2011
control->coa_rec.pstat[9].period_num = 10
control->coa_rec.pstat[10].period_name = NOV-11
control->coa_rec.pstat[10].start_date = 2011/11/01
control->coa_rec.pstat[10].end_date = 2011/11/30
control->coa_rec.pstat[10].jstart_date = 2455867
control->coa_rec.pstat[10].jend_date = 2455896
control->coa_rec.pstat[10].period_type = 205
control->coa_rec.pstat[10].period_year = 2011
control->coa_rec.pstat[10].period_num = 11
control->coa_rec.pstat[11].period_name = DEC-11
control->coa_rec.pstat[11].start_date = 2011/12/01
control->coa_rec.pstat[11].end_date = 2011/12/31
control->coa_rec.pstat[11].jstart_date = 2455897
control->coa_rec.pstat[11].jend_date = 2455927
control->coa_rec.pstat[11].period_type = 205
control->coa_rec.pstat[11].period_year = 2011
control->coa_rec.pstat[11].period_num = 12
control->coa_rec.pstat[12].period_name = ADJ-11
control->coa_rec.pstat[12].start_date = 2011/12/31
control->coa_rec.pstat[12].end_date = 2011/12/31
control->coa_rec.pstat[12].jstart_date = 2455927
control->coa_rec.pstat[12].jend_date = 2455927
control->coa_rec.pstat[12].period_type = 205
control->coa_rec.pstat[12].period_year = 2011
control->coa_rec.pstat[12].period_num = 13
control->coa_rec.pstat[13].period_name = JAN-12
control->coa_rec.pstat[13].start_date = 2012/01/01
control->coa_rec.pstat[13].end_date = 2012/01/31
control->coa_rec.pstat[13].jstart_date = 2455928
control->coa_rec.pstat[13].jend_date = 2455958
control->coa_rec.pstat[13].period_type = 205
control->coa_rec.pstat[13].period_year = 2012
control->coa_rec.pstat[13].period_num = 1
control->coa_rec.pstat[14].period_name = FEB-12
control->coa_rec.pstat[14].start_date = 2012/02/01
control->coa_rec.pstat[14].end_date = 2012/02/29
control->coa_rec.pstat[14].jstart_date = 2455959
control->coa_rec.pstat[14].jend_date = 2455987
control->coa_rec.pstat[14].period_type = 205
control->coa_rec.pstat[14].period_year = 2012
control->coa_rec.pstat[14].period_num = 2
control->coa_rec.pstat[15].period_name = MAR-12
control->coa_rec.pstat[15].start_date = 2012/03/01
control->coa_rec.pstat[15].end_date = 2012/03/31
control->coa_rec.pstat[15].jstart_date = 2455988
control->coa_rec.pstat[15].jend_date = 2456018
control->coa_rec.pstat[15].period_type = 205
control->coa_rec.pstat[15].period_year = 2012
control->coa_rec.pstat[15].period_num = 3
control->coa_rec.pstat[16].period_name = APR-12
control->coa_rec.pstat[16].start_date = 2012/04/01
control->coa_rec.pstat[16].end_date = 2012/04/30
control->coa_rec.pstat[16].jstart_date = 2456019
control->coa_rec.pstat[16].jend_date = 2456048
control->coa_rec.pstat[16].period_type = 205
control->coa_rec.pstat[16].period_year = 2012
control->coa_rec.pstat[16].period_num = 4
control->coa_rec.pstat[17].period_name = MAY-12
control->coa_rec.pstat[17].start_date = 2012/05/01
control->coa_rec.pstat[17].end_date = 2012/05/31
control->coa_rec.pstat[17].jstart_date = 2456049
control->coa_rec.pstat[17].jend_date = 2456079
control->coa_rec.pstat[17].period_type = 205
control->coa_rec.pstat[17].period_year = 2012
control->coa_rec.pstat[17].period_num = 5
control->coa_rec.pstat[18].period_name = JUN-12
control->coa_rec.pstat[18].start_date = 2012/06/01
control->coa_rec.pstat[18].end_date = 2012/06/30
control->coa_rec.pstat[18].jstart_date = 2456080
control->coa_rec.pstat[18].jend_date = 2456109
control->coa_rec.pstat[18].period_type = 205
control->coa_rec.pstat[18].period_year = 2012
control->coa_rec.pstat[18].period_num = 6
control->coa_rec.pstat[19].period_name = JUL-12
control->coa_rec.pstat[19].start_date = 2012/07/01
control->coa_rec.pstat[19].end_date = 2012/07/31
control->coa_rec.pstat[19].jstart_date = 2456110
control->coa_rec.pstat[19].jend_date = 2456140
control->coa_rec.pstat[19].period_type = 205
control->coa_rec.pstat[19].period_year = 2012
control->coa_rec.pstat[19].period_num = 7
control->coa_rec.pstat[20].period_name = AUG-12
control->coa_rec.pstat[20].start_date = 2012/08/01
control->coa_rec.pstat[20].end_date = 2012/08/31
control->coa_rec.pstat[20].jstart_date = 2456141
control->coa_rec.pstat[20].jend_date = 2456171
control->coa_rec.pstat[20].period_type = 205
control->coa_rec.pstat[20].period_year = 2012
control->coa_rec.pstat[20].period_num = 8
control->coa_rec.pstat[21].period_name = SEP-12
control->coa_rec.pstat[21].start_date = 2012/09/01
control->coa_rec.pstat[21].end_date = 2012/09/30
control->coa_rec.pstat[21].jstart_date = 2456172
control->coa_rec.pstat[21].jend_date = 2456201
control->coa_rec.pstat[21].period_type = 205
control->coa_rec.pstat[21].period_year = 2012
control->coa_rec.pstat[21].period_num = 9
control->coa_rec.pstat[22].period_name = OCT-12
control->coa_rec.pstat[22].start_date = 2012/10/01
control->coa_rec.pstat[22].end_date = 2012/10/31
control->coa_rec.pstat[22].jstart_date = 2456202
control->coa_rec.pstat[22].jend_date = 2456232
control->coa_rec.pstat[22].period_type = 205
control->coa_rec.pstat[22].period_year = 2012
control->coa_rec.pstat[22].period_num = 10
control->coa_rec.pstat[23].period_name = NOV-12
control->coa_rec.pstat[23].start_date = 2012/11/01
control->coa_rec.pstat[23].end_date = 2012/11/30
control->coa_rec.pstat[23].jstart_date = 2456233
control->coa_rec.pstat[23].jend_date = 2456262
control->coa_rec.pstat[23].period_type = 205
control->coa_rec.pstat[23].period_year = 2012
control->coa_rec.pstat[23].period_num = 11
control->coa_rec.pstat[24].period_name = DEC-12
control->coa_rec.pstat[24].start_date = 2012/12/01
control->coa_rec.pstat[24].end_date = 2012/12/31
control->coa_rec.pstat[24].jstart_date = 2456263
control->coa_rec.pstat[24].jend_date = 2456293
control->coa_rec.pstat[24].period_type = 205
control->coa_rec.pstat[24].period_year = 2012
control->coa_rec.pstat[24].period_num = 12
control->coa_rec.pstat[25].period_name = ADJ-12
control->coa_rec.pstat[25].start_date = 2012/12/31
control->coa_rec.pstat[25].end_date = 2012/12/31
control->coa_rec.pstat[25].jstart_date = 2456293
control->coa_rec.pstat[25].jend_date = 2456293
control->coa_rec.pstat[25].period_type = 205
control->coa_rec.pstat[25].period_year = 2012
control->coa_rec.pstat[25].period_num = 13
control->coa_rec.pstat[26].period_name =
control->coa_rec.pstat[26].start_date =
control->coa_rec.pstat[26].end_date =
control->coa_rec.pstat[26].jstart_date = 0
control->coa_rec.pstat[26].jend_date = 0
control->coa_rec.pstat[26].period_type =
control->coa_rec.pstat[26].period_year = -1
control->coa_rec.pstat[26].period_num = -1
<< glapst() 29-DEC-2011 18:26:42
>> glacaf() 29-DEC-2011 18:26:42
glacaf() - caf0_stmt.arr =
select allocation_formula_id,
name,
full_allocation_flag,
je_category_name,
description,
conversion_method_code,
nvl(currency_conversion_type,'User') currency_conversion_type
from gl_alloc_formulas
where allocation_batch_id = :tbid
order by name
glacaf() - current allocation_batch_id = 10080
glacaf() - at top of CAF0 loop 1
glacaf() - tf = 1, sqlerrd[2] = 1
glacaf() - control->batch[0].formula = 12237032/0xbab8e8/056534350
glacaf() - total fetched   = 1
glacaf() - control->batch[0].formula[1].name =
<< glacaf() 29-DEC-2011 18:26:42
>> glacfl() 29-DEC-2011 18:26:42
glacfl() - cfl0_stmt.arr =
select fl.line_number,
fl.line_type,
fl.operator,
fl.amount,
nvl(fl.relative_period,'C'),
fl.actual_flag,
fl.budget_version_id,
fl.encumbrance_type_id,
fl.amount_type,
fl.segment_types_key,
fl.segment_break_key,
fl.transaction_currency,
decode(lgr.object_type_code,'S', fl.ledger_currency,decode(fl.ledger_id, null,decode(fl.ledger_currency, null, null, 'EGP', fl.ledger_currency, 'X'),fl.ledger_currency)) ledger_currency,
fl.currency_type,
fl.entered_currency,
DECODE(fl.line_number, 4, fl.transaction_currency,5, fl.transaction_currency,DECODE(fl.currency_type, 'T', fl.ledger_currency, fl.entered_currency)) resulting_currency,
DECODE(fl.amount,NULL,nvl(fl.ledger_id, 1078),NULL),
DECODE(fl.amount,NULL,fl.ledger_action_code,'') ledger_action_code,
DECODE(fl.amount,NULL,lgr.object_type_code,'') object_type_code,
DECODE(fl.amount,NULL,lgr.short_name,'') short_name,
DECODE(fl.amount,NULL,lgr.currency_code,'') currency_code,
DECODE(fl.amount,NULL,nvl(fl.SEGMENT1, '01'),NULL) SEGMENT1
, fl.SEGMENT2
, fl.SEGMENT3
, fl.SEGMENT4
from	 gl_alloc_formula_lines fl, gl_ledgers lgr
where	fl.allocation_formula_id = :tfid
and	  lgr.ledger_id(+) = decode(fl.amount, NULL,nvl(fl.ledger_id,1078), -1 )
order by fl.line_number
glacfl() - selectda->F = 25
glacfl() - bindda->F = 1
glacfl() - bi = 0
glacfl() - fi = 0
glacfl() - current allocation_formula_id = bindda->V[0] = 10142
glacfl() - at top of CFL0, lpcnt= 1 tf= 0
glacfl() - tf = 5, sqlerrd[2] = 5
glacfl.glafsv() - bi = 0, fi = 0, li = 0
glacfl.glafsv() - fl->segment = /0xbb8d40
glacfl() - line number 1 has SEGMENT1 = 01
glacfl() - calling glafcr with i = 0
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 1 has SEGMENT2 = 0000
glacfl() - calling glafcr with i = 1
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 1 has SEGMENT3 = 320200
glacfl() - calling glafcr with i = 2
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 1 has SEGMENT4 = 00
glacfl() - calling glafcr with i = 3
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl.glafsv() - bi = 0, fi = 0, li = 1
glacfl.glafsv() - fl->segment = /0xb85fd0
glacfl() - line number 2 has SEGMENT1 = 01
glacfl() - calling glafcr with i = 0
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 2 has SEGMENT2 = 9999
glacfl() - calling glafcr with i = 1
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 1, sqlerrd[2] = 1
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl.glafsv.glafcr() - svr->child_range = /0xb86090
glacfl.glafsv.glafcr() - cr_num_to_put = 0, n2 = 0
glacfl.glafsv.glafcr() -
svr->child_range[0].low = 0000
svr->child_range[0].high = 9999
glacfl.glafsv.glafcr() - total fetched   = 1
glacfl.glafsv.glafcr() -
svr->child_range[1].low =
svr->child_range[1].high =
glacfl() - line number 2 has SEGMENT3 = 320200
glacfl() - calling glafcr with i = 2
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 2 has SEGMENT4 = 00
glacfl() - calling glafcr with i = 3
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl.glafsv() - bi = 0, fi = 0, li = 2
glacfl.glafsv() - fl->segment = /0xb86100
glacfl() - line number 3 has SEGMENT1 = 01
glacfl() - calling glafcr with i = 0
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 3 has SEGMENT2 = 9999
glacfl() - calling glafcr with i = 1
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 1, sqlerrd[2] = 1
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl.glafsv.glafcr() - svr->child_range = /0xb861c0
glacfl.glafsv.glafcr() - cr_num_to_put = 0, n2 = 0
glacfl.glafsv.glafcr() -
svr->child_range[0].low = 0000
svr->child_range[0].high = 9999
glacfl.glafsv.glafcr() - total fetched   = 1
glacfl.glafsv.glafcr() -
svr->child_range[1].low =
svr->child_range[1].high =
glacfl() - line number 3 has SEGMENT3 = 320200
glacfl() - calling glafcr with i = 2
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 3 has SEGMENT4 = 00
glacfl() - calling glafcr with i = 3
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl.glafsv() - bi = 0, fi = 0, li = 3
glacfl.glafsv() - fl->segment = /0xb86230
glacfl() - line number 4 has SEGMENT1 = 01
glacfl() - calling glafcr with i = 0
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 4 has SEGMENT2 = 9999
glacfl() - calling glafcr with i = 1
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 1, sqlerrd[2] = 1
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl.glafsv.glafcr() - svr->child_range = /0xb862f0
glacfl.glafsv.glafcr() - cr_num_to_put = 0, n2 = 0
glacfl.glafsv.glafcr() -
svr->child_range[0].low = 0000
svr->child_range[0].high = 9999
glacfl.glafsv.glafcr() - total fetched   = 1
glacfl.glafsv.glafcr() -
svr->child_range[1].low =
svr->child_range[1].high =
glacfl() - line number 4 has SEGMENT3 = 320200
glacfl() - calling glafcr with i = 2
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 4 has SEGMENT4 = 00
glacfl() - calling glafcr with i = 3
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl.glafsv() - bi = 0, fi = 0, li = 4
glacfl.glafsv() - fl->segment = /0xb86360
glacfl() - line number 5 has SEGMENT1 = 01
glacfl() - calling glafcr with i = 0
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 5 has SEGMENT2 = 0000
glacfl() - calling glafcr with i = 1
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 5 has SEGMENT3 = 320200
glacfl() - calling glafcr with i = 2
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
glacfl() - line number 5 has SEGMENT4 = 00
glacfl() - calling glafcr with i = 3
glafcl.glafsv.glafcr() - fcr0_stmt.len = 197
glafcl.glafsv.glafcr() - fcr0_stmt.arr =
select   child_flex_value_low,
child_flex_value_high
from	 fnd_flex_value_hierarchies
where	flex_value_set_id = :fvs_id
and	  parent_flex_value = :pfv
order by child_flex_value_low
glacfl.glafsv.glafcr() - at top of FCR0 loop 1
glacfl.glafsv.glafcr() - tf = 0, sqlerrd[2] = 0
glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403
<< glacfl() 29-DEC-2011 18:26:42
>> glavto() 29-DEC-2011 18:26:42
glavto() - bi = 0, fi_limit = 1
glavto() - bi = 0, fi = 0: ELECTRIC ALLOCATION, tfid = 10142  ----------
glavto() - checking for TARGET line...
glavto() - checking for OFFSET line...
glavto() - TOP of k (line) loop: checking line 3 (3=Target, 4=Offset)
glavto() - TOP of k (line) loop: checking line 4 (3=Target, 4=Offset)
<< glavto() 29-DEC-2011 18:26:42
>> glavop() 29-DEC-2011 18:26:42
glavop() - bi = 0, fi_limit = 1
glavop() - bi = 0, fi = 0: ELECTRIC ALLOCATION ----------
glavop() - matching multiple operand segs...j (line) = 0
glavop() - ...i (seg) = 0
glavop() - ...i (seg) = 1
glavop() - ...i (seg) = 2
glavop() - ...i (seg) = 3
glavop() - matching multiple operand segs...j (line) = 1
glavop() - ...i (seg) = 0
glavop() - ...i (seg) = 1
glavop() - ...k (operand+1) = 2
glavop() - ...i (seg) = 2
glavop() - ...i (seg) = 3
glavop() - matching multiple operand segs...j (line) = 2
glavop() - ...i (seg) = 0
glavop() - ...i (seg) = 1
glavop() - ...i (seg) = 2
glavop() - ...i (seg) = 3
glavop() - matching operand looping segs against target line...
glavop() - matching operand looping segs against target line...
glavop() - matching operand looping segs against target line...
glavop() - FCP Allocation enabled
<< glavop() 29-DEC-2011 18:26:42
>> glavgn() 29-DEC-2011 18:26:42
glavgn() - bi = 0, fi_limit = 1
glavgn() - bi = 0, fi = 0: ELECTRIC ALLOCATION ----------
<< glavgn() 29-DEC-2011 18:26:42
>> glavpf() 29-DEC-2011 18:26:42
glavpf() - bi = 0, fi_limit = 1
glavpf() - bi = 0, fi = 0: ELECTRIC ALLOCATION ----------
<< glavpf() 29-DEC-2011 18:26:42
>> glamtt() 29-DEC-2011 18:26:42
AMAS0022: glamtt() - Trying to drop GL_ALLOC_TARGETS table ...29-DEC-2011 18:26:42
>> gluddl() 29-DEC-2011 18:26:42
<< gluddl() 29-DEC-2011 18:26:44
glamtt() - sqlcode alloc-target drop table = 942
glamtt() - mtt_stmt.arr is
CREATE TABLE gl_alloc_target_5811787 (
allocation_formula_id number(15) not null,
request_id			 number(15) not null,
entered_amount		   number	 not null,
accounted_amount		 number not null,
je_batch_id		 number(15) not null,
je_header_id		number(15) not null,
je_line_num		 number(15) not null,
period_name		 varchar2(15) not null,
accounting_date		 date not null,
max_amount_flag		VARCHAR2(1),
description		varchar2(240),
code_combination_id	number(15),
message_number	 number(15),
line_type			  VARCHAR2(1),
ledger_id	number(15),
validation_error	   VARCHAR2(30),
SEGMENT1		VARCHAR2(25),
SEGMENT2			   VARCHAR2(25),
SEGMENT3			   VARCHAR2(25),
SEGMENT4			   VARCHAR2(25),
SEGMENT5			   VARCHAR2(25),
SEGMENT6			   VARCHAR2(25),
SEGMENT7			   VARCHAR2(25),
SEGMENT8			   VARCHAR2(25),
SEGMENT9				  VARCHAR2(25),
SEGMENT10				 VARCHAR2(25),
SEGMENT11				 VARCHAR2(25),
SEGMENT12				 VARCHAR2(25),
SEGMENT13				 VARCHAR2(25),
SEGMENT14				 VARCHAR2(25),
SEGMENT15			   VARCHAR2(25),
SEGMENT16			   VARCHAR2(25),
SEGMENT17			   VARCHAR2(25),
SEGMENT18			   VARCHAR2(25),
SEGMENT19			   VARCHAR2(25),
SEGMENT20			   VARCHAR2(25),
SEGMENT21				 VARCHAR2(25),
SEGMENT22				 VARCHAR2(25),
SEGMENT23				 VARCHAR2(25),
SEGMENT24				 VARCHAR2(25),
SEGMENT25				 VARCHAR2(25),
SEGMENT26   VARCHAR2(25),
SEGMENT27   VARCHAR2(25),
SEGMENT28   VARCHAR2(25),
SEGMENT29   VARCHAR2(25),
SEGMENT30   VARCHAR2(25))
tablespace APPS_TS_INTERFACE
PCTFREE 50
STORAGE(initial 200K next 200K maxextents 121 pctincrease 0)
>> gluddl() 29-DEC-2011 18:26:44
<< gluddl() 29-DEC-2011 18:26:47
glamtt() - sqlcode alloc target create table = 0
glamtt() - mtt_stmt.arr is
CREATE INDEX gl_alloc_target_5811787_n1
on gl_alloc_target_5811787 (je_header_id)
TABLESPACE APPS_TS_INTERFACE
STORAGE(INITIAL 20K NEXT 20K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)
>> gluddl() 29-DEC-2011 18:26:47
<< gluddl() 29-DEC-2011 18:26:47
glamtt() - sqlcode alloc targets create n1 index = 0
glamtt() - mtt_stmt.arr is
CREATE INDEX gl_alloc_target_5811787_n2
on gl_alloc_target_5811787 (allocation_formula_id, je_line_num)
TABLESPACE APPS_TS_INTERFACE
STORAGE(INITIAL 20K NEXT 20K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)
>> gluddl() 29-DEC-2011 18:26:47
<< gluddl() 29-DEC-2011 18:26:47
glamtt() - sqlcode alloc target create n2 index = 0
<< glamtt() 29-DEC-2011 18:26:47
SHRD0119: Deleted 0 record(s) from GL_ALLOC_JE_ID_INT.
*****************************************************
sqlcaid:   sqlabc: 0  sqlcode: 0  sqlerrml: 0
sqlerrmc:
ORA-00942: table or view does not exist
							
sqlerrp:   sqlerrd: 0 0 0 0 0 538976288
sqlwarn:		   sqltext:
*****************************************************
oracaid:   oracabc: 0
oracchf: 0   oradbgf: 0   orahchf: 0  orastxtf: 0   orastxtl: 0
orastxtc:
orasfnmc:   oraslnr: 0  orasfnml: 0
orahoc: 0  ormoc:  0  oracoc: 0
oranor: 0  oranpr: 0  oranex:  0
SHRD0015: glamai failed:
SHRD0033: Error Status:   0
SHRD0103: Function warning number: -1
*****************************************************
<x glamai() 29-DEC-2011 18:26:47
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
 
+---------------------------------------------------------------------------+
Executing request completion options...
 
Finished executing request completion options.
glamai() - fatal sql error
+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Run MassAllocations" has completed with error.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 29-DEC-2011 18:26:51
+---------------------------------------------------------------------------+

شكرا جزيلا

كريم