Disposed Cost Non Cap Asset Still Showing In NON_CAP_VW (Doc ID 1621866.1)

Last updated on APRIL 11, 2016

Applies to:

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

Symptoms

Even after a non cap asset is disposed, the disposed asset is still appearing on NON_CAP_VW. As a result the disposed asset is being included in any process that uses this view.

Expectation:
The retired non capitalize asset should not be included in NON_CAP_VW.
A row with retire_sw = 1 should have been inserted into COST_NON_CAP when a non-financial asset is retired. If this happened, the NON_CAP_VW would sum retire_sw and not include retired assets.

Replication steps:
1. Find a Non-Cap Asset – Before Retirement sum of retire_sw = 0
2. Retire Non-Fin Asset - after retirement, sum of Retire SW has not changed, nor is a new row added
3. Looking into SQL of NON_CAP_VW it looks for sum(retire_sw) = 0

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