EAM: Asset Custodian Project Incorrectly Updated By Transaction Loader (Doc ID 2090932.1)

Last updated on OCTOBER 10, 2016

Applies to:

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

Symptoms

When the customer uses the delivered Excel to CI template INTFC_FINPHY_SS_A and enters 1 set of chartfield values for project id and deptid for the Asset, and another set of chartfield values for project id and deptid for the Asset Custodian, only the correct Deptid value for the Asset Custodian is uploaded to the PS_Asset_Custodian table. The project id value for the Asset is uploaded to the PS_Asset_Custodian table rather then the value that is entered for the Asset Custodian.  

Expected Behavior
-----------------------
The expectation is that the project id entered onto the ExcelToCI for the Asset Custodian will be uploaded to the PS_Asset_Custodian table.

Steps
----------
This issue can be replicated by performing the following steps:

1) Enter the the 2 sets of project id and deptid chartfield values for the Asset and the Asset Custodian along with all other required fields for asset creation onto the Excel to CI template INTFC_FINPHY_SS_A.
2) Upload the ExcelToCI data into the Interface Tables via the template.
3) Upload the Interface data into the AM Tables via AMIF1000.
4) Verify the project id and deptid chartfield values for the Asset and the Asset Custodian on the Basic Add component.

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