My Oracle Support Banner

EAM: Assets Split by Category Create Duplicate Capitalizations When Fed from AP Voucher. (Doc ID 2972477.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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

Symptoms

Issue:

Assets split by Category create duplicate capitalizations when fed from AP Voucher.
To recreate this issue, the test requires an Asset with two different ChartField Sequence Numbers where the Categories are different, but all other ChartField values are identical.

Steps to replicate:

  1.  Add an asset. (Asset Management > Asset Transactions > Basic Add)
  2.  Capitalize the asset. Note the Category used for the Profile.
  3.  Save the asset.
  4.  Run Depr Calc. It may not be strictly required. (Asset Management > Depreciation > Processing > Calculate Depreciation)
  5.  Partially recategorize to a different Category - Action = Recategorize (Asset Management > Asset Transactions > Financial Transactions > Asset Cost Adjust/Transfers)
       Input a portion of the asset’s value, select a different Category - originally, Category A (i.e FF), partially recategorize to Category B (i.e. BLDG), and save.
  6.  Run Depr Calc. It may not be strictly required. (Asset Management > Depreciation > Processing > Calculate Depreciation)
  7.  Create a credit or debit voucher in AP and route it to Business Unit, Asset ID as an additional acquisition. (Accounts Payable > Vouchers > Regular Entry
  8.  Post Voucher - AP_PSTVCHR (Accounts Payable > Batch Processes > Vouchers > Voucher Posting
  9.  Load Assets Request - INTFAPAM (Accounts Payable > Batch Processes > Extracts and Loads > Load Assets Request)
10.  Run SQL :
          SELECT A.PRE_INTFC_ID, A.PRE_INTFC_LINE_NUM, A.BUSINESS_UNIT_AP, A.VOUCHER_ID, A.VOUCHER_LINE_NUM, A.DISTRIB_LINE_NUM, A.COST, A.SYSTEM_SOURCE, A.INTFC_ID, A.INTFC_LINE_NUM
            FROM PS_INTFC_PRE_AM A
            WHERE ( A.BUSINESS_UNIT_AM = <Business Unit>
            AND A.ASSET_ID = <Asset ID>)
       Note:  One row of data created.
11.  Retrieve Info from AP/PO - AMPS1000 (Asset Management > Send/Receive Information > Retrieve Info from AP/PO)
12.  Run SQL:
          SELECT A.INTFC_ID, A.INTFC_LINE_NUM, A.BUSINESS_UNIT, A.ASSET_ID, A.BOOK, TO_CHAR(CAST((A.DTTM_STAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), A.CATEGORY, A.CF_SEQNO, A.QUANTITY, A.COST, A.CURRENCY_CD
            FROM PS_INTFC_FIN A
            WHERE ( A.INTFC_ID = <Interface ID>)
            ORDER BY 8
       AMPS1000 created duplicate rows.

13.  Load into AM: (Asset Management > Send/Receive Information > Interface Transactions > Load into AM)
14.  Reviewing COST table on Cost History page, we see the same voucher amount posed to ChartField Sequence 0 and 1. (Asset Management > Asset Transactions > History > Asset Cost History)

See replication document here.

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.