My Oracle Support Banner

EGL: GL_JP Process Fails With PS_SAMDIFF_ERROR At Step GL_JP_POST.Process.Step03 (Doc ID 3046675.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

GL_JP process is going to no success with below error:

-- 2024-07-26 04:07:28.947 .........(GL_JP_POST.Process.Step03) (SQL)
PS_SAMDIFF_ERROR('INSERTSELECT: Cannot locate record definition') FROM
PS_LEDGER_TMP_BUDG T WHERE PROCESS_INSTANCE = 2313010 GROUP BY
PROCESS_INSTANCE,BASE_CURRENCY, BUSINESS_UNIT, LEDGER, ACCOUNT, ALTACCT,
DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE,
BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1,
CHARTFIELD2, CHARTFIELD3, PROJECT_ID, BUDGET_PERIOD, SCENARIO, BOOK_CODE,
GL_ADJUST_TYPE, DATE_CODE, CURRENCY_CD, STATISTICS_CODE, FISCAL_YEAR,
ACCOUNTING_PERIOD
/
-- 2024-07-26 04:07:28.960 Process 2313010 ABENDED at Step GL_JP_POST.Process.Step03 (Action SQL) -- RC = 0
ROLLBACK
/

 

Steps:

1. Go to General Ledger > Journals > Process Journals > Post Journals > Post Journals Request 
2. Run the Journal Post process

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.