My Oracle Support Banner

ERE : Rem Transaction Creates Multiple AP Rows On Property Assets (Doc ID 2495317.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, 2.4 Lease Maintenance

There is an issue with leases that have more than one property attached to it. Again, this issue has to do with the number of properties attached to a lease, the dollar of the transaction and a new rounding field that has been added to the RE_LS_PPTY table. When there are multiple properties on a lease, the Interface to AP from REM now creates a separate row for each asset line. The program takes the amount of the payment (e.g. 100.55) and divides it by the # of properties (e.g. 3) and creates three DIST rows in AP 100.55 /3 - 33.5166 which rounds to 33.52 and therefore puts the voucher out of balance and into recycle mode. This is where the new rounding field comes into play. When the lease is activated there is new logic that sets the rounding flag to Y on the last asset row so in this case you would see 33.52, 33.52 and 33.51 as the amounts in AP.
This issue happens with any REM transaction going to AP

1 IFRS16 Unchecked
2 Create 3 assets with property not capitalized
3 Create Operation payable lease with the 3 property assets previously crated before activate it, Launch transaction generator, Check for pending rows and approve them, Launch Interface AP/Billing, Launch Voucher build
4 Voucher is created and here should be just 1 line with amount 100.55 as there is just one account distribution on the lease as next screen. If would have been 3 accounts on lease distribution would have been ok to get 3 lines on the voucher. On another side we have 33.52*3 = 100.56 and not 100.55 as we have on lease. Customer says there could be a rounding flag .


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.