EAM: Negative Values Are In Both LTAX_INFO1 And LTAX_INFO2 After Transferring Assets (Doc ID 1583469.1)

Last updated on SEPTEMBER 18, 2013

Applies to:

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

Symptoms

Negative values are in both LTAX_INFO1_TBL and LTAX_INFO2_TBL tables.
These tables are used for the Japanese Local Tax report feature.

This issue may occur under the following conditions:

1. Both ADD and TRF (IN/OUT) records are in PS_COST for each asset and book.
   If an asset is transferred, both TRF-OUT (with negative values) and TRF-IN (with positive values) are created.

2. Within those records, this issue occurs when the TRF-OUT record is the first row of both one asset and one book.

3. When updating Local Tax Information through Basic Add.
   The situation of updating Local Tax Information is changing Local Tax Office.
   When updating Local Tax Information, the latest information was updated to both LTAX_INFO1_TBL and LTAX_INFO2_TBL.

According to the customer's research, when updating Local Tax Information, the PeopleCode "LTAX_INFO_WRK1.FUNCLIB_01.FieldFormula" will run.
However, as this PeopleCode does not specify the sort order in SELECT statement, records are extracted from PS_COST randomly
(it seems program refers only the first row of PS_COST), so that negative values are set to both LTAX_INFO1_TBL and LTAX_INFO2_TBL.
In other words, no considerations for the sort order when extracting records from PS_COST.

In addition, this issue may not occur when the order of rows in PS_COST are as follows:
  1. ADD     (this record has positive value)
  2. TRF-OUT (this record has negative value)
  3. TRF-IN  (this record has positive value)

If using PeopleSoft AM with the delivered features (ex. 1. Add Assets -> 2. Transferring Assets),
the order of rows should be as described above and this issue will not be replicated.

However, the order of rows may be changed if customers insert records into PS_COST by other ways than manual entry with the delivered features.
(ex. the purpose of conversion or data migration etc.)

Error:
-----------
No errors

Steps:
--------
1. Prepare records in the PS_COST table as follows:
  1. TRF-OUT (this record has negative value)
  2. ADD     (this record has positive value)
  3. TRF-IN  (this record has positive value)
  * The first of records per 1 asset/1 book is the Transfer-Out which has negative values (QUANTITY, TXN_COST, COST, SALVAGE_VALUE)

2. Updating Japanese local tax information from Basic Add.

3. Verifying both PS_LTAX_INFO1_TBL and PS_LTAX_INFO2_TBL, both QUANTITY and COST have negative values.

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