957338 wrote:Please see if any of the solutions in these docs help.
While applying 6678700 patch, one of the worker failed with the below error.
FNDLOAD APPS/***** 0 Y UPLOAD @ALR:patch/115/import/alr.lct @ALR:patch/115/import/US/ad_alert.ldt - Failed
Uploading from the data file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/alr.lct, /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt) to staging
Dumping LCT file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/alr.lct into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (ALR_ALERTS AD Indexes near maximum extents , ALR_ALERT_INSTALLATIONS APPS ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for ALR_ACTION_SET_MEMBERS: APPLICATION_SHORT_NAME = AD, ALERT_NAME = Tables near maximum extents, NAME = Messages to DBA,
ORA-01422: exact fetch returns more than requested number of rows
- Any idea how I can workaround the above error.