Monday, January 29, 2024

Error INVALID_ETYPE_SYSLINK PRC: Transaction Import Errors

 Error INVALID_ETYPE_SYSLINK is due to Expenditure Type or Expenditure Class not matching

you need to ensure Expenditure Type is associated to the right expenditure type class


1. Check Expenditure Type setup with Expenditure Type Class

2. Verify in Transaction Import table

select EXPENDITURE_TYPE_ID , EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, START_DATE_ACTIVE, END_DATE_ACTIVE
from PA_EXPENDITURE_TYPES
where EXPENDITURE_TYPE = :EXPENDITURE_TYPE

3. Verify the system linkage between Expenditure Type and Expenditure Class linkage

select SYSTEM_LINKAGE_FUNCTION, EXPENDITURE_TYPE , START_DATE_ACTIVE, END_DATE_ACTIVE
from PA_EXPEND_TYP_SYS_LINKS
where expenditure_type = From above step
and system_linkage_function = from transaction interface

4. Make sure setups and data in the Interface table should match, if not will receive error 
5. update the interface table with correct set of data either exp type or class
6. Import the data

No comments:

Post a Comment