EGL: Can Save Commitment Control Ledger Group on Post Request Page and Post Abend at GL_JP_POST.Ins2_REG.InsAmt1. (Doc ID 2083931.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Financial 9.2 Journal Post

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

Cause

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 hundreds of Community platforms