EGL9.2: Journal Generator is not Populating Rate Type for Student Financials Journals When How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.
(Doc ID 1927575.1)
Last updated on NOVEMBER 23, 2020
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
On : 9.2 version, Journal Generator
ACTUAL BEHAVIOR
---------------
Rate Type is missing in journals generated from Student Financials through Journal Generator when How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.
Rate Type field is populated in PS_SF_ACCTG_LN but not loaded to journal by Journal Generator.
EXPECTED BEHAVIOR
-----------------------
Rate Type should be populated in journals generated from Student Financials through Journal Generator when How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.
WHAT IS WORKING?
-----------------------
Rate Type is populated in journals generated from Student Financials through Journal Generator when How Specified Option = ‘Retain Detail’ for Journal Generator Template SF/GL.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Test 1: How Specified Option = 'Summarize to All Chartfields' for Journal Generator Template SF/GL.
- In Student Financials the business unit base currency is USD and in General Ledger the business unit base currency is PKR.
- In Student Financials create some transactions and generate accounting entries (transaction currency and base currency are both USD).
- Move Student Financials accounting entries to general Ledger (PS_SF_ACCTG_LN is populated). Record PS_SF_ACCTG_LN contains transactions where transaction currency and base currency is USD. (MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = CRRNT, RATE_DIV = 1 and RATE_MULT = 1)
- Navigate to General Ledger > Journals > Subsystem Journals > Generate Journals and run Journal Generator to create a journal.
- Review PS_JRNL_LN. At this moment MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = blank, RATE_DIV = 1 and RATE_MULT = 1. Please note RT_TYPE is blank, this is the source of the problem!
- Navigate to General Ledger > Journals > Process Journals > Edit Journals. Make sure to check ‘Recalc Exchange Rates’ and run the batch journal edit process.
- Review PS_JRNL_LN, only CURRENCY_CD is changed from USD to PKR. However, the MONETARY_AMOUNT and RATE_MULT are not changed. This is wrong because the RATE_MULT should be updated with rate from market rates table and the MONETARY_AMOUNT should be recalculated.
Test 2: How Specified Option = ‘Retain Detail’ for Journal Generator Template SF/GL.
- In Student Financials the business unit base currency is USD and in General Ledger the business unit base currency is PKR.
- In Student Financials create some transactions and generate accounting entries (transaction currency and base currency are both USD).
- Move Student Financials accounting entries to General Ledger (PS_SF_ACCTG_LN is populated). Record PS_SF_ACCTG_LN contains transactions where transaction currency and base currency is USD. (MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = CRRNT, RATE_DIV = 1 and RATE_MULT = 1)
- Navigate to General Ledger > Journals > Subsystem Journals > Generate Journals and run Journal Generator to create a journal.
- Review PS_JRNL_LN. At this moment MONETARY_AMOUNT = 2500, CURRENCY_CD = USD, FOREIGN_AMOUNT = 2500, FOREIGN_CURRENCY = USD, RT_TYPE = CRRNT, RATE_DIV = 1 and RATE_MULT = 1. Please note this time RT_TYPE is populated, like it should be.
- Navigate to General Ledger > Journals > Process Journals > Edit Journals. Make sure to check ‘Recalc Exchange Rates’ and run the batch journal edit process.
- Review PS_JRNL_LN, field CURRENCY_CD is changed from USD to PKR, RATE_MULT is updated with rate from market rates table and MONETARY_AMOUNT is recalculated. Results are correct.
Test 3: First How Specified Option = 'Summarize to All Chartfields' and after 1st run change How Specified Option = ‘Retain Detail’ for for Journal Generator Template SF/GL.
1. Run the steps from Test 1 with How Specified Option = 'Summarize to All Chartfields' and after noticing the issue that the RT_TYPE is blank,
2. Change the Journal Generator Template SF/GL with How Specified Option = ‘Retain Detail’
3. Navigate to General Ledger > Journals > Process Journals > Edit Journals. Make sure to check ‘Recalc Exchange Rates’ and run the batch journal edit process.
4. When reviewing the results, process goes to No success with user is receiving a message error:
"RT_TYPE Rate Type 104 9 TSE Prompt table edit; value not found in prompt table"
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 |