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 FEBRUARY 03, 2019

Applies to:

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


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.

INSERTSELECT: Cannot locate record definition (-1,-1)

Process 17373857 ABENDED at Step AMR_JDATE.OPEN_C10.INSALL (SQL) -- RC = ? (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


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.


Actual Behavior:
When running Generate Amortization Journal (AMR_JRNL_GEN), the error "INSERTSELECT: Cannot locate record definition" occurred.


Expected Behavior:
Even if running Generate Amortization Journal (AMR_JRNL_GEN), no errors will occur.


Please also see replication step.




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

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