My Oracle Support Banner

EGL9.2: Generate Amortization Journal (AMR_JRNL_GEN) Process Fails At Step AMR_JDATE.OPEN_C10.INSALL With "INSERTSELECT: Cannot locate record definition (-1,-1)" Error (Doc ID 2425312.1)

Last updated on MAY 10, 2019

Applies to:

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

Symptoms

Issue:
-------
When running Generate Amortization Journal (AMR_JRNL_GEN), below error occurred.
This issue occur when selecting "By Ledger Code" for Update Open Periods in Ledgers For A Unit.

Error:
------

In AET trace file:


-- 12:06:48.463 ............(AMR_JDATE.OPEN_C10.INSALL) (SQL)
PS_SAMDIFF_ERROR('INSERTSELECT: Cannot locate record definition') FROM
PS_AMR_JRNL_LN_STG L, PS_AMR_JRNLHDR_STG H WHERE H.PROCESS_INSTANCE=:1 AND
H.JOURNAL_ID=:2 AND H.BUSINESS_UNIT=:3 AND H.LEDGER_GROUP=:4 AND
(H.JOURNAL_DATE < TO_DATE(:5,'YYYY-MM-DD') OR H.JOURNAL_DATE >
TO_DATE(:6,'YYYY-MM-DD')) AND H.ADJUSTING_ENTRY<>'Y' AND H.GL_ADJUST_TYPE=' '
AND H.BUSINESS_UNIT=L.BUSINESS_UNIT AND H.JOURNAL_ID=L.JOURNAL_ID AND
H.JOURNAL_DATE=L.JOURNAL_DATE AND H.UNPOST_SEQ=L.UNPOST_SEQ
/
-- 12:06:48.531 Process 17373880 ABENDED at Step AMR_JDATE.OPEN_C10.INSALL (Action SQL) -- RC = ?
ROLLBACK


 

Steps to Replicate:
---------------------
1. Select “By Ledger Code” for Update Open Periods in Ledger For A Unit.
2. Verify open periods has been configured.
3. Create an amortization voucher on Regular Voucher.
4. Post the amortization voucher using voucher posting batch process.
5. Use the Amortization Schedule page to validate the values passed from the amortization voucher, create stage journals, review and approve the schedule.
6. Click on Stage button.
7. The details are listed in the group box. Click the Approve button
8. The Scheduled status becomes ready.
9. Use the Generate Amortization Journal Request page to run the Amortization Journal Creation process for a given amortization ID or for a range of amortization IDs.

 

Please also see replication step.

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.