EAR9.0+: PS_ITEM_DST.DST_SEQ_NUM Having Different Value for Primary and Secondary Ledger
(Doc ID 1089646.1)
Last updated on APRIL 09, 2023
Applies to:
PeopleSoft Enterprise FIN Receivables - Version 9 to 9.1 [Release 9]Information in this document applies to any platform.
Symptoms
On : 9 version, AR Update - Posting
For a payment with a realized gain/loss PS_ITEM_DST.DST_SEQ_NUM is having different value for Primary and Secondary ledger.
EXPECTED BEHAVIOR
-----------------------
PS_ITEM_DST.DST_SEQ_NUM should be the same for both Primary and Secondary ledger.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply payment to item and make sure the currency rate is changed between item and payment.
2. Run ARUPDATE.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, FS_JGEN creates extra lines in PS_JRNL_LN for gain/loss entries with both MONETARY_AMOUNT and FOREIGN_AMOUNT 0 and PS_JRNL_LN.RATE_MULT is also zero.
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 |