Question from guest on May 29 at 1:45 AM Hi
Below is the error log while consolidation run.
+---------------------------------------------------------------------------+
General Ledger: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLPPOS module: Posting
+---------------------------------------------------------------------------+
Current system time is 21-MAY-2012 11:22:51
+---------------------------------------------------------------------------+
>> glpmai() 21-MAY-2012 11:22:51
PPOS0003: *** Posting Process Started ***
PPOS0004: All phases to posting will be detailed in this log.
PPOS0219: glpmai() - Your Posting Run ID is 35750
>> glpini() 21-MAY-2012 11:22:51
>> gllock() 21-MAY-2012 11:22:51
>> gludlk() 21-MAY-2012 11:22:51
<< gludlk() 21-MAY-2012 11:22:51
<< gllock() 21-MAY-2012 11:22:51
>> glusts() 21-MAY-2012 11:22:51
>> glucce() 21-MAY-2012 11:22:51
>> glugsn() 21-MAY-2012 11:22:51
<< glugsn() 21-MAY-2012 11:22:51
<< glucce() 21-MAY-2012 11:22:51
<< glusts() 21-MAY-2012 11:22:51
>> glpuch() 21-MAY-2012 11:22:51
<< glpuch() 21-MAY-2012 11:22:51
>> glpueh() 21-MAY-2012 11:22:51
<< glpueh() 21-MAY-2012 11:22:51
<< glpini() 21-MAY-2012 11:22:51
>> glppva() 21-MAY-2012 11:22:51
<< glppva() 21-MAY-2012 11:22:51
>> glpmpi() 21-MAY-2012 11:22:51
>> gluddl() 21-MAY-2012 11:22:51
<< gluddl() 21-MAY-2012 11:22:51
>> gluddl() 21-MAY-2012 11:22:51
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
<< glpmpi() 21-MAY-2012 11:22:52
>> glpmdi() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
>> gluddl() 21-MAY-2012 11:22:52
<< gluddl() 21-MAY-2012 11:22:52
<< glpmdi() 21-MAY-2012 11:22:52
>> glpcjl() 21-MAY-2012 11:22:52
<< glpcjl() 21-MAY-2012 11:22:52
>> glpcbs() 21-MAY-2012 11:22:52
<< glpcbs() 21-MAY-2012 11:22:54
>> glpisl() 21-MAY-2012 11:22:54
<< glpisl() 21-MAY-2012 11:22:54
>> glpiil() 21-MAY-2012 11:22:54
>> glpiaie() 21-MAY-2012 11:22:54
SHRD0118: Updated 0 record(s) in table: GL_JE_HEADERS
<< glpiaie() 21-MAY-2012 11:22:54
PPOS0247: No actual balances were found in the intercompany journals.
>> glpiiel() 21-MAY-2012 11:22:54
<< glpiiel() 21-MAY-2012 11:22:54
<< glpiil() 21-MAY-2012 11:22:54
>> glpmni() 21-MAY-2012 11:22:54
<< glpmni() 21-MAY-2012 11:22:54
>> glpuch() 21-MAY-2012 11:22:54
<< glpuch() 21-MAY-2012 11:22:54
>> glphok() 21-MAY-2012 11:22:54
<< glphok() 21-MAY-2012 11:22:54
>> glperp() 21-MAY-2012 11:22:54
<< glperp() 21-MAY-2012 11:22:55
>> glpipi() 21-MAY-2012 11:22:55
>> glusts() 21-MAY-2012 11:22:55
>> glucce() 21-MAY-2012 11:22:55
>> glugsn() 21-MAY-2012 11:22:55
<< glugsn() 21-MAY-2012 11:22:55
<< glucce() 21-MAY-2012 11:22:55
<< glusts() 21-MAY-2012 11:22:55
GL_POSTING_INTERIM_35750
SHRD0117: Inserted 108 record(s) into GL_POSTING_INTERIM_35750
SHRD0117: Inserted 0 record(s) into GL_POSTING_INTERIM_35750
>> glugst() 21-MAY-2012 11:22:55
<< glugst() 21-MAY-2012 11:22:55
>> glpip2() 21-MAY-2012 11:22:55
>> glusts() 21-MAY-2012 11:22:55
>> glucce() 21-MAY-2012 11:22:55
>> glugsn() 21-MAY-2012 11:22:55
<< glugsn() 21-MAY-2012 11:22:55
<< glucce() 21-MAY-2012 11:22:55
<< glusts() 21-MAY-2012 11:22:55
PPOS0206: No statistical amounts in monetary journal entries found ...
<< glpip2() 21-MAY-2012 11:22:55
<< glpipi() 21-MAY-2012 11:22:55
>> glpidi() 21-MAY-2012 11:22:55
>> glugst() 21-MAY-2012 11:22:56
<< glugst() 21-MAY-2012 11:22:56
<< glpidi() 21-MAY-2012 11:22:56
>> glpire() 21-MAY-2012 11:22:56
>> glusts() 21-MAY-2012 11:22:56
>> glucce() 21-MAY-2012 11:22:56
>> glugsn() 21-MAY-2012 11:22:56
<< glugsn() 21-MAY-2012 11:22:56
<< glucce() 21-MAY-2012 11:22:56
<< glusts() 21-MAY-2012 11:22:56
<< glpire() 21-MAY-2012 11:22:56
>> glsamn() 21-MAY-2012 11:22:56
>> glsini() 21-MAY-2012 11:22:56
STPM0021: Defaulting optimize factor to 0.
<< glsini() 21-MAY-2012 11:22:56
>> glsfst() 21-MAY-2012 11:22:56
>> open_cursor() 21-MAY-2012 11:22:56
<< open_cursor() 21-MAY-2012 11:22:56
>> load_segnum_vsid() 21-MAY-2012 11:22:56
<< load_segnum_vsid() 21-MAY-2012 11:22:56
>> do_fetch_templates() 21-MAY-2012 11:22:56
<< do_fetch_templates() 21-MAY-2012 11:22:56
>> close_cursor() 21-MAY-2012 11:22:56
<< close_cursor() 21-MAY-2012 11:22:56
<< glsfst() 21-MAY-2012 11:22:56
<< glsamn() 21-MAY-2012 11:22:56
>> glpitr() 21-MAY-2012 11:22:56
insert into gl_posting_interim_35750 ( code_combination_id, period_name, set_of_books_id, currency_code, period_year, period_num, period_type, account_type, bal_seg_value, actual_flag, encumbrance_type_id, budget_version_id, period_net_dr, period_net_cr, begin_balance_dr, begin_balance_cr, quarter_to_date_dr, quarter_to_date_cr, project_to_date_dr, project_to_date_cr, period_net_dr_beq, period_net_cr_beq, begin_balance_dr_beq, begin_balance_cr_beq, template_id, translated_flag ) select pi.code_combination_id, pi.period_name, pi.set_of_books_id, tt.target_currency, pi.period_year, pi.period_num, pi.period_type, pi.account_type, pi.bal_seg_value, pi.actual_flag, pi.encumbrance_type_id, pi.budget_version_id, 0, 0, 0, 0, 0, 0, 0, 0, NULL,
NULL, NULL, NULL, NULL, 'N' from gl_sets_of_books sob, gl_translation_tracking tt, gl_posting_interim_35750 pi where pi.set_of_books_id = tt.set_of_books_id and tt.actual_flag = 'A' and nvl(SUBSTRB(pi.bal_seg_value,1,(INSTRB(pi.bal_seg_ value||'
','
',1)-1)),-1) = nvl(tt.bal_seg_value,-1) and (pi.period_year*1000+pi.period_num) >= (tt.earliest_ever_period_year*1000+tt.earliest_ever _period_num) and (pi.period_year*1000+pi.period_num) < (tt.earliest_never_period_year*1000+tt.earliest_nev er_period_num) and pi.set_of_books_id = sob.set_of_books_id and pi.actual_flag = 'A' and pi.currency_code = sob.currency_code and pi.template_id is NULL and pi.translated_flag is NULL and tt.average_translation_flag = 'N' and tt.target_currency is NOT NULL
<< glpitr() 21-MAY-2012 11:22:56
>> glpidt() 21-MAY-2012 11:22:56
<< glpidt() 21-MAY-2012 11:22:56
>> glpibr() 21-MAY-2012 11:22:56
>> glpibr.concurrency() 21-MAY-2012 11:22:56
<< glpibr.concurrency() 21-MAY-2012 11:22:56
>> glpidb() 21-MAY-2012 11:22:57
<< glpidb() 21-MAY-2012 11:22:57
<< glpibr() 21-MAY-2012 11:22:57
>> glpubr() 21-MAY-2012 11:22:57
>> glpubr.concurrency() 21-MAY-2012 11:22:57
<< glpubr.concurrency() 21-MAY-2012 11:22:57
PPOS0225: glpubr(): Number of updated GL_BALANCES rows does not equal the number or rows in GL_POSTING_INTERIM_35750 table.
PPOS0226: Balances update will be ROLLED BACK. Posting is stopping here.
<x glpubr() 21-MAY-2012 11:22:57
>> gluerr() 21-MAY-2012 11:22:57
Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
glpubr:updated balances rows != gl_interim_posting rows. Posting stops.
CALL YOUR CUSTOMER SUPPORT REPRESENTATIVE!
***************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found
sqlerrp: sqlerrd: 0 0 248 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...
>> glpuch() 21-MAY-2012 11:22:57
<< glpuch() 21-MAY-2012 11:22:57
>> glpueh() 21-MAY-2012 11:22:57
<< glpueh() 21-MAY-2012 11:22:57
>> glpdit() 21-MAY-2012 11:22:57
>> gluddl() 21-MAY-2012 11:22:57
<< gluddl() 21-MAY-2012 11:22:57
<< glpdit() 21-MAY-2012 11:22:57
>> glpddi() 21-MAY-2012 11:22:57
>> gluddl() 21-MAY-2012 11:22:57
<< gluddl() 21-MAY-2012 11:22:58
>> gluddl() 21-MAY-2012 11:22:58
<< gluddl() 21-MAY-2012 11:22:58
<< glpddi() 21-MAY-2012 11:22:58
PPOS0002: Posting terminated with fatal errors
<x glpmai() 21-MAY-2012 11:22:58
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
GLPPOS - process exiting with failure.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 21-MAY-2012 11:22:58
+---------------------------------------------------------------------------+
| Reply to this email to post your response. __.____._ |   _.____.__ |
