I have made formula lines for mass allocation and saved successfuly. now when i run the mass allocation, the request generated with errors. log file shows below error
------ ***********************************************
* 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 *
--------------------

let me know what is the reason, is it reason that OM prifle not set properly, however i have saved the sam at responsability level,

Profile is :MO Operating Unit

You are getting this warning because the following profile options are blank. Note that these are warnings not errors.

"GL: Number of Records to Process at Once"

The value will dictate the Number of Journal Lines that will be Processed at Once by Journal Import and MassAllocations/MassBudgeting programs.

If you leave this blank, your concurrent programs process 1000 journal lines at once.

"GL: Number of Accounts In Memory" dicatates the number of accounts that will be held in memory. If you leave this blank, 2500 is the assumed value.

Both of these profile options are optional.

But my journal entries are not being generated as the request set shows the Error i.e. completed but with errors. so wt problem can be as entries are not generated..

Look for the error in the log file.
Just to rule out, put 1000 and 2500 in the two profile options respectively at the Site level and run the allocation. See if that fixed the issue.

I set the two profile option value as u said, but still the requested not completed successfully, attached is the log file. kindly advise on early basis.

i unable to attach file, so log is copied here.
+---------------------------------------------------------------------------+
General Ledger: Version : 12.0.0

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

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

Current system time is 13-OCT-2011 05:30:37

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


>> glamai() 13-OCT-2011 05:30:37
**************************************************
13-OCT-2011 05:30:37
AMAS0010: General Ledger MassAllocations Log File
**************************************************

command_mode = C
access set id = 1982
incremental mode = N
average journal flag = N
ledger id override value = 1939
ledger override currency = SAR
balance segment override value = 1
allocation batch id = 28080
period = FEB-10
journal effective date = 2010/02/28 00:00:00
calc effective date = 2010/02/28 00:00:00

>> glasob() 13-OCT-2011 05:30:37

>> gluini() 13-OCT-2011 05:30:37

>> glugsn() 13-OCT-2011 05:30:37

<< glugsn() 13-OCT-2011 05:30:37

<< gluini() 13-OCT-2011 05:30:37

accounted period type = 64
chart_of_accounts_id = 54202
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 =
1026963
1026964
1026965
account segment = SEGMENT2
account segment length= 5
flexfield length = 11
<< glasob() 13-OCT-2011 05:30:37

>> glasys() 13-OCT-2011 05:30:37

foundation user id = 1028067
foundation user name = RIZ123
concurrent request id = 5967027
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() 13-OCT-2011 05:30:37

>> glavcmd() 13-OCT-2011 05:30:37

foundation user id = 1028067

foundation user name = RIZ123

concurrent request id = 5967027

concurrent request id = 5967027
SHRD0117: Inserted 1 record(s) into gl_alloc_history


<< glavcmd() 13-OCT-2011 05:30:37

>> glacab() 13-OCT-2011 05:30:37

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

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

<< glacab() 13-OCT-2011 05:30:37

>> glapst() 13-OCT-2011 05:30:37

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 ='MEDGULF CAL'
AND period_type ='64'
ORDER BY period_year, period_num
AMAS0025: glapst() - Found 12 periods (COA=54202)

control->coa_rec.pstat[0].period_name = JAN-10
control->coa_rec.pstat[0].start_date = 2010/01/01
control->coa_rec.pstat[0].end_date = 2010/01/31
control->coa_rec.pstat[0].jstart_date = 2455198
control->coa_rec.pstat[0].jend_date = 2455228
control->coa_rec.pstat[0].period_type = 64
control->coa_rec.pstat[0].period_year = 2010
control->coa_rec.pstat[0].period_num = 1

control->coa_rec.pstat[1].period_name = FEB-10
control->coa_rec.pstat[1].start_date = 2010/02/01
control->coa_rec.pstat[1].end_date = 2010/02/28
control->coa_rec.pstat[1].jstart_date = 2455229
control->coa_rec.pstat[1].jend_date = 2455256
control->coa_rec.pstat[1].period_type = 64
control->coa_rec.pstat[1].period_year = 2010
control->coa_rec.pstat[1].period_num = 2

control->coa_rec.pstat[2].period_name = MAR-10
control->coa_rec.pstat[2].start_date = 2010/03/01
control->coa_rec.pstat[2].end_date = 2010/03/31
control->coa_rec.pstat[2].jstart_date = 2455257
control->coa_rec.pstat[2].jend_date = 2455287
control->coa_rec.pstat[2].period_type = 64
control->coa_rec.pstat[2].period_year = 2010
control->coa_rec.pstat[2].period_num = 3

control->coa_rec.pstat[3].period_name = APR-10
control->coa_rec.pstat[3].start_date = 2010/04/01
control->coa_rec.pstat[3].end_date = 2010/04/30
control->coa_rec.pstat[3].jstart_date = 2455288
control->coa_rec.pstat[3].jend_date = 2455317
control->coa_rec.pstat[3].period_type = 64
control->coa_rec.pstat[3].period_year = 2010
control->coa_rec.pstat[3].period_num = 4

control->coa_rec.pstat[4].period_name = MAY-10
control->coa_rec.pstat[4].start_date = 2010/05/01
control->coa_rec.pstat[4].end_date = 2010/05/31
control->coa_rec.pstat[4].jstart_date = 2455318
control->coa_rec.pstat[4].jend_date = 2455348
control->coa_rec.pstat[4].period_type = 64
control->coa_rec.pstat[4].period_year = 2010
control->coa_rec.pstat[4].period_num = 5

control->coa_rec.pstat[5].period_name = JUN-10
control->coa_rec.pstat[5].start_date = 2010/06/01
control->coa_rec.pstat[5].end_date = 2010/06/30
control->coa_rec.pstat[5].jstart_date = 2455349
control->coa_rec.pstat[5].jend_date = 2455378
control->coa_rec.pstat[5].period_type = 64
control->coa_rec.pstat[5].period_year = 2010
control->coa_rec.pstat[5].period_num = 6

control->coa_rec.pstat[6].period_name = JUL-10
control->coa_rec.pstat[6].start_date = 2010/07/01
control->coa_rec.pstat[6].end_date = 2010/07/31
control->coa_rec.pstat[6].jstart_date = 2455379
control->coa_rec.pstat[6].jend_date = 2455409
control->coa_rec.pstat[6].period_type = 64
control->coa_rec.pstat[6].period_year = 2010
control->coa_rec.pstat[6].period_num = 7

control->coa_rec.pstat[7].period_name = AUG-10
control->coa_rec.pstat[7].start_date = 2010/08/01
control->coa_rec.pstat[7].end_date = 2010/08/31
control->coa_rec.pstat[7].jstart_date = 2455410
control->coa_rec.pstat[7].jend_date = 2455440
control->coa_rec.pstat[7].period_type = 64
control->coa_rec.pstat[7].period_year = 2010
control->coa_rec.pstat[7].period_num = 8

control->coa_rec.pstat[8].period_name = SEP-10
control->coa_rec.pstat[8].start_date = 2010/09/01
control->coa_rec.pstat[8].end_date = 2010/09/30
control->coa_rec.pstat[8].jstart_date = 2455441
control->coa_rec.pstat[8].jend_date = 2455470
control->coa_rec.pstat[8].period_type = 64
control->coa_rec.pstat[8].period_year = 2010
control->coa_rec.pstat[8].period_num = 9

control->coa_rec.pstat[9].period_name = OCT-10
control->coa_rec.pstat[9].start_date = 2010/10/01
control->coa_rec.pstat[9].end_date = 2010/10/31
control->coa_rec.pstat[9].jstart_date = 2455471
control->coa_rec.pstat[9].jend_date = 2455501
control->coa_rec.pstat[9].period_type = 64
control->coa_rec.pstat[9].period_year = 2010
control->coa_rec.pstat[9].period_num = 10

control->coa_rec.pstat[10].period_name = NOV-10
control->coa_rec.pstat[10].start_date = 2010/11/01
control->coa_rec.pstat[10].end_date = 2010/11/30
control->coa_rec.pstat[10].jstart_date = 2455502
control->coa_rec.pstat[10].jend_date = 2455531
control->coa_rec.pstat[10].period_type = 64
control->coa_rec.pstat[10].period_year = 2010
control->coa_rec.pstat[10].period_num = 11

control->coa_rec.pstat[11].period_name = DEC-10
control->coa_rec.pstat[11].start_date = 2010/12/01
control->coa_rec.pstat[11].end_date = 2010/12/31
control->coa_rec.pstat[11].jstart_date = 2455532
control->coa_rec.pstat[11].jend_date = 2455562
control->coa_rec.pstat[11].period_type = 64
control->coa_rec.pstat[11].period_year = 2010
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() 13-OCT-2011 05:30:37

>> glacaf() 13-OCT-2011 05:30:37

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

glacaf() - at top of CAF0 loop 1

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

glacaf() - control->batch[0].formula = 137723440/0x8357e30/01015277060

glacaf() - total fetched = 1

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

<< glacaf() 13-OCT-2011 05:30:37

>> glacfl() 13-OCT-2011 05:30:37

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, 'SAR', 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, 1939),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, '1'),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,1939), -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] = 22141

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

glacfl() - line number 1 has SEGMENT1 = 1

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

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

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

glacfl() - line number 2 has SEGMENT1 = 1

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

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

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

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

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

glacfl() - line number 3 has SEGMENT1 = 1

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

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

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

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

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

glacfl() - line number 4 has SEGMENT1 = 1

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

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

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

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

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

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

glacfl() - line number 5 has SEGMENT1 = 1

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

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

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() 13-OCT-2011 05:30:37

>> glavto() 13-OCT-2011 05:30:37

glavto() - bi = 0, fi_limit = 1

glavto() - bi = 0, fi = 0: RENT EXPENSE ALLOCATION, tfid = 22141 ----------

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() 13-OCT-2011 05:30:37

>> glavop() 13-OCT-2011 05:30:37

glavop() - bi = 0, fi_limit = 1

glavop() - bi = 0, fi = 0: RENT EXPENSE ALLOCATION ----------

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() 13-OCT-2011 05:30:37

>> glavgn() 13-OCT-2011 05:30:37

glavgn() - bi = 0, fi_limit = 1

glavgn() - bi = 0, fi = 0: RENT EXPENSE ALLOCATION ----------

<< glavgn() 13-OCT-2011 05:30:37

>> glavpf() 13-OCT-2011 05:30:37

glavpf() - bi = 0, fi_limit = 1
glavpf() - bi = 0, fi = 0: RENT EXPENSE ALLOCATION ----------
<< glavpf() 13-OCT-2011 05:30:37

>> glavuf() 13-OCT-2011 05:30:37
Inside glavuf
glavuf() - bi = 0, fi_limit = 1
glavuf() - bi = 0, fi = 0: RENT EXPENSE ALLOCATIONInside glavuf1Inside glavuf2Inside glavuf3
SHRD0118: Updated 1 record(s) in table: GL_ALLOC_FORMULAS


<< glavuf() 13-OCT-2011 05:30:37

>> glavub() 13-OCT-2011 05:30:37
SHRD0118: Updated 1 record(s) in table: GL_ALLOC_BATCHES


<< glavub() 13-OCT-2011 05:30:37

>> glamtt() 13-OCT-2011 05:30:37
AMAS0022: glamtt() - Trying to drop GL_ALLOC_TARGETS table ...13-OCT-2011 05:30:37

>> gluddl() 13-OCT-2011 05:30:37

<< gluddl() 13-OCT-2011 05:30:38

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

glamtt() - mtt_stmt.arr is

CREATE TABLE gl_alloc_target_5967027 (
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() 13-OCT-2011 05:30:39

<< gluddl() 13-OCT-2011 05:30:39

glamtt() - sqlcode alloc target create table = 0

glamtt() - mtt_stmt.arr is

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

>> gluddl() 13-OCT-2011 05:30:39

<< gluddl() 13-OCT-2011 05:30:39

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

glamtt() - mtt_stmt.arr is

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

>> gluddl() 13-OCT-2011 05:30:39

<< gluddl() 13-OCT-2011 05:30:39

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

<< glamtt() 13-OCT-2011 05:30:39
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: 50 ormoc: 12 oracoc: 11
oranor: 0 oranpr: 45 oranex: 45

SHRD0015: glamai failed:
SHRD0033: Error Status: 0
SHRD0103: Function warning number: -1
*****************************************************
glamai() - fatal sql error

Process logging off database and exiting ...

<x glamai() 13-OCT-2011 05:30:39
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
1277


Finished executing request completion options.
glamai() - fatal sql error

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 13-OCT-2011 05:30:39

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

glavub() - bi = 0

Number of Accounts In Memory

Following objects might be missing in your database GL_ALLOC_INT_1,GL_ALLOC_INT_2 and GL_ALLOC_INT_3.
Please verify if this is the case first before proceeding further.

Create the missing objects GL_ALLOC_INT_1,GL_ALLOC_INT_2 and GL_ALLOC_INT_3.

The missing object should be created from the xdf file gl_alloc_int_1.xdf,gl_alloc_int_2.xdf and
gl_alloc_int_3.xdf

The xdf file is placed under $GL_TOP/patch/115/xdf/.

Usage of the Utility adodfcmp :

adodfcmp odffile=<Filename> mode=<Objects to be checked/updated> changedb=NO \
userid=<User>/<Password> touser=<User>/<Password> priv_schema=SYSTEM/<Password>