Transaction Stuck At PA_TRANSACTION_INTERFACE_ALL Table With Error INVALID_ETYPE_SYSLINK (Doc ID 1580348.1)

Last updated on APRIL 03, 2025

Applies to:

Goal

To resolve issues where transactions are stuck in the pa_transaction_interface_all table with the error - INVALID_ETYPE_SYSLINK. The reason is that the expenditure type is not tied to the Work in Process expenditure type class. However the user does NOT want to tie it to this class.
This raised two questions:

1) How can user fix these so that they will import, without having to add Work in Process to the expenditure type?
2) Need clarification on what causes an account alias issue to projects, in inventory, to have a WIP accounting class code? Is it because the item being issued to the project, is a "make item"? in order to prevent this from happening in the future, the cause needs to be defined.
 

Solution

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