My Oracle Support Banner

EAM: Multi-funded Asset Where Funding Line Adjusted To Zero Is Not Being Retired In PS_COST (Doc ID 2526094.1)

Last updated on JULY 22, 2020

Applies to:

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

Symptoms

When adjusting the cost and quantity to zero on one funding line of a multi-funded asset and then retiring the asset, the system will only create RET transactions in PS_COST for the funding lines that have a cost and/or quantity that is greater than zero. It will not create RET transactions for the funding line that was adjusted to a cost and quantity of zero. This leaves a row in the PS_COST table that is not retired. Further, an issue is created when using PS_COST_BAL_VW as the ASSET_STATUS is disposed but there are still rows showing for the asset in this table view.  


It is expected that a cost row that has been adjusted to a quantity and cost of zero will be retired when the asset is retired.


This issue can be replicated via the following steps:

1) Create an Asset on Basic ADD with 2 lines for different CF_SEQNOs (i.e. different chart field sets).
2) Adjust cost and quantity to zero for one CF_SEQNO with a convention of life to date on the Cost Adjust/Transfer Asset page.
3) Retire the asset.
4) Verify that the asset is retired but that the cost row for which the cost and quantity was adjusted to zero does not have the retire_sw set to '1'. It is still active.
5) Verify that the asset row for which the cost and quantity was adjusted to zero remains on the ps_cost_bal_vw as an active row.  



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.