Error Loading Seed Data For JTF_HOOKS_DATA: HOOK_ID = 10084, ORA-01422: Exact Fetch Returns More T
(Doc ID 2071076.1)
Last updated on DECEMBER 18, 2017
Applies to:Oracle Field Service - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Installation
While applying the EBS Release 12.2.5 Patch 19676458 to upgrade from R12.2.4 to R12.2.5, one of the worker failed to execute csfhook.ldt job, from the worker log i see below error.
Uploading from the data file /ohrdshr/appdev9/122/fs2/EBSapps/appl/csf/12.0.0/patch/115/import/US/csfhook.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/ohrdshr/appdev9/122/fs2/EBSapps/appl/jtf/12.0.0/patch/115/import/jtfhook.lct(120.4), /ohrdshr/appdev9/122/fs2/EBSapps/appl/csf/12.0.0/patch/115/import/US/csfhook.ldt) to staging tables
Dumping LCT file /ohrdshr/appdev9/122/fs2/EBSapps/appl/jtf/12.0.0/patch/115/import/jtfhook.lct(120.4) into FND_SEED_STAGE_CONFIG
Dumping LDT file /ohrdshr/appdev9/122/fs2/EBSapps/appl/csf/12.0.0/patch/115/import/US/csfhook.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (JTF_HOOKS_DATA 10084 , JTF_HOOKS_DATA 12366 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for JTF_HOOKS_DATA: HOOK_ID = 10084, ORA-01422: exact fetch returns more than requested number of rows
The issue can be reproduced at will with the following steps:
1. Apply patch 19676458
The issue has the following business impact:
Due to this issue, users cannot complete the patching
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document