My Oracle Support Banner

EPC 9.2: Asset Is Not Created Correctly When Transactions From Two Projects Are Send to Asset Management (Doc ID 2759457.1)

Last updated on FEBRUARY 21, 2023

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The asset is not created correctly when transactions from two projects are sent to Asset Management

When an asset is defined in project costing and transactions from two different projects are assigned to that asset, the PC_AM process does not create the asset correctly in Asset Management. Only the transaction of one project is loaded successfully, the other is flagged as an error (load status= ERR) in the INTFC_FIN and INTFC_PHY_A tables.

ERROR
-----------------------
"Cannot process adjustment transactions to assets that are not recorded in AM. This may be caused because the transaction for creating this asset has errored out. Transactions for this asset can be processed only if the asset is recorded in PS_ASSET table. The ADD row can be in the current run of AMIF1000 provided the ADD row does not error out."



REPLICATION STEPS
--------------------------
1. Define asset in project costing.
2. Fill the lines with 2 'ABC' and 'XYZ'projects.
3. Assign transactions to asset and run PC_AM.
4. Search for the 2nd project (see step 2) which is “XYZ” project , add a transaction.
5. Run PC_AM.
6. Project costing>assets>review assets, only project 1 'ABC' is present.
7. Project XYZ has load_status ERR in INTFC_FIN table.

Detailed test document: Replication


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.