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 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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.