karimla131 بتاريخ: 29 ديسمبر 2011 تقديم بلاغ مشاركة بتاريخ: 29 ديسمبر 2011 السلام عليكم .. أنا عندي مشكلة في ال 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 +---------------------------------------------------------------------------+ شكرا جزيلا كريم اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
Recommended Posts
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.