dba error

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
srisri.reddy
Posts: 15
Joined: Sat Oct 27, 2007 9:54 am
Location: India

dba error

Post by srisri.reddy »

hi
when i am entering the journal after posting it status shows completed error i am sending that error document plz any body give the solution

General Ledger: Version : 11.5.0 - Development

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

GLPPOS module: Posting
+---------------------------------------------------------------------------+

Current system time is 17-OCT-2007 18:03:29

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

....
<x gluddl() 17-OCT-2007 18:03:29
SHRD0187: Encountered the following error in routine gluddl():

ORA-01659: unable to allocate MINEXTENTS beyond 4 in tablespace APPS_T
SHRD0030: glpmpi() encountered an error returning from err_gluddl:

<x glpmpi() 17-OCT-2007 18:03:29

>> gluerr() 17-OCT-2007 18:03:29
Error in ROUTINE: glpmpi, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0
sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01659: unable to allocate MINEXTENTS beyond 4 in tablespace APPS_T
sqlerrp: sqlerrd: 0 0 1 0 0 0
sqlwarn:
sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...

>> glpuch() 17-OCT-2007 18:03:29
SHRD0180: glpuch() - Performing action >> update_cons_history(G/D/F)...

<< glpuch() 17-OCT-2007 18:03:29

>> glpueh() 17-OCT-2007 18:03:29
SHRD0180: glpueh() - Performing action >> update_elim_history(G/D/F)...

<< glpueh() 17-OCT-2007 18:03:29

PPOS0002: Posting terminated with fatal errors

<x glpmai() 17-OCT-2007 18:03:29


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


Finished executing request completion options.

GLPPOS - process exiting with failure.
Top
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:
Contact admin

Post by admin »

Hi, Before address you actual issue I have an observation that the date is 17-OCT-07? Is this error occurred in Oct and now you are addressing or the date is not proper on the server. Pl check.

Now there are two options like add additional datafile in the tablespace as it is full and auto extents are not enabled.

or

Enable auto extents.

Thanks
Top
zah_73
Posts: 2
Joined: Tue Sep 23, 2008 12:51 am
Location: Malaysia

Post by zah_73 »

Hi Admin,

I'm facing the error during daily posting and the error log are as follows:-

+---------------------------------------------------------------------------+
General Ledger: Version : 11.5.0 - Development

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

GLPPOS module: Posting
+---------------------------------------------------------------------------+

Current system time is 22-SEP-2008 11:07:33

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


>> glpmai() 22-SEP-2008 11:07:33
PPOS0003: *** Posting Process Started ***
PPOS0004: All phases to posting will be detailed in this log.
PPOS0219: glpmai() - Your Posting Run ID is 18901

>> glpini() 22-SEP-2008 11:07:33

>> gllock() 22-SEP-2008 11:07:33

>> gludlk() 22-SEP-2008 11:07:33

<< gludlk() 22-SEP-2008 11:07:33

<< gllock() 22-SEP-2008 11:07:33

>> glusts() 22-SEP-2008 11:07:33

>> glucce() 22-SEP-2008 11:07:33

>> glugsn() 22-SEP-2008 11:07:33

<< glugsn() 22-SEP-2008 11:07:33

<< glucce() 22-SEP-2008 11:07:34

<< glusts() 22-SEP-2008 11:07:34

>> glpuch() 22-SEP-2008 11:07:34

<< glpuch() 22-SEP-2008 11:07:34

>> glpueh() 22-SEP-2008 11:07:34

<< glpueh() 22-SEP-2008 11:07:34

<< glpini() 22-SEP-2008 11:07:34

>> glppva() 22-SEP-2008 11:07:34

<< glppva() 22-SEP-2008 11:07:34

>> glpmpi() 22-SEP-2008 11:07:34

>> gluddl() 22-SEP-2008 11:07:34

<< gluddl() 22-SEP-2008 11:07:34

>> gluddl() 22-SEP-2008 11:07:34

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

<< glpmpi() 22-SEP-2008 11:07:35

>> glpmdi() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

<< glpmdi() 22-SEP-2008 11:07:35

>> glpcjl() 22-SEP-2008 11:07:35

<< glpcjl() 22-SEP-2008 11:07:35

>> glpcbs() 22-SEP-2008 11:07:35

<< glpcbs() 22-SEP-2008 11:07:44

>> glpisl() 22-SEP-2008 11:07:44

<< glpisl() 22-SEP-2008 11:07:44

>> glpiil() 22-SEP-2008 11:07:44

>> glpiaie() 22-SEP-2008 11:07:44
SHRD0118: Updated 0 record(s) in table: GL_JE_HEADERS


<< glpiaie() 22-SEP-2008 11:07:48
PPOS0247: No actual balances were found in the intercompany journals.

>> glpiiel() 22-SEP-2008 11:07:48

<< glpiiel() 22-SEP-2008 11:07:48

<< glpiil() 22-SEP-2008 11:07:48

>> glpmni() 22-SEP-2008 11:07:48

<< glpmni() 22-SEP-2008 11:07:49

>> glphok() 22-SEP-2008 11:07:49

<< glphok() 22-SEP-2008 11:07:49

>> glperp() 22-SEP-2008 11:07:49

<< glperp() 22-SEP-2008 11:07:49

>> glpipi() 22-SEP-2008 11:07:49

>> glusts() 22-SEP-2008 11:07:49

>> glucce() 22-SEP-2008 11:07:49

>> glugsn() 22-SEP-2008 11:07:49

<< glugsn() 22-SEP-2008 11:07:49

<< glucce() 22-SEP-2008 11:07:49

<< glusts() 22-SEP-2008 11:07:49
GL_POSTING_INTERIM_18901
SHRD0117: Inserted 74872 record(s) into GL_POSTING_INTERIM_18901

SHRD0117: Inserted 11796 record(s) into GL_POSTING_INTERIM_18901


>> glugst() 22-SEP-2008 11:08:06

<< glugst() 22-SEP-2008 11:08:11

>> glpip2() 22-SEP-2008 11:08:11

>> glusts() 22-SEP-2008 11:08:11

>> glucce() 22-SEP-2008 11:08:11

>> glugsn() 22-SEP-2008 11:08:11

<< glugsn() 22-SEP-2008 11:08:11

<< glucce() 22-SEP-2008 11:08:11

<< glusts() 22-SEP-2008 11:08:11
PPOS0206: No statistical amounts in monetary journal entries found ...

<< glpip2() 22-SEP-2008 11:08:11

<< glpipi() 22-SEP-2008 11:08:11

>> glpidi() 22-SEP-2008 11:08:11

>> glugst() 22-SEP-2008 11:08:14

<< glugst() 22-SEP-2008 11:08:16

>> glugst() 22-SEP-2008 11:08:32

<< glugst() 22-SEP-2008 11:08:34

<< glpidi() 22-SEP-2008 11:08:34

>> glpire() 22-SEP-2008 11:08:34

>> glusts() 22-SEP-2008 11:08:34

>> glucce() 22-SEP-2008 11:08:34

>> glugsn() 22-SEP-2008 11:08:34

<< glugsn() 22-SEP-2008 11:08:34

<< glucce() 22-SEP-2008 11:08:34

<< glusts() 22-SEP-2008 11:08:34

<< glpire() 22-SEP-2008 11:08:34

>> glsamn() 22-SEP-2008 11:08:34

>> glsini() 22-SEP-2008 11:08:34
STPM0021: Defaulting optimize factor to 0.

<< glsini() 22-SEP-2008 11:08:34

>> glsfst() 22-SEP-2008 11:08:34

>> open_cursor() 22-SEP-2008 11:08:34

<< open_cursor() 22-SEP-2008 11:08:34

>> load_segnum_vsid() 22-SEP-2008 11:08:34

<< load_segnum_vsid() 22-SEP-2008 11:08:34

>> do_fetch_templates() 22-SEP-2008 11:08:34

<< do_fetch_templates() 22-SEP-2008 11:08:34

>> close_cursor() 22-SEP-2008 11:08:34

<< close_cursor() 22-SEP-2008 11:08:34

<< glsfst() 22-SEP-2008 11:08:34

<< glsamn() 22-SEP-2008 11:08:34

>> glpitr() 22-SEP-2008 11:08:34
insert into gl_posting_interim_18901 ( 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_18901 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_never_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() 22-SEP-2008 11:08:34

>> glpidt() 22-SEP-2008 11:08:34

<< glpidt() 22-SEP-2008 11:08:34

>> glpibr() 22-SEP-2008 11:08:34

>> glpibr.concurrency() 22-SEP-2008 11:08:34

<< glpibr.concurrency() 22-SEP-2008 11:08:34

>> glpidb() 22-SEP-2008 11:08:40

<< glpidb() 22-SEP-2008 11:08:46

<< glpibr() 22-SEP-2008 11:08:46

>> glpubr() 22-SEP-2008 11:08:46

>> glpubr.concurrency() 22-SEP-2008 11:08:46

<< glpubr.concurrency() 22-SEP-2008 11:08:46

>> glucce() 22-SEP-2008 11:09:25

>> glugsn() 22-SEP-2008 11:09:25

<< glugsn() 22-SEP-2008 11:09:25

<< glucce() 22-SEP-2008 11:09:25

>> glucce() 22-SEP-2008 11:09:25

>> glugsn() 22-SEP-2008 11:09:25

<< glugsn() 22-SEP-2008 11:09:25

<< glucce() 22-SEP-2008 11:09:25

>> glpudb() 22-SEP-2008 11:09:26
PPOS0225: glpudb(): Number of updated GL_DAILY_BALANCES rows does not equal the number or rows in GL_DAILY_POST_INT_18901 table.
PPOS0226: Balances update will be ROLLED BACK. Posting is stopping here.

<x glpudb() 22-SEP-2008 11:12:48
SHRD0030: glpubr() encountered an error returning from errexit:

<x glpubr() 22-SEP-2008 11:12:48

>> gluerr() 22-SEP-2008 11:12:48
Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found

sqlerrp: sqlerrd: 0 0 137790 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...

>> glpuch() 22-SEP-2008 11:12:48

<< glpuch() 22-SEP-2008 11:12:48

>> glpueh() 22-SEP-2008 11:12:48

<< glpueh() 22-SEP-2008 11:12:48

>> glpdit() 22-SEP-2008 11:12:48

>> gluddl() 22-SEP-2008 11:12:48

<< gluddl() 22-SEP-2008 11:12:49

<< glpdit() 22-SEP-2008 11:12:49

>> glpddi() 22-SEP-2008 11:12:49

>> gluddl() 22-SEP-2008 11:12:49

<< gluddl() 22-SEP-2008 11:12:49

>> gluddl() 22-SEP-2008 11:12:49

<< gluddl() 22-SEP-2008 11:12:49

<< glpddi() 22-SEP-2008 11:12:49
PPOS0002: Posting terminated with fatal errors

<x glpmai() 22-SEP-2008 11:12:49
+---------------------------------------------------------------------------+
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.


+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Posting" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 22-SEP-2008 11:12:50

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

We are currently stuck since 19-SEP-08 till todate.

Please help
Zara
Top
zah_73
Posts: 2
Joined: Tue Sep 23, 2008 12:51 am
Location: Malaysia

Post by zah_73 »

Hi Admin,

I'm facing the error during daily posting and the error log are as follows:-

+---------------------------------------------------------------------------+
General Ledger: Version : 11.5.0 - Development

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

GLPPOS module: Posting
+---------------------------------------------------------------------------+

Current system time is 22-SEP-2008 11:07:33

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


>> glpmai() 22-SEP-2008 11:07:33
PPOS0003: *** Posting Process Started ***
PPOS0004: All phases to posting will be detailed in this log.
PPOS0219: glpmai() - Your Posting Run ID is 18901

>> glpini() 22-SEP-2008 11:07:33

>> gllock() 22-SEP-2008 11:07:33

>> gludlk() 22-SEP-2008 11:07:33

<< gludlk() 22-SEP-2008 11:07:33

<< gllock() 22-SEP-2008 11:07:33

>> glusts() 22-SEP-2008 11:07:33

>> glucce() 22-SEP-2008 11:07:33

>> glugsn() 22-SEP-2008 11:07:33

<< glugsn() 22-SEP-2008 11:07:33

<< glucce() 22-SEP-2008 11:07:34

<< glusts() 22-SEP-2008 11:07:34

>> glpuch() 22-SEP-2008 11:07:34

<< glpuch() 22-SEP-2008 11:07:34

>> glpueh() 22-SEP-2008 11:07:34

<< glpueh() 22-SEP-2008 11:07:34

<< glpini() 22-SEP-2008 11:07:34

>> glppva() 22-SEP-2008 11:07:34

<< glppva() 22-SEP-2008 11:07:34

>> glpmpi() 22-SEP-2008 11:07:34

>> gluddl() 22-SEP-2008 11:07:34

<< gluddl() 22-SEP-2008 11:07:34

>> gluddl() 22-SEP-2008 11:07:34

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

<< glpmpi() 22-SEP-2008 11:07:35

>> glpmdi() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

>> gluddl() 22-SEP-2008 11:07:35

<< gluddl() 22-SEP-2008 11:07:35

<< glpmdi() 22-SEP-2008 11:07:35

>> glpcjl() 22-SEP-2008 11:07:35

<< glpcjl() 22-SEP-2008 11:07:35

>> glpcbs() 22-SEP-2008 11:07:35

<< glpcbs() 22-SEP-2008 11:07:44

>> glpisl() 22-SEP-2008 11:07:44

<< glpisl() 22-SEP-2008 11:07:44

>> glpiil() 22-SEP-2008 11:07:44

>> glpiaie() 22-SEP-2008 11:07:44
SHRD0118: Updated 0 record(s) in table: GL_JE_HEADERS


<< glpiaie() 22-SEP-2008 11:07:48
PPOS0247: No actual balances were found in the intercompany journals.

>> glpiiel() 22-SEP-2008 11:07:48

<< glpiiel() 22-SEP-2008 11:07:48

<< glpiil() 22-SEP-2008 11:07:48

>> glpmni() 22-SEP-2008 11:07:48

<< glpmni() 22-SEP-2008 11:07:49

>> glphok() 22-SEP-2008 11:07:49

<< glphok() 22-SEP-2008 11:07:49

>> glperp() 22-SEP-2008 11:07:49

<< glperp() 22-SEP-2008 11:07:49

>> glpipi() 22-SEP-2008 11:07:49

>> glusts() 22-SEP-2008 11:07:49

>> glucce() 22-SEP-2008 11:07:49

>> glugsn() 22-SEP-2008 11:07:49

<< glugsn() 22-SEP-2008 11:07:49

<< glucce() 22-SEP-2008 11:07:49

<< glusts() 22-SEP-2008 11:07:49
GL_POSTING_INTERIM_18901
SHRD0117: Inserted 74872 record(s) into GL_POSTING_INTERIM_18901

SHRD0117: Inserted 11796 record(s) into GL_POSTING_INTERIM_18901


>> glugst() 22-SEP-2008 11:08:06

<< glugst() 22-SEP-2008 11:08:11

>> glpip2() 22-SEP-2008 11:08:11

>> glusts() 22-SEP-2008 11:08:11

>> glucce() 22-SEP-2008 11:08:11

>> glugsn() 22-SEP-2008 11:08:11

<< glugsn() 22-SEP-2008 11:08:11

<< glucce() 22-SEP-2008 11:08:11

<< glusts() 22-SEP-2008 11:08:11
PPOS0206: No statistical amounts in monetary journal entries found ...

<< glpip2() 22-SEP-2008 11:08:11

<< glpipi() 22-SEP-2008 11:08:11

>> glpidi() 22-SEP-2008 11:08:11

>> glugst() 22-SEP-2008 11:08:14

<< glugst() 22-SEP-2008 11:08:16

>> glugst() 22-SEP-2008 11:08:32

<< glugst() 22-SEP-2008 11:08:34

<< glpidi() 22-SEP-2008 11:08:34

>> glpire() 22-SEP-2008 11:08:34

>> glusts() 22-SEP-2008 11:08:34

>> glucce() 22-SEP-2008 11:08:34

>> glugsn() 22-SEP-2008 11:08:34

<< glugsn() 22-SEP-2008 11:08:34

<< glucce() 22-SEP-2008 11:08:34

<< glusts() 22-SEP-2008 11:08:34

<< glpire() 22-SEP-2008 11:08:34

>> glsamn() 22-SEP-2008 11:08:34

>> glsini() 22-SEP-2008 11:08:34
STPM0021: Defaulting optimize factor to 0.

<< glsini() 22-SEP-2008 11:08:34

>> glsfst() 22-SEP-2008 11:08:34

>> open_cursor() 22-SEP-2008 11:08:34

<< open_cursor() 22-SEP-2008 11:08:34

>> load_segnum_vsid() 22-SEP-2008 11:08:34

<< load_segnum_vsid() 22-SEP-2008 11:08:34

>> do_fetch_templates() 22-SEP-2008 11:08:34

<< do_fetch_templates() 22-SEP-2008 11:08:34

>> close_cursor() 22-SEP-2008 11:08:34

<< close_cursor() 22-SEP-2008 11:08:34

<< glsfst() 22-SEP-2008 11:08:34

<< glsamn() 22-SEP-2008 11:08:34

>> glpitr() 22-SEP-2008 11:08:34
insert into gl_posting_interim_18901 ( 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_18901 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_never_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() 22-SEP-2008 11:08:34

>> glpidt() 22-SEP-2008 11:08:34

<< glpidt() 22-SEP-2008 11:08:34

>> glpibr() 22-SEP-2008 11:08:34

>> glpibr.concurrency() 22-SEP-2008 11:08:34

<< glpibr.concurrency() 22-SEP-2008 11:08:34

>> glpidb() 22-SEP-2008 11:08:40

<< glpidb() 22-SEP-2008 11:08:46

<< glpibr() 22-SEP-2008 11:08:46

>> glpubr() 22-SEP-2008 11:08:46

>> glpubr.concurrency() 22-SEP-2008 11:08:46

<< glpubr.concurrency() 22-SEP-2008 11:08:46

>> glucce() 22-SEP-2008 11:09:25

>> glugsn() 22-SEP-2008 11:09:25

<< glugsn() 22-SEP-2008 11:09:25

<< glucce() 22-SEP-2008 11:09:25

>> glucce() 22-SEP-2008 11:09:25

>> glugsn() 22-SEP-2008 11:09:25

<< glugsn() 22-SEP-2008 11:09:25

<< glucce() 22-SEP-2008 11:09:25

>> glpudb() 22-SEP-2008 11:09:26
PPOS0225: glpudb(): Number of updated GL_DAILY_BALANCES rows does not equal the number or rows in GL_DAILY_POST_INT_18901 table.
PPOS0226: Balances update will be ROLLED BACK. Posting is stopping here.

<x glpudb() 22-SEP-2008 11:12:48
SHRD0030: glpubr() encountered an error returning from errexit:

<x glpubr() 22-SEP-2008 11:12:48

>> gluerr() 22-SEP-2008 11:12:48
Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found

sqlerrp: sqlerrd: 0 0 137790 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...

>> glpuch() 22-SEP-2008 11:12:48

<< glpuch() 22-SEP-2008 11:12:48

>> glpueh() 22-SEP-2008 11:12:48

<< glpueh() 22-SEP-2008 11:12:48

>> glpdit() 22-SEP-2008 11:12:48

>> gluddl() 22-SEP-2008 11:12:48

<< gluddl() 22-SEP-2008 11:12:49

<< glpdit() 22-SEP-2008 11:12:49

>> glpddi() 22-SEP-2008 11:12:49

>> gluddl() 22-SEP-2008 11:12:49

<< gluddl() 22-SEP-2008 11:12:49

>> gluddl() 22-SEP-2008 11:12:49

<< gluddl() 22-SEP-2008 11:12:49

<< glpddi() 22-SEP-2008 11:12:49
PPOS0002: Posting terminated with fatal errors

<x glpmai() 22-SEP-2008 11:12:49
+---------------------------------------------------------------------------+
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.


+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Posting" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 22-SEP-2008 11:12:50

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

We are currently stuck since 19-SEP-08 till todate.

Please help
Zara
Top
Post Reply

Return to “Application DBA & System Administration”



Who is online

Users browsing this forum: No registered users and 4 guests