I Have defined the Setup for Mass Allocation, but while generating the Mass Allocation the Counreent Program is errored out. i have attached the Log file here

Please Help

see the Log File Content Here bellow

----------------------------------------

+---------------------------------------------------------------------------+
General Ledger: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

GLAMAS module: Run MassAllocations
+---------------------------------------------------------------------------+

Current system time is 17-MAR-2012 03:26:10

+---------------------------------------------------------------------------+


>> glamai() 17-MAR-2012 03:26:10
**************************************************
17-MAR-2012 03:26:10
AMAS0010: General Ledger MassAllocations Log File
**************************************************

command_mode = C
access set id = 1242
incremental mode = N
average journal flag = N
ledger id override value = 1038
ledger override currency = CAD
balance segment override value = 01
allocation batch id = 10079
period = JUN-12
journal effective date = 2012/06/01 00:00:00
calc effective date = 2012/06/01 00:00:00

>> glasob() 17-MAR-2012 03:26:10

>> gluini() 17-MAR-2012 03:26:10

>> glugsn() 17-MAR-2012 03:26:10

<< glugsn() 17-MAR-2012 03:26:10

<< gluini() 17-MAR-2012 03:26:10

accounted period type = 64
chart_of_accounts_id = 53542
number of flexfield segments = 3
balancing segment name = SEGMENT1
management segment name = NA
security segment name = NA
flexfield delimiter = '.'
active segments =
SEGMENT1
SEGMENT2
SEGMENT3
flex value sets =
1025247
1025248
1025249
account segment = SEGMENT2
account segment length= 5
flexfield length = 11
<< glasob() 17-MAR-2012 03:26:10

>> glasys() 17-MAR-2012 03:26:10

***********************************************
* 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 = 1013415
foundation user name = APPSNV
concurrent request id = 5810843
number of target records to process at a time = 1000
number of flexfields to cache = 2500
cache control segment = SEGMENT2
length of control segment = 5
length of flexfield = 11
<< glasys() 17-MAR-2012 03:26:10

>> glavcmd() 17-MAR-2012 03:26:10
SHRD0117: Inserted 1 record(s) into gl_alloc_history


<< glavcmd() 17-MAR-2012 03:26:10

>> glacab() 17-MAR-2012 03:26:10

glacab() - tf = 1, sqlerrd[2] = 1

glacab--loopcnt = 1 and size 2b Malloced is 984

<< glacab() 17-MAR-2012 03:26:10

>> glapst() 17-MAR-2012 03:26:10

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 ='HOE Std Cal'
AND period_type ='64'
ORDER BY period_year, period_num
AMAS0025: glapst() - Found 12 periods (COA=53542)

control->coa_rec.pstat[0].period_name = JAN-12
control->coa_rec.pstat[0].start_date = 2012/01/01
control->coa_rec.pstat[0].end_date = 2012/01/31
control->coa_rec.pstat[0].jstart_date = 2455928
control->coa_rec.pstat[0].jend_date = 2455958
control->coa_rec.pstat[0].period_type = 64
control->coa_rec.pstat[0].period_year = 2012
control->coa_rec.pstat[0].period_num = 1

control->coa_rec.pstat[1].period_name = FEB-12
control->coa_rec.pstat[1].start_date = 2012/02/01
control->coa_rec.pstat[1].end_date = 2012/02/29
control->coa_rec.pstat[1].jstart_date = 2455959
control->coa_rec.pstat[1].jend_date = 2455987
control->coa_rec.pstat[1].period_type = 64
control->coa_rec.pstat[1].period_year = 2012
control->coa_rec.pstat[1].period_num = 2

control->coa_rec.pstat[2].period_name = MAR-12
control->coa_rec.pstat[2].start_date = 2012/03/01
control->coa_rec.pstat[2].end_date = 2012/03/31
control->coa_rec.pstat[2].jstart_date = 2455988
control->coa_rec.pstat[2].jend_date = 2456018
control->coa_rec.pstat[2].period_type = 64
control->coa_rec.pstat[2].period_year = 2012
control->coa_rec.pstat[2].period_num = 3

control->coa_rec.pstat[3].period_name = APR-12
control->coa_rec.pstat[3].start_date = 2012/04/01
control->coa_rec.pstat[3].end_date = 2012/04/30
control->coa_rec.pstat[3].jstart_date = 2456019
control->coa_rec.pstat[3].jend_date = 2456048
control->coa_rec.pstat[3].period_type = 64
control->coa_rec.pstat[3].period_year = 2012
control->coa_rec.pstat[3].period_num = 4

control->coa_rec.pstat[4].period_name = MAY-12
control->coa_rec.pstat[4].start_date = 2012/05/01
control->coa_rec.pstat[4].end_date = 2012/05/31
control->coa_rec.pstat[4].jstart_date = 2456049
control->coa_rec.pstat[4].jend_date = 2456079
control->coa_rec.pstat[4].period_type = 64
control->coa_rec.pstat[4].period_year = 2012
control->coa_rec.pstat[4].period_num = 5

control->coa_rec.pstat[5].period_name = JUN-12
control->coa_rec.pstat[5].start_date = 2012/06/01
control->coa_rec.pstat[5].end_date = 2012/06/30
control->coa_rec.pstat[5].jstart_date = 2456080
control->coa_rec.pstat[5].jend_date = 2456109
control->coa_rec.pstat[5].period_type = 64
control->coa_rec.pstat[5].period_year = 2012
control->coa_rec.pstat[5].period_num = 6

control->coa_rec.pstat[6].period_name = JUL-12
control->coa_rec.pstat[6].start_date = 2012/07/01
control->coa_rec.pstat[6].end_date = 2012/07/31
control->coa_rec.pstat[6].jstart_date = 2456110
control->coa_rec.pstat[6].jend_date = 2456140
control->coa_rec.pstat[6].period_type = 64
control->coa_rec.pstat[6].period_year = 2012
control->coa_rec.pstat[6].period_num = 7

control->coa_rec.pstat[7].period_name = AUG-12
control->coa_rec.pstat[7].start_date = 2012/08/01
control->coa_rec.pstat[7].end_date = 2012/08/31
control->coa_rec.pstat[7].jstart_date = 2456141
control->coa_rec.pstat[7].jend_date = 2456171
control->coa_rec.pstat[7].period_type = 64
control->coa_rec.pstat[7].period_year = 2012
control->coa_rec.pstat[7].period_num = 8

control->coa_rec.pstat[8].period_name = SEP-12
control->coa_rec.pstat[8].start_date = 2012/09/01
control->coa_rec.pstat[8].end_date = 2012/09/30
control->coa_rec.pstat[8].jstart_date = 2456172
control->coa_rec.pstat[8].jend_date = 2456201
control->coa_rec.pstat[8].period_type = 64
control->coa_rec.pstat[8].period_year = 2012
control->coa_rec.pstat[8].period_num = 9

control->coa_rec.pstat[9].period_name = OCT-12
control->coa_rec.pstat[9].start_date = 2012/10/01
control->coa_rec.pstat[9].end_date = 2012/10/31
control->coa_rec.pstat[9].jstart_date = 2456202
control->coa_rec.pstat[9].jend_date = 2456232
control->coa_rec.pstat[9].period_type = 64
control->coa_rec.pstat[9].period_year = 2012
control->coa_rec.pstat[9].period_num = 10

control->coa_rec.pstat[10].period_name = NOV-12
control->coa_rec.pstat[10].start_date = 2012/11/01
control->coa_rec.pstat[10].end_date = 2012/11/30
control->coa_rec.pstat[10].jstart_date = 2456233
control->coa_rec.pstat[10].jend_date = 2456262
control->coa_rec.pstat[10].period_type = 64
control->coa_rec.pstat[10].period_year = 2012
control->coa_rec.pstat[10].period_num = 11

control->coa_rec.pstat[11].period_name = DEC-12
control->coa_rec.pstat[11].start_date = 2012/12/01
control->coa_rec.pstat[11].end_date = 2012/12/31
control->coa_rec.pstat[11].jstart_date = 2456263
control->coa_rec.pstat[11].jend_date = 2456293
control->coa_rec.pstat[11].period_type = 64
control->coa_rec.pstat[11].period_year = 2012
control->coa_rec.pstat[11].period_num = 12

control->coa_rec.pstat[12].period_name =
control->coa_rec.pstat[12].start_date =
control->coa_rec.pstat[12].end_date =
control->coa_rec.pstat[12].jstart_date = 0
control->coa_rec.pstat[12].jend_date = 0
control->coa_rec.pstat[12].period_type =
control->coa_rec.pstat[12].period_year = -1
control->coa_rec.pstat[12].period_num = -1

<< glapst() 17-MAR-2012 03:26:10

>> glacaf() 17-MAR-2012 03:26:10

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 = 10079

glacaf() - at top of CAF0 loop 1

glacaf() - tf = 1, sqlerrd[2] = 1

glacaf() - control->batch[0].formula = 10976224/0xa77be0/051675740

glacaf() - total fetched = 1

glacaf() - control->batch[0].formula[1].name =

<< glacaf() 17-MAR-2012 03:26:10

>> glacfl() 17-MAR-2012 03:26:10

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, 'CAD', 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, 1038),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
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,1038), -1 )
order by fl.line_number

glacfl() - selectda->F = 24

glacfl() - bindda->F = 1

glacfl() - bi = 0

glacfl() - fi = 0

glacfl() - current allocation_formula_id = bindda->V[0] = 10141

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 = /0xa46340

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 = 5000

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 = 00

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.glafsv() - bi = 0, fi = 0, li = 1

glacfl.glafsv() - fl->segment = /0xa463d8

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 = 8000

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 2 has SEGMENT3 = 3P

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 = 1, sqlerrd[2] = 1

glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403

glacfl.glafsv.glafcr() - svr->child_range = /0xa5df68

glacfl.glafsv.glafcr() - cr_num_to_put = 0, n2 = 0

glacfl.glafsv.glafcr() -
svr->child_range[0].low = 01
svr->child_range[0].high = 03

glacfl.glafsv.glafcr() - total fetched = 1

glacfl.glafsv.glafcr() -
svr->child_range[1].low =
svr->child_range[1].high =

glacfl.glafsv() - bi = 0, fi = 0, li = 2

glacfl.glafsv() - fl->segment = /0xa46470

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 = 8000

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 3 has SEGMENT3 = 3P

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 = 1, sqlerrd[2] = 1

glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403

glacfl.glafsv.glafcr() - svr->child_range = /0xa46508

glacfl.glafsv.glafcr() - cr_num_to_put = 0, n2 = 0

glacfl.glafsv.glafcr() -
svr->child_range[0].low = 01
svr->child_range[0].high = 03

glacfl.glafsv.glafcr() - total fetched = 1

glacfl.glafsv.glafcr() -
svr->child_range[1].low =
svr->child_range[1].high =

glacfl.glafsv() - bi = 0, fi = 0, li = 3

glacfl.glafsv() - fl->segment = /0xa46578

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 = 5000

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 4 has SEGMENT3 = 3P

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 = 1, sqlerrd[2] = 1

glacfl.glafsv.glafcr() - post fetch, sqlcode = 1403

glacfl.glafsv.glafcr() - svr->child_range = /0xa46610

glacfl.glafsv.glafcr() - cr_num_to_put = 0, n2 = 0

glacfl.glafsv.glafcr() -
svr->child_range[0].low = 01
svr->child_range[0].high = 03

glacfl.glafsv.glafcr() - total fetched = 1

glacfl.glafsv.glafcr() -
svr->child_range[1].low =
svr->child_range[1].high =

glacfl.glafsv() - bi = 0, fi = 0, li = 4

glacfl.glafsv() - fl->segment = /0xa46680

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 = 5000

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 = 00

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() 17-MAR-2012 03:26:11

>> glavto() 17-MAR-2012 03:26:11

glavto() - bi = 0, fi_limit = 1

glavto() - bi = 0, fi = 0: Rent Expense Allocations, tfid = 10141 ----------

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() 17-MAR-2012 03:26:11

>> glavop() 17-MAR-2012 03:26:11

glavop() - bi = 0, fi_limit = 1

glavop() - bi = 0, fi = 0: Rent Expense Allocations ----------

glavop() - matching multiple operand segs...j (line) = 0

glavop() - ...i (seg) = 0

glavop() - ...i (seg) = 1

glavop() - ...i (seg) = 2

glavop() - matching multiple operand segs...j (line) = 1

glavop() - ...i (seg) = 0

glavop() - ...i (seg) = 1

glavop() - ...i (seg) = 2

glavop() - ...k (operand+1) = 2

glavop() - matching multiple operand segs...j (line) = 2

glavop() - ...i (seg) = 0

glavop() - ...i (seg) = 1

glavop() - ...i (seg) = 2

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() 17-MAR-2012 03:26:11

>> glavgn() 17-MAR-2012 03:26:11

glavgn() - bi = 0, fi_limit = 1

glavgn() - bi = 0, fi = 0: Rent Expense Allocations ----------

<< glavgn() 17-MAR-2012 03:26:11

>> glavpf() 17-MAR-2012 03:26:11

glavpf() - bi = 0, fi_limit = 1
glavpf() - bi = 0, fi = 0: Rent Expense Allocations ----------
<< glavpf() 17-MAR-2012 03:26:11

>> glamtt() 17-MAR-2012 03:26:11
AMAS0022: glamtt() - Trying to drop GL_ALLOC_TARGETS table ...17-MAR-2012 03:26:11

>> gluddl() 17-MAR-2012 03:26:11

<< gluddl() 17-MAR-2012 03:26:12

glamtt() - sqlcode alloc-target drop table = 942

glamtt() - mtt_stmt.arr is

CREATE TABLE gl_alloc_target_5810843 (
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() 17-MAR-2012 03:26:13

<< gluddl() 17-MAR-2012 03:26:15

glamtt() - sqlcode alloc target create table = 0

glamtt() - mtt_stmt.arr is

CREATE INDEX gl_alloc_target_5810843_n1
on gl_alloc_target_5810843 (je_header_id)
TABLESPACE APPS_TS_INTERFACE
STORAGE(INITIAL 20K NEXT 20K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)

>> gluddl() 17-MAR-2012 03:26:15

<< gluddl() 17-MAR-2012 03:26:15

glamtt() - sqlcode alloc targets create n1 index = 0

glamtt() - mtt_stmt.arr is

CREATE INDEX gl_alloc_target_5810843_n2
on gl_alloc_target_5810843 (allocation_formula_id, je_line_num)
TABLESPACE APPS_TS_INTERFACE
STORAGE(INITIAL 20K NEXT 20K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)

>> gluddl() 17-MAR-2012 03:26:15

<< gluddl() 17-MAR-2012 03:26:15

glamtt() - sqlcode alloc target create n2 index = 0

<< glamtt() 17-MAR-2012 03:26:15
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() 17-MAR-2012 03:26:15
+---------------------------------------------------------------------------+
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 17-MAR-2012 03:26:16

+---------------------------------------------------------------------------+