{"id":11615,"date":"2016-12-14T02:50:19","date_gmt":"2016-12-14T06:50:19","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=11615"},"modified":"2017-02-10T05:32:14","modified_gmt":"2017-02-10T09:32:14","slug":"upgrade-merge-patch-shows-the-error-loading-seed-data-for-fnd_attachment_functions","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2016\/12\/14\/upgrade-merge-patch-shows-the-error-loading-seed-data-for-fnd_attachment_functions\/","title":{"rendered":"Upgrade Merge Patch shows the Error loading seed data for FND_ATTACHMENT_FUNCTIONS"},"content":{"rendered":"

One of our trainee from previous batch was hitting issue during Upgrade from 12.1.3 to 12.2.0: Upgrade Merge Patch shows the Error loading seed data for FND_ATTACHMENT_FUNCTIONS<\/strong><\/p>\n

ERROR\/ISSUE<\/u><\/strong><\/p>\n

During Upgrade from 12.1.3 to 12.2.0: Upgrade Merge Patch throws the Error loading seed data for FND_ATTACHMENT_FUNCTIONS: FUNCTION_NAME = CSF_CSFDCMAI, FUNCTION_TYPE = F, APPLICATION_SHORT_NAME = CSF, ORA-01422: exact fetch returns more than requested number of rows<\/p>\n

Resolution:<\/u><\/strong><\/p>\n

Verify Data Duplication<\/strong><\/p>\n

Select * from FND_ATTACHMENT_FUNCTIONS where function name like ‘%CSFDCM%’;<\/p>\n

ATTACHMENT_FUNCTION_ID F FUNCTION_ID FUNCTION_NAME CREATION_ CREATED_BY LAST_UPDA LAST_UPDATED_BY<\/p>\n

LAST_UPDATE_LOGIN APPLICATION_ID SESSION_CO E<\/p>\n

———————- – ———– —————————— ——— ———- ——— ————— —————– ————– ———- –<\/p>\n

1004799 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11328 CSF_CSFDCMAI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a029-MAY-09\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 121 29-MAY-09\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 121\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 513\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Y<\/p>\n

1004800 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11328 CSF_CSFDCMAI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 29-MAY-09\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 121 29-MAY-09\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 121\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 513\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0Y<\/p>\n

Take the Backup of the following tables:<\/strong><\/p>\n