My Oracle Support Banner

EAM: The Transaction Loader AMIF1000 Doesn’t Take Into Consideration the Defined Business Unit Book Round Type (Doc ID 2882729.1)

Last updated on JULY 14, 2022

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The Transaction Loader AMIF1000 doesn't take into consideration the defined Business Unit Book round type.
Asset Management Adjustment Journal lines that were processed using Mass Transaction have 3 decimals for the PS_JRNL_LN.MONETARY_AMOUNT while the Currency is set up to have only 2 Decimals.


The issue can be reproduced at will with the following steps:

Current Setup: USD uses Two Decimals
Navigation: Set Up Financials/Supply Chain > Business Unit Related > Asset Management > Asset Management Definition | Business Unit/Book Definition > Round Type
Navigation: Set Up Financials/Supply Chain > Common Definitions > Currency > Set up Currency Code

Replication:
1. Create a New Asset:
Navigation: Asset Management > Asset Transactions > Owned Assets > Basic Add
2. Calculate the Depreciation:
Navigation: Asset Management > Depreciation > Processing > Calculate Depreciation
3. Use the delivered MTM: “ADJ - Asset Cost Adjustment2” to Adjust the Cost
Navigation: Asset Management > Asset Transactions > Mass Transactions > Run Mass Transactions
4. Enter a three decimal amount in the “Cost Adjustment” field and run the process
The Adjustment Cost looks fine on the Review Interface Transactions page, however, the PS_INTFC_FIN.COST has three decimals
Navigation: Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions5. Interface the Adjustment Transaction:
Navigation: Asset Management > Send/Receive Information > Interface Transactions > Load into AM
6. Notice that AMIF1000 carries all three decimals to PS_COST instead of two as per system setup.

Detailed DEMO Replication Steps Attached

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
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.