Upgrade Merge Patch shows the Error loading seed data for FND_ATTACHMENT_FUNCTIONS

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

ERROR/ISSUE

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

Resolution:

Verify Data Duplication

Select * from FND_ATTACHMENT_FUNCTIONS where function name like ‘%CSFDCM%’;

ATTACHMENT_FUNCTION_ID F FUNCTION_ID FUNCTION_NAME CREATION_ CREATED_BY LAST_UPDA LAST_UPDATED_BY

LAST_UPDATE_LOGIN APPLICATION_ID SESSION_CO E

———————- – ———– —————————— ——— ———- ——— ————— —————– ————– ———- –

1004799 F       11328 CSF_CSFDCMAI                   29-MAY-09        121 29-MAY-09             121                 0            513            Y

1004800 F       11328 CSF_CSFDCMAI                   29-MAY-09        121 29-MAY-09             121                 0            513            Y

Take the Backup of the following tables:

  • FND_ATTACHMENT_FUNCTIONS
  • FND_ATTACHMENT_BLOCKS
  • FND_ATTACHMENT_BLK_ENTITIES
  • FND_DOC_CATEGORY_USAGES

For example:

Create table FND_ATTACHMENT_FUNCTIONS_bk as select * from FND_ATTACHMENT_FUNCTIONS;

Create table FND_ATTACHMENT_BLOCKS_bk as select * from FND_ATTACHMENT_BLOCKS;

Create table FND_ATTACHMENT_BLK_ENTITIES_bk as select * from FND_ATTACHMENT_BLK_ENTITIES;

Create table FND_DOC_CATEGORY_USAGES_bk as select * from FND_DOC_CATEGORY_USAGES;

Now run the following:

Delete from FND_ATTACHMENT_FUNCTIONS Where ATTACHMENT_FUNCTION_ID = 1004799;

Delete from FND_ATTACHMENT_BLK_ENTITIES where ATTACHMENT_BLK_ID in (select ATTACHMENT_BLK_ID from FND_ATTACHMENT_BLOCKS where ATTACHMENT_FUNCTION_ID = 1004799;

Delete from FND_ATTACHMENT_BLOCKS where ATTACHMENT_FUNCTION_ID = 1004799;

Delete from FND_DOC_CATEGORY_USAGES where ATTACHMENT_FUNCTION_ID =1004799;

Note: You should replace the ID as per need.

Confirm that the data is corrected.

Select * from FND_ATTACHMENT_FUNCTIONS where function_name like ‘%CSFDCM%’;

ATTACHMENT_FUNCTION_ID F FUNCTION_ID FUNCTION_NAME                  CREATION_ CREATED_BY LAST_UPDA LAST_UPDATED_BY LAST_UPDATE_LOGIN APPLICATION_ID SESSION_CO E

———————- – ———– —————————— ——— ———- ——— ————— —————– ————– ———- –

1004800 F       11328 CSF_CSFDCMAI                   29-MAY-09        121 29-MAY-09             121                 0            513            Y

If you are satisfied that the issue is resolved, proceed with the patch application.

If you want to learn more detailed then you can also join our Oracle E-Business Suite R12.2 Upgrade Training for Apps DBA’s, You will get dedicated machine with step by step activity guide and video on our membership portal to upgrade from R12.1 to 12.2.5 E-Business Suite.

Share This Post with Your Friends over Social Media!

About the Author Muhammad Rawish Siddiqui

Master in Computer Science and Post-Graduation in MIS. EDRP (EC-Council Disaster Recovery Professional), Security+, OCP 7.3, 10, 11g, 12c, 11i, R12, OCE 11i System Administration, Linux and RAC 10g, 11g, and OCS Performance Tuning. More than 18 years’ Information Technology consecutive hands-on experience, possess diversified business and technical background on a wide variety platforms, hardware and operating systems, in the Capacity of Sr. Team Lead Consultant, Sr. Database Administrator, Sr. Applications DBA, Sr. Resident Consultant and Manager Systems. Extensive experience in managing ERP environments and large Databases including Space Management, Backup and Recover, Performance Monitoring and Routine Tasks Automation. Started Oracle related Career from Oracle 6. Worked on 7, 8, 9i, 10g, 11g, 12c & e-Business 11.0.3, 11.5.9, 11.5.10.2, R12 and R12.2. Distinct Technical Jobs such as installation, migration, implementation, upgrade, cloning, and maintenance were performed dozen number of times. Security/Performance related Health Checks, RAC & Data Guard Implementation/Troubleshooting Switchover/Failover were also made during the tenure on the basis of As-When-Needed.

Leave a Comment: