0 Replies Latest reply: Jul 21, 2008 6:56 AM by 611394 RSS

    ORA-01658: unable to create INITIAL extent for segment in tablespace A

    611394
      Hi,

      Please Help Me. I am getting this error when i try to post journal entries.
      ORA-01658: unable to create INITIAL extent for segment in tablespace A

      Log:
      ---------------------------------------------------------------------------
      General Ledger: Version : 11.5.0 - Development

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

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

      Current system time is 21-JUL-2008 16:45:36

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

      glpmai() 21-JUL-2008 16:45:36
      SHRD0176: GLPPOS started in debug mode...
      PPOS0003: *** Posting Process Started ***
      PPOS0004: All phases to posting will be detailed in this log.
      PPOS0219: glpmai() - Your Posting Run ID is 31623
      glpini() 21-JUL-2008 16:45:36
      gllock() 21-JUL-2008 16:45:36
      SHRD0181: glpini - Lock Name = GL_OPEN_POST_1
      gludlk() 21-JUL-2008 16:45:37
      << gludlk() 21-JUL-2008 16:45:37
      SHRD0180: glpini - Performing action >> Placed SHARE_MODE lock...

      << gllock() 21-JUL-2008 16:45:37
      SHRD0180: glpini() - Performing action >> check_batches_exist...
      glusts() 21-JUL-2008 16:45:37
      glucce() 21-JUL-2008 16:45:37
      glugsn() 21-JUL-2008 16:45:37
      << glugsn() 21-JUL-2008 16:45:37

      << glucce() 21-JUL-2008 16:45:37

      << glusts() 21-JUL-2008 16:45:37
      Secondary tracking segment disabled
      SHRD0180: glpini() - Performing action >> get_bal_seg_name...
      SHRD0180: glpini() - Performing action >> get_sob_info...
      SHRD0181: glpini() - MRC TYPE = P
      SHRD0180: glpini() - Performing action >> update_batch_status...
      glpuch() 21-JUL-2008 16:45:37
      SHRD0180: glpuch() - Performing action >> update_cons_history(G/D/F)...

      << glpuch() 21-JUL-2008 16:45:37
      glpueh() 21-JUL-2008 16:45:37
      SHRD0180: glpueh() - Performing action >> update_elim_history(G/D/F)...

      << glpueh() 21-JUL-2008 16:45:37
      SHRD0180: glpini() - Performing action >> check_mrc_rpt_sob_exist...
      SHRD0180: glpini() - Performing action >> check_budget_jes_exist...
      SHRD0180: glpini() - Performing action >> check_mixed_stat_jes_exist...
      SHRD0180: glpini() - Performing action >> check_adj_periods_exist...

      SHRD0181: glpini() - control->sob_id = 1
      SHRD0181: glpini() - control->coa_id = 101
      SHRD0181: glpini() - control->prun_id = 31623
      SHRD0181: glpini() - control->func_curr_code = USD
      SHRD0181: glpini() - control->period_set_name = Accounting
      SHRD0181: glpini() - control->period_type = Month
      SHRD0181: glpini() - control->net_income_ccid = 0
      SHRD0181: glpini() - control->rounding_ccid = 27120
      SHRD0181: glpini() - control->cons_sob = FALSE
      SHRD0181: glpini() - control->ab_enabled = FALSE
      SHRD0181: glpini() - control->bc_enabled = FALSE
      SHRD0181: glpini() - control->ic_allowed = TRUE
      SHRD0181: glpini() - control->sus_allowed = TRUE
      SHRD0181: glpini() - control->track_rounding_imbal = TRUE
      SHRD0181: glpini() - control->tax_enabled = FALSE
      SHRD0181: glpini() - control->aprv_enabled = FALSE
      SHRD0181: glpini() - control->batches_exist = TRUE
      SHRD0181: glpini() - control->actual_ab_jes_exist = FALSE
      SHRD0181: glpini() - control->foreign_ab_jes_exist = FALSE
      SHRD0181: glpini() - control->budget_jes_exist = FALSE
      SHRD0181: glpini() - control->mixed_stat_jes_exist = FALSE
      SHRD0181: glpini() - control->adj_periods_exist = FALSE
      SHRD0181: glpini() - control->cons_jes_exist = TRUE
      SHRD0181: glpini() - control->acct_cat_bal = FALSE
      SHRD0181: glpini() - control->mrc_primary_sob = FALSE
      SHRD0181: glpini() - control->max_days_roll_fwd = 32
      SHRD0181: glpini() - control->min_aggregate_num = 0
      SHRD0181: glpini() - control->max_aggregate_num = 0
      SHRD0181: glpini() - control->industry = C
      SHRD0181: glpini() - control->bal_seg_name = SEGMENT1
      SHRD0181: glpini() - control->bal_seg_num = 0
      SHRD0181: glpini() - control->user_name = OPERATIONS
      SHRD0181: glpini() - control->user_id = 1318
      SHRD0181: glpini() - control->login_id = 2527772
      SHRD0181: glpini() - control->request_id = 2770672
      SHRD0181: glpini() - control->program_id = 101
      SHRD0181: glpini() - control->dmode = TRUE

      << glpini() 21-JUL-2008 16:45:37
      glppva() 21-JUL-2008 16:45:37
      << glppva() 21-JUL-2008 16:45:37
      glpmpi() 21-JUL-2008 16:45:37
      gluddl() 21-JUL-2008 16:45:37
      << gluddl() 21-JUL-2008 16:45:38
      gluddl() 21-JUL-2008 16:45:38
      -- gluddl ad.do_ddl error buffer begin
      do_ddl(APPLSYS, SQLGL, 1, $statement$, gl_posting_interim_31623): private_do_ddl(APPS, APPLSYS, GL, 1, $statement$, GL_POSTING_INTERIM_31623): do_cd_tab_cd_seq(0, APPS, GL, 1, GL_POSTING_INTERIM_31623, $statement$): : do_apps_ddl(GL, $statement$): : substr($statement$,1,255)='
      create table gl_posting_interim_31623
           (code_combination_id number(15) not null,
           period_name     varchar2(15) not null,
           set_of_books_id number(15) not null,
           currency_code varchar2(15) not null,
           period_year     number(15),
           pe'
      -- gluddl ad.do_ddl error buffer end
      -- gluddl Message Dictionary Start:
      do_ddl(APPLSYS, SQLGL, 1, $statement$, gl_posting_interim_31623): private_do_ddl(APPS, APPLSYS, GL, 1, $statement$, GL_POSTING_INTERIM_31623): do_cd_tab_cd_seq(0, APPS, GL, 1, GL_POSTING_INTERIM_31623, $statement$): : do_apps_ddl(GL, $statement$): : substr($statement$,1,255)='
      create table gl_posting_interim_31623
           (code_combination_id number(15) not null,
           period_name     varchar2(15) not null,
           set_of_books_id number(15) not null,
           currency_code varchar2(15) not null,
           period_year     number(15),
           pe'
      ORA-01658: unable to create INITIAL extent for segment in tablespace A

      -- gluddl Message Dictionary End

      <x gluddl() 21-JUL-2008 16:45:38
      SHRD0187: Encountered the following error in routine gluddl():
      ORA-01658: unable to create INITIAL extent for segment in tablespace A
      SHRD0030: glpmpi() encountered an error returning from err_gluddl:

      <x glpmpi() 21-JUL-2008 16:45:38
      gluerr() 21-JUL-2008 16:45:38
      Error in ROUTINE: glpmpi, status: 0
      SHRD0043: ERROR:
      ***************************************************
      sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
      sqlerrmc:
      ORA-01658: unable to create INITIAL extent for segment in tablespace A
      sqlerrp:      sqlerrd: 0 0 1 0 0 0
      sqlwarn: sqltext:
      *****************************************************
      SHRD0044: Process logging off database and exiting ...
      glpuch() 21-JUL-2008 16:45:38
      SHRD0180: glpuch() - Performing action >> update_cons_history(G/D/F)...

      << glpuch() 21-JUL-2008 16:45:38
      glpueh() 21-JUL-2008 16:45:38
      SHRD0180: glpueh() - Performing action >> update_elim_history(G/D/F)...

      << glpueh() 21-JUL-2008 16:45:38
      PPOS0002: Posting terminated with fatal errors

      <x glpmai() 21-JUL-2008 16:45:38


      ---------------------------------------------------------------------------
      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 21-JUL-2008 16:45:39

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

      I een tried altering temp tablespace.. But the Same problem continues....

      Please Help Me


      Sridhar