My Oracle Support Banner

JTF_HOOKS_DATA ORA-01422 Error While Upgrading From 12.1.1 To 12.1.3 (Doc ID 1584484.1)

Last updated on APRIL 03, 2025

Applies to:

Oracle Common Applications - Version 12.1.1 and later
Oracle Applications DBA - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

While upgrading E-Business Suite 12.1.1 to 12.1.3 by applying patch 9239090,
the patch fails while running US_ibysppmtlgrl_ldt with the following error message

Uploading from the data file apps/apps_st/appl/iby/12.0.0/patch/115/import/US/ibysppmtlgrl.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/apps/apps_st/appl/iby/12.0.0/patch/115/import/ibypmtlgrl.lct, /apps/apps_st/appl/iby/12.0.0/patch/115/import/US/ibysppmtlgrl.ldt) to staging tables
Dumping LCT file /apps/apps_st/appl/iby/12.0.0/patch/115/import/ibypmtlgrl.lct into FND_SEED_STAGE_CONFIG
Dumping LDT file /apps/apps_st/appl/iby/12.0.0/patch/115/import/US/ibysppmtlgrl.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (IBY_PMT_LOGICAL_GRP_RULE IBY_SEPA_GRPD , IBY_PMT_LOGICAL_GRP_RULE IBY_SEPA_SNGL_ST ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for IBY_PMT_LOGICAL_GRP_RULE: SYSTEM_PROFILE_CODE = IBY_SEPA_GRPD, ORA-01407: cannot update ("IBY"."IBY_PMT_LOGICAL_GRP_RULES"."GROUP_BY_PAYMENT_FUNCTION") to NULL
 Error loading seed data for IBY_PMT_LOGICAL_GRP_RULE: SYSTEM_PROFILE_CODE = IBY_SEPA_SNGL, ORA-01407: cannot update ("IBY"."IBY_PMT_LOGICAL_GRP_RULES"."GROUP_BY_PAYMENT_FUNCTION") to NULL
 Error loading seed data for IBY_PMT_LOGICAL_GRP_RULE: SYSTEM_PROFILE_CODE = IBY_SEPA_GRPD_ST, ORA-01407: cannot update ("IBY"."IBY_PMT_LOGICAL_GRP_RULES"."GROUP_BY_PAYMENT_FUNCTION") to NULL
 Error loading seed data for IBY_PMT_LOGICAL_GRP_RULE: SYSTEM_PROFILE_CODE = IBY_SEPA_SNGL_ST, ORA-01407: cannot update ("IBY"."IBY_PMT_LOGICAL_GRP_RULES"."GROUP_BY_PAYMENT_FUNCTION") to NULL

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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