Hello Experts,
I am using Data Management for loading metadata in EPBCS environment.
I have a metadata source file with total 69 columns and I am considering values from only 33 columns among those for loading purpose.
1) The issue I am facing is, even though after selecting those 33 fields in the Target Application and then in Import Format, I can't see all the 33 fields in the drop down list of Data Load Mappings. Instead I can see only first 25 fields.
I tried to export all the mappings in a text file and manually added the mappings for all the 33 fields and then imported, still I cant see the list of all the selected fields.
2) Secondly, after doing all the above tries, I tried to execute the data load rule created for this. But it is throwing an error below:
2019-05-08 08:32:50,221 DEBUG [AIF]: CommData.updateWorkflow - END
2019-05-08 08:32:50,222 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW
Traceback (most recent call last):
File "<string>", line 1611, in updateTDATASEG_T_TDATASEGW
SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00904: "ATTR1X": invalid identifier
What could be the reason? Any guess?
Thanks