Invkflx.ldt Fails To Properly Load When Applying Patch 34776655 Raising Error: Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MCAT (Doc ID 3028368.1)

Last updated on JULY 26, 2024

Applies to:

Oracle Item Master - Version 12.2.13 and later
Information in this document applies to any platform.

Symptoms

As part of upgrade process to release 12.2.13, notice worker failed trying to execute invkflx.ldt. Notice following errors.

ERROR
-------

(VALUE_SET AX_INV_ACCOUNTING_CATEGORY , KEY_FLEX INV SERV ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MCAT, ORA-24344: success with compilation error
  Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MDSP, ORA-24344: success with compilation error
  Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MICG, ORA-24344: success with compilation error
  Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MKTS, ORA-24344: success with compilation error
  Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MSTK, ORA-24344: success with compilation error
  Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MTLL, ORA-24344: success with compilation error
  Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = SERV, ORA-24344: success with compilation error

STEPS
--------

1. Apply <patch 34776655> (eg ORACLE E-BUSINESS SUITE 12.2.13 RELEASE UPDATE PACK).
2. Notice several workers failed.
3. In particular, worker for file invkflx.ldt.
4. Notice errors.

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

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

Invkflx.ldt Fails To Properly Load When Applying Patch 34776655 Raising Error: Error loading seed data for KEY_FLEX: APPLICATION_SHORT_NAME = INV, ID_FLEX_CODE = MCAT (Doc ID 3028368.1)

Applies to:

Symptoms

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!