My Oracle Support Banner

仕訳のロールバックを仕訳の作成対して異なるNLS言語で実行するとGL_INTERFACEが削除されない (Doc ID 2428766.1)

Last updated on AUGUST 25, 2020

適用範囲:

Oracle Assets - バージョン 11.5.10.2 から 11.5.10.2 [リリース 11.5]
この文書の内容はすべてのプラットフォームに適用されます。

現象

仕訳のロールバックを仕訳の作成対して異なるNLS言語で実行するとGL_INTERFACEが削除されない事象が発生します。
例:

  1. 仕訳の作成を日本語で実行します。
    パラメータ:
      仕訳インポートの実行 : No

  2. 仕訳のロールバックを英語で実行します。
    資産データはロールバックされますが、GL_INTERFACEは削除されません。
     
    NOTE:
      このようなGL_INTERFACEは、以下のエラーが発生し、仕訳インポートでGLへインポートできません、このようなGL_INTERFACEは、FAのデータに関して関連を持っていないためエラーが発生します。

    Log of Journal Import:

    Error in: gllcfa
    Function return status: 0
    Function Err Message: sqlerror trapped at sqlerr
    Function warning number: -1
    *****************************************************
    sqlcaid:   sqlabc: 0  sqlcode:  -20000  sqlerrml: 70
    sqlerrmc:
    ORA-20000: fa_journals_pkg.update_gl_info failed
    ORA-06512: at "APPS.F
    sqlerrp:   sqlerrd: 0 0 0 0 0 538976343
    sqlwarn: W     W   sqltext:  
    *****************************************************SHRD0044: Process logging off database and exiting ...
    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    Starting fa_journals_pkg.update_gl_info at: 28/06/2018 13:57:55
    ORA-06550: line 18, column 17:
    PL/SQL: ORA-00942: table or view does not exist
    ORA-06550: line 12, column 10:
    PL/SQL: SQL Statement ignored
    ORA-06550: line 48, column 20:
    PL/SQL: ORA-00942: table or view does not exist
    ORA-06550: line 48, column 13:
    PL/SQL: SQL Statement ignored
    Error: function fa_journals_pkg.summary_update returned failure
    Error: function fa_journals_pkg.update_gl_info returned failure
    Failed in fa_journals_pkg.update_gl_info at: 28/06/2018 13:57:55
    Getting Debug information
    fa_journals_pkg.update_gl_info: -------------------------------------------------------------------------------- has the value of
    fa_journals_pkg.update_gl_info: X_book_type_code has the value of TEST_BOOK
    fa_journals_pkg.update_gl_info: X_period_counter has the value of 24170
    fa_journals_pkg.update_gl_info: X_cje_id has the value of 9016
    fa_journals_pkg.update_gl_info: X_je_batch_id has the value of 62505
    fa_journals_pkg.update_gl_info: X_je_header_id has the value of 55891
    fa_journals_pkg.update_gl_info: X_group_id has the value of 529
    fa_journals_pkg.update_gl_info: X_set_of_books_id has the value of 7003
    fa_journals_pkg.update_gl_info: X_je_category has the value of Depreciation
    fa_journals_pkg.update_gl_info: X_batch_type has the value of DEPRECIATION ****
    fa_journals_pkg.update_gl_info: fetching has the value of info from fa_journal_entries
    fa_journals_pkg.update_gl_info: updating fa_journal_entries  has the value of setting source type and cjeid
    fa_journals_pkg.update_gl_info: l_je_info_rec.posting_level has the value of D ****
    fa_journals_pkg.check_setups: preparing has the value of bonus check statement
    fa_journals_pkg.check_setups: executing has the value of bonus check statement
    fa_journals_pkg.check_setups: preparing has the value of group check statement
    fa_journals_pkg.check_setups: executing has the value of group check statement
    fa_journals_pkg.check_setups: X_je_info_rec.bonus_used has the value of TRUE
    fa_journals_pkg.check_setups: X_je_info_rec.reval_used has the value of TRUE
    fa_journals_pkg.check_setups: X_je_info_rec.group_used has the value of FALSE
    fa_journals_pkg.check_setups: X_je_info_rec.batch_size has the value of 1000
    fa_journals_pkg.check_setups: X_je_info_rec.posting_level has the value of S
    fa_journals_pkg.update_gl_info: mrc_sob_type_code has the value of P
    fa_journals_pkg.summary_update: Start Time for summary update has the value of 28/06/2018 13:57:55
    fa_journals_pkg.summary_update: preparing has the value of statement for deprn temp table tie back
    fa_journals_pkg.summary_update: executing has the value of statment for deprn temp table tie back

変更点

 

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


本書の内容
現象
変更点
原因
解決策
参照情報

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.