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

Last updated on MARCH 08, 2017

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 /ap01/d05_applhome/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 (/ap01/d05_applhome/apps/apps_st/appl/iby/12.0.0/patch/115/import/ibypmtlgrl.lct, /ap01/d05_applhome/apps/apps_st/appl/iby/12.0.0/patch/115/import/US/ibysppmtlgrl.ldt) to staging tables
Dumping LCT file /ap01/d05_applhome/apps/apps_st/appl/iby/12.0.0/patch/115/import/ibypmtlgrl.lct into FND_SEED_STAGE_CONFIG
Dumping LDT file /ap01/d05_applhome/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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms