EAM: AMIF1000 FAILS TO RESET INVALID_DIST_TMPL TO N WHEN INVALID DISTR TEMPLATE (Doc ID 2226644.1)

Last updated on JANUARY 25, 2017

Applies to:

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

Symptoms

On : 9.1, Interface

ACTUAL BEHAVIOR
---------------

Transaction Loader AMIF1000 missed loading of OPEN_TRANS,BOOK,BOOK_HIST and COST because of AMIF_FINPHY_AET.INVALID_DIST_TMPL Flag not getting reset to 'N'.

Scenario
========
1. Transaction Loader Run control has multiple Request Ids
2. One of the Request Ids (say 'X' which is not the last row) has only One Interface Record to process. This Interface record has Trans code that doesn't have any valid distribution template.
3. There are subsequent Request Ids with Interface Records having potential to become financial Assets.

Reason
=======
AMIF_FINPHY_AET.INVALID_DIST_TMPL is not reset to "N" while processing point 3 above after it was set to "Y" for point 2 above.

EXPECTED BEHAVIOR
-----------------------
AMIF_FINPHY_AET.INVALID_DIST_TMPL should reset to "N" while processing point 3 above after it was set to "Y" for point 2 above.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Step 1: Add a voucher and process load asset and AMPS1000. Goto Review information and update the trans code to existing trans code.
Step 2 : Add a voucher and process load asset and AMPS1000. Goto Review information and update the trans code to non existing trans code.
Step 3 : Add a voucher and process load asset and AMPS1000. Goto Review information and update the trans code to existing trans code.(same as step1).
Step 4 : Run AMIF1000 with different interface id¿s in different request id's and run at a time.
Step 5 : AMIF1000 went to success with interface 1 and 3 ad loaded and 2 as error.
Step 6 : check the cost information for asset created from step 1 and 3.

Asset created in step 1 is having total cost information, whereas asset created from step 3 (ie row processed after error ) is not having any data in cost table.

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