6 Replies Latest reply on Nov 25, 2018 1:32 AM by 3825247

    can't create summary accounts template with error "SHRD0075: Error in glstadd_addtmp()."

    3825247

      output log:

       

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

      General Ledger: Version : 12.0.0

       

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

       

      GLSTPM module: Add/Delete Summary Accounts

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

       

      Current system time is 23-NOV-2018 10:43:11

       

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

       

       

      >> main() 23-NOV-2018 10:43:11

      ledger_id = 1020

      coa_id = 53684

      status_flag = A

      template_id = 1300

       

      >> glsini() 23-NOV-2018 10:43:11

      STPM0021: Defaulting optimize factor to 0.

       

      << glsini() 23-NOV-2018 10:43:11

       

      >> glstexs() 23-NOV-2018 10:43:11

       

      << glstexs() 23-NOV-2018 10:43:11

       

      >> glsfst() 23-NOV-2018 10:43:11

      Initialize template

       

      >> open_cursor() 23-NOV-2018 10:43:11

       

      Length of stmt = 867

      SELECT s.template_id, s.template_name,

      decode(s.template_id, NULL, NULL,

      (SELECT nvl(max(bc.funds_check_level_code),'N')

      FROM gl_summary_bc_options bc

      WHERE bc.template_id = s.template_id)),

      s.max_code_combination_id, s.account_category_code,

      s.segment1_type, s.segment2_type, s.segment3_type,

      s.segment4_type, s.segment5_type, s.segment6_type,

      s.segment7_type, s.segment8_type, s.segment9_type,

      s.segment10_type, s.segment11_type,s.segment12_type,

      s.segment13_type, s.segment14_type, s.segment15_type,

      s.segment16_type, s.segment17_type, s.segment18_type,

      s.segment19_type, s.segment20_type, s.segment21_type,

      s.segment22_type, s.segment23_type, s.segment24_type,

      s.segment25_type, s.segment26_type,s.segment27_type,

      s.segment28_type, s.segment29_type, s.segment30_type

      FROM gl_summary_templates s

      WHERE s.template_id = 1300

       

       

      << open_cursor() 23-NOV-2018 10:43:11

       

      >> load_segnum_vsid() 23-NOV-2018 10:43:11

       

      << load_segnum_vsid() 23-NOV-2018 10:43:11

       

      >> do_fetch_templates() 23-NOV-2018 10:43:11

      SHRD0108: Retrieved 1 records from GL_SUMMARY_TEMPLATES

      glsfti structure->template_name = XX Summary

      glsfti structure->out_template_id = 1300

      glsfti structure->template_max_ccid = -1

      glsfti structure->funds_check_level = N

      glsfti structure->acct_category = P

      glsfti structure->num_segs = 4

      glsfti structure->no_of_rollups = 2

      seg_info[0].seg_val = T

      seg_info[0].seg_num = 1

      seg_info[0].indexed = TRUE

      seg_info[1].seg_val = Department

      seg_info[1].seg_num = 2

      seg_info[1].indexed = TRUE

      seg_info[2].seg_val = Total Expenses

      seg_info[2].seg_num = 3

      seg_info[2].indexed = TRUE

      seg_info[3].seg_val = T

      seg_info[3].seg_num = 4

      seg_info[3].indexed = TRUE

       

      << do_fetch_templates() 23-NOV-2018 10:43:11

       

      >> close_cursor() 23-NOV-2018 10:43:11

       

      << close_cursor() 23-NOV-2018 10:43:11

       

      << glsfst() 23-NOV-2018 10:43:11

       

      >> glsltmp() 23-NOV-2018 10:43:11

       

      >> gludlk() 23-NOV-2018 10:43:11

       

      << gludlk() 23-NOV-2018 10:43:11

       

      << glsltmp() 23-NOV-2018 10:43:11

       

      >> glstexs() 23-NOV-2018 10:43:11

       

      << glstexs() 23-NOV-2018 10:43:11

       

      >> glsuab() 23-NOV-2018 10:43:11

       

      << glsuab() 23-NOV-2018 10:43:11

       

      >> glstadd() 23-NOV-2018 10:43:11

       

      >> glucmt() 23-NOV-2018 10:43:11

       

      << glucmt() 23-NOV-2018 10:43:11

       

      >> glstchk() 23-NOV-2018 10:43:11

      STPM0003: The template "T-Department-Total Expenses-T" has been validated. All rollup groups are defined.

       

      << glstchk() 23-NOV-2018 10:43:11

       

      >> glsdsh() 23-NOV-2018 10:43:11

      SHRD0119: Deleted 0 record(s) from GL_SUMMARY_HIERARCHIES.

      SHRD0119: Deleted 0 record(s) from GL_SUMMARY_HIERARCHY_INT.

       

      >> glucmt() 23-NOV-2018 10:43:11

       

      << glucmt() 23-NOV-2018 10:43:11

       

      << glsdsh() 23-NOV-2018 10:43:11

       

      >> glsdah() 23-NOV-2018 10:43:11

      SHRD0119: Deleted 0 record(s) from GL_CODE_COMBINATIONS.

       

      >> glucmt() 23-NOV-2018 10:43:11

       

      << glucmt() 23-NOV-2018 10:43:11

       

      << glsdah() 23-NOV-2018 10:43:11

       

      >> glsash() 23-NOV-2018 10:43:11

       

      Length of stmt=974

      Insert into GL_SUMMARY_HIERARCHIES

      (template_id, flex_value_set_id, segment_pos,

      parent_flex_value, child_flex_value_low,

      child_flex_value_high, status_code,

      creation_date, created_by, last_update_date,

      last_update_login, last_updated_by)

      Select :template_id,

        ffvh.flex_value_set_id,

        :seg_pos,

        ffvh.parent_flex_value,

        ffvh.child_flex_value_low,

        ffvh.child_flex_value_high,

        'I', sysdate, :user_id,

        sysdate, :login_id, :user_id

      From

        FND_FLEX_VALUE_HIERARCHIES ffvh,

        FND_FLEX_VALUES ffvs,

        FND_FLEX_HIERARCHIES_TL ffhs,

        FND_LANGUAGES fl

      Where ffhs.hierarchy_name = :hiername

      And ffhs.flex_value_set_id = :vsid

      And ffhs.language = fl.language_code

      And fl.installed_flag = 'B'

      And ffvs.summary_flag = 'Y'

      And ffvs.flex_value_set_id = :vsid

      And ffvs.structured_hierarchy_level =

        ffhs.hierarchy_id

      And ffvh.flex_value_set_id = :vsid

      And ffvh.parent_flex_value =

        ffvs.flex_value

      SHRD0117: Inserted 2 record(s) into GL_SUMMARY_HIERARCHIES

      SHRD0117: Inserted 1 record(s) into GL_SUMMARY_HIERARCHIES

       

      >> glucmt() 23-NOV-2018 10:43:11

       

      << glucmt() 23-NOV-2018 10:43:11

       

      << glsash() 23-NOV-2018 10:43:11

       

      >> glsmah() 23-NOV-2018 10:43:11

       

      >> gls_fill_seg_info() 23-NOV-2018 10:43:11

       

      << gls_fill_seg_info() 23-NOV-2018 10:43:11

       

      >> gls_get_max_ccid() 23-NOV-2018 10:43:11

       

      >> glucmt() 23-NOV-2018 10:43:11

       

      << glucmt() 23-NOV-2018 10:43:11

       

      << gls_get_max_ccid() 23-NOV-2018 10:43:11

       

      >> glstmt() 23-NOV-2018 10:43:11

       

      ccid_num = -1

      has_details = FALSE

       

       

      << glstmt() 23-NOV-2018 10:43:11

       

      >> gls_csa_rollup() 23-NOV-2018 10:43:11

       

      >> glsgsmi() 23-NOV-2018 10:43:11

      Optimizer mode is ALL_ROWS

       

      Optimizer mode is ALL_ROWS

       

      SHRD0043: ERROR: ORA-00942: table or view does not exist

        

       

      <x glsgsmi() 23-NOV-2018 10:43:11

       

      <x gls_csa_rollup() 23-NOV-2018 10:43:11

      SHRD0075: Error in gls_csa_rollup().

       

      <x glsmah() 23-NOV-2018 10:43:11

      SHRD0075: Error in glsmah().

       

      <x glstadd() 23-NOV-2018 10:43:11

      SHRD0075: Error in glstadd_addtmp().

       

       

      <x main() 23-NOV-2018 10:43:11

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

      Start of log messages from FND_FILE

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

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

      End of log messages from FND_FILE

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

       

       

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

      No completion options were requested.

       

      Output file size:

      0

       

       

      Output is not being printed because:

      The print option has been disabled for this report.

      SHRD0075: Error in glstadd_addtmp().

       

       

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

      Concurrent request completed

      Current system time is 23-NOV-2018 10:43:11

       

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