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