Data Migration for PROD_STRUCTURE_HEAD

Question

Hi All,I’m trying to create a data migration job for the Product Structure Header.When the structure type is ‘Manufacturing’ and if the record is already exists, I get an error ‘ORA-20112: ProdStructureHead.FND_RECORD_EXIST: The Prod Structure Head already exists.’ I have enabled modify option but it’s not letting me updating the record.I would really appreciate it if there’s any other ways we can try to make this work, please. Already tried to get the idea from the below post and unfortunately it didn’t work for me.Create Migration Jobs to Update Custom Fields(CF) | IFS Community also tried the bellow API call in objid fieldINTFACE_METHOD_LIST_API.GET_OBJID_FROM_KEY('PROD_STRUCTURE_HEAD', 'CONTRACT;PART_NO;ENG_CHG_LEVEL;BOM_TYPE_DB', CONTRACT||';'||PART_NO||';'||ENG_CHG_LEVEL||';'||BOM_TYPE_DB||';')Thank you in Advance!

FlorianTauber · Accepted Answer

Hi ​@MitDenukN,thanks for sharing.The root cause of the error message is most likely that the migration job cannot uniquely identify the record and therefore tries to create a new one.In such cases, we need to review the key composition (flags P and K).I assume that you are populating either BOM_TYPE or BOM_TYPE_DB in the source mapping.For the column that is NOT being used, the K flag must be removed in the Method List Attribute (replace it with, for example, “-” or “x”).Kind regards

MitDenukN · Answer

Hi ​@FlorianTauber, appreciate your help and your suggestion solved the issue.

Did you find what you're looking for? If not:

Sign up

Login to the community