My Oracle Support Banner

EGL: 9.1 Bundle18以降の環境で転記取消を含んだ仕訳転記を実行するとステップ「GLPPRVRS XA100 CHKDUP1 SELECT」でエラーとなる (Doc ID 1558619.1)

Last updated on DECEMBER 27, 2017

適用範囲:

PeopleSoft Enterprise FIN General Ledger - バージョン 9.1 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

FMS Financials 9.1 Bundle#18以降の環境で、オンライン(GLPPPOST0)およびバッチ (GLPPPOST) の
仕訳転記を転記取消を含めて実行した時、下記のエラーとなる。

エラー内容
-----------------------
ログファイル"CBL_GLPPPST0_XXXXXX.log"におけるエラー:


Application Program Failed
Action Type     : SQL SELECT                    
In Pgm Section  : SQLRT: EXECUTE-STMT                                                                                                                                        
With Return Code: 08006
Error Message   : Invalid datatype specified
Stored Stmt     : GLPPRVRS_S_CHKDUP1
SQL Statement   : SELECT A.BUSINESS_UNIT ,A.JOURNAL_ID ,A.REVERSAL_DATE FROM P                                                                                                                        
                  S_JRNL_HEADER A WHERE A.PROCESS_INSTANCE = :1 AND A.REVERSAL                                                                                                                        
                  _CD IN ('B','D','E','U','X') AND A.JRNL_HDR_STATUS = 'I' AND                                                                                                                        
                   A.UNPOST_SEQ=0 AND A.BUSINESS_UNIT = :2 AND EXISTS ( SELECT                                                                                                                        
                   'X' FROM PS_JRNL_HEADER WHERE JOURNAL_ID=A.JOURNAL_ID AND J                                                                                                                        
                  OURNAL_DATE=A.REVERSAL_DATE AND BUSINESS_UNIT=A.BUSINESS_UNI                                                                                                                        
                  T AND UNPOST_SEQ=A.UNPOST_SEQ )

                                      at pos 00028
                                      at pos 00028
                                      at pos 00028
                                      at pos 00028
                                      at pos 00028

SEVERE ERROR IN PGM:(5830,7) PI(1123823) Program(GLPPRVRS)                                                                                                                                                                                                                    
PSPSQLRT error in Posting: GLPPRVRS XA100 CHKDUP1 SELECT.                      


環境
----------------------------
FMS 9.1 Feature Pack 2 および Bundle#19


再現手順
-----------------------
1. 転記取消が含まれた仕訳を転記処理する。
2. 上記エラーが発生する。

変更点

 9.1 Bundle#18を含んだメンテナンスパックおよびバンドルパッチを適用する。

原因

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.