EAM 9.2: The COST_TYPE Field Value Is Blank and Is Not Retained in PS_COST Table for 'Transferred In' Asset Costs Created via Upload Spreadsheet Functionality (Doc ID 2953086.1)

Last updated on JUNE 20, 2024

Applies to:

Symptoms

The COST_TYPE field value is lost for the transfer in cost rows when the asset is transferred via the Upload spreadsheet. The original cost type value does not flow to the asset interface (PS_INTFC_FIN) or cost (PS_COST) when the asset is transferred using the Upload Spreadsheet Data functionality.

Replication Steps:

1. Add a Transfer Assets spreadsheet template. Set Up Financials/Supply Chain > Product Related > Asset Management > Import Spreadsheet Setup > Define AM Spreadsheet Template.
2. Download the template.
3. Provide the details. Looks like the customer is populating the PC BU, PROJECT_ID, and ACTIVITY_ID on the asset. Basically transferring the asset costs without these chart fields populated to with chart fields populated.
4. Upload the Spreadsheet template. Asset Management > Send/Receive Information > Import Data via Spreadsheet > Upload Spreadsheet Data.
5. Run the AM_LOAD process (Asset Management >Send/Receive Information >Import Data via Spreadsheet >Upload Spreadsheet Data >Upload Spreadsheet Data)
6. Interface ID XXXXXXXXX was created successfully with the new activity, but the PS_INTFC_FIN cost type is blank for the transferred asset instead of its original value (of O). This is a problem to be a problem. 
7. Run AM transaction loader process (AMIF1000). Asset Management > Send/Receive Information> Interface Transactions > Load into AM.
8. Cost rows were created in the PS_COST table but the cost type field value is blank instead of its original value (of O) for the transferred asset. This is a problem. Also, the PC BU and Activity id values are blank. This is also a problem. 

Replication Screenshots

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.