EAM: Close Depreciation (AM_DPCLOSE) Creates Lines With Different Date Time for Primary and Secondary Books -Brazilian Localization (Doc ID 2000154.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management Brazil - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Depreciation

ACTUAL BEHAVIOR
---------------
Close Depreciation process creates lines with different Date Time for Primary and Secondary Books.

EXPECTED BEHAVIOR
-----------------------
Since Journal Template separates Multibook by Date Time, Journal Generator process creates two lines for each line in DIST_LN. For users, it seems the journal has duplicate depreciation.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1- Set Up Financials/Supply Chain > Business Unit Related > Asset Management > Asset Management Definition
Setup Business Unit BGAM1, with one asset book in BRL creating journal lines to General Ledger primary book in the same currency.
Setup Business Unit BGAM1, with one asset book in USD creating journal lines to General Ledger secondary book in the same currency.

2- General Ledger > Ledgers > Ledger Groups
Setup Group Ledger “CONTABIL” with Primary ledger REAL in BRL and Secondary Ledger DOLAR in USD.

3- General Ledger > Journals > Subsystem Journals > Accounting Entry Definition
Setup AMDEFN Accounting Entry Definition with Date/Time Stamp as the third field used to order multibook journals.

4- Asset Management > Asset Transactions > Owned Assets > Express Add
Add and asset and associate it to both books.

5- Asset Management > Depreciation > Processing > Calculate
Calculate depreciation for new asset.

6- Asset Management > Accounting Entries > Create Accounting Entries
Create accounting entries for Asset addition.

7- Asset Management > Accounting Entries > Review Financial Entries
Check accounting lines for asset adition.
Date/Time for transaction ADD, ledger REAL
Equal Date/Time for transaction ADD, ledger DOLAR

8- Asset Management > Accounting Entries > Close Depreciation
Create accounting entries for Asset depreciation in September.

9- Asset Management > Accounting Entries > Review Financial Entries
Check accounting lines for asset depreciation in September.
Date/Time for transaction DEPR in September, ledger REAL
Different Date/Time for transaction DEPR in September, ledger DOLAR

10- General Ledger > Journals > Subsystem Journals > Generate Journals
Create journal entries for Asset addition and Asset depreciation

11- Asset Management > Accounting Entries > Review Financial Entries
Check journal ids.

12- Asset Management > Accounting Entries > Review Asset Journals
Check journal lines for asset addition.
Check journal lines for September depreciation.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms