EAM: AMPS1000 Is Setting One INTFC_TYPE As FAD and the Other One As ADQ for Two Vouchers Created From the Same PO Receipt and AMIF1000 Sets the ADQ Row LOAD_STATUS to ERR: "Cannot process transactions to assets that are not recorded in AM (8005,176)" (Doc ID 2960747.1)

Last updated on JULY 17, 2023

Applies to:

Symptoms

The Retrieve Info from AP/PO process (AMPS1000) is setting one INTFC_TYPE as FAD(Financial & Physical Add) and the other one as ADQ(Adjust Cost/Acquisition Detail) for two Vouchers created from the same PO Receipt and the Transaction Loader Process (AMIF1000) sets the ADQ row LOAD_STATUS to ERR(Errored): "Cannot process transactions to assets that are not recorded in AM (8005,176)"

The following error is found on the Review Interface Transactions(Page) > Error(link):

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

1. Create an Amount Only PO
- Select Receiving Required
- Fill in the Asset Management Business Unit / Profile and make sure that Distribute By is set to Amount
- Save and Dispatch the PO
Navigation: Purchasing > Purchase Orders > Add/Update POs
2. Create a PO Receipt
- Uncheck the Interface Receipt checkbox and save.
Navigation: Purchasing > Receipts > Add/Update Receipts
3. Create a “PO Receipt” Voucher
- Select Copy from PO Receipt and click the Go button
- Copy the PO Receipt Line
- Update the Total, Unit Price, and Line Amount values and press the Calculate button
- Save, Select the Voucher Post option, and click Run
Navigation: Accounts Payable > Vouchers > Add/Update > Regular Entry
4. Create a second Voucher with the same Details/Amounts using the same exact steps
Navigation: Accounts Payable > Vouchers > Add/Update > Regular Entry
5. Run the Load Asset Request process (INTFAPAM) for the two vouchers
Navigation: Accounts> Payable > Batch Processes > Extracts and Loads > Load Assets Request
6. Run the Retrieve Info from AP/PO process (AMPS1000) for the two vouchers
Navigation: Asset Management > Send/Receive Information > Retrieve Info from AP/PO
7. Review the transaction
- Notice that the Trans Load Type is (ADQ) for one of the lines
Navigation: Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions
8. Run the Load into AM / Transaction Loader Process (AMIF1000)
Navigation: Asset Management > Send/Receive Information > Interface Transactions > Load into AM
9. Review the transaction
- Notice that the ADQ row LOAD_STATUS is set to Errored
Navigation: Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions

Detailed DEMO Replication Steps Attached

Cause

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