My Oracle Support Banner

Error Loading Seed Data For JTF_HOOKS_DATA: HOOK_ID = 10084, ORA-01422: Exact Fetch Returns More Than Requested NUmber of Rows (Doc ID 2071076.1)

Last updated on MARCH 20, 2024

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 /<PATH>/appl/csf/12.0.0/patch/115/import/US/csfhook.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/<PATH>/appl/jtf/12.0.0/patch/115/import/jtfhook.lct(120.4), /<PATH>/appl/csf/12.0.0/patch/115/import/US/csfhook.ldt) to staging tables
Dumping LCT file /<PATH>/appl/jtf/12.0.0/patch/115/import/jtfhook.lct(120.4) into FND_SEED_STAGE_CONFIG
Dumping LDT file /<PATH>/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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.