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 JUNE 14, 2023
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 |