My Oracle Support Banner

EGL: When Adjustment Journal To Only Commitment Control Ledger Group & Ledger, Journal Post Abends at GL_JP_POST.INS2_REG.INSAMT1 (Doc ID 2083931.1)

Last updated on APRIL 04, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** checked for relevance 08-FEB-2019 ***

Symptoms

When entering an adjustment journal to KK ledger group and ledger on the Journal Header page, with both commitment control and document sequencing on, journal post abends at GL_JP_POST.Ins2_REG.InsAmt1

Replication:

The issue can be reproduced at will with the following steps:
1. Turn on Commitment Control and Document Sequence at the Installation Options.
2. Create Commitment Control adjustment journal by enter KK ledger group and ledger in on the Journal Header page.
3. Enter one line journal enter account and amount.
4. Enter doc seq type and run edit process.
5. Run batch post process specifying Commitment Control Ledger group in Post request page.

Failed SQL stmt: INSERT INTO PS_BP_PST2_TAO (PROCESS_INSTANCE, BUSINESS_UNIT, LEDGER, ACCOUNT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, BUDGET_PERIOD, CURRENCY_CD, STATISTICS_CODE, FISCAL_YEAR, ACCOUNTING_PERIOD, KK_BUDG_TRANS_TYPE, POSTED_TOTAL_AMT, POSTED_BASE_AMT, POSTED_TRAN_AMT, BASE_CURRENCY, DTTM_STAMP_SEC) SELECT 410033, L.BUSINESS_UNIT, L.LEDGER, L.ACCOUNT, L.DEPTID, L.OPERATING_UNIT, L.PRODUCT, L.FUND_CODE, L.CLASS_FLD, L.PROGRAM_CODE, L.BUDGET_REF, L.AFFILIATE, L.AFFILIATE_INTRA1, L.AFFILIATE_INTRA2, L.CHARTFIELD1, L.CHARTFIELD2, L.CHARTFIELD3, L.BUSINESS_UNIT_PC, L.PROJECT_ID, L.ACTIVITY_ID, L.RESOURCE_TYPE, L.BUDGET_PERIOD, L.CURRENCY_CD, ' ', H.FISCAL_YEAR, H.ACCOUNTING_PERIOD, ' ', SUM(L.MONETARY_AMOUNT), 0, 0, L.CURRENCY_CD, CAST(SYSTIMESTAMP AS TIMESTAMP) FROM PS_JRNL_LN L, PS_JRNL_HDR_TMP H WHERE H.PROCESS_INSTANCE=:1 AND L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.JOURNAL_ID = H.JOURNAL_ID AND L.JOURNAL_DATE=H.JOURNAL_DATE AND L.UNPOST_SEQ = H.UNPOST_SEQ AND L.FOREIGN_CURRENCY <> L.CURRENCY_CD AND L.JRNL_LINE_STATUS = '0' GROUP BY H.FISCAL_YEAR2, H.ACCOUNTING_PERIOD2, L.OPERATING_UNIT, L.PRODUCT, L.FUND_CODE, L.CLASS_FLD, L.PROGRAM_CODE, L.BUDGET_REF, L.AFFILIATE, L.AFFILIATE_INTRA1, L.AFFILIATE_INTRA2, L.CHARTFIELD1, L.CHARTFIELD2, L.CHARTFIELD3, L.CURRENCY_CD, H.PROCESS_INSTANCE, L.BUSINESS_UNIT , L.LEDGER, L.ACCOUNT, L.ALTACCT, L.DEPTID, L.PROJECT_ID, L.BUDGET_PERIOD, L.SCENARIO, L.BOOK_CODE, L.GL_ADJUST_TYPE, H.FISCAL_YEAR, H.ACCOUNTING_PERIOD, L.FOREIGN_CURRENCY, L.DATE_CODE, L.SETTLEMENT_DT

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References


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