My Oracle Support Banner

Invymscv.ldt Failing During 12.2.11 Upgrade (Doc ID 2887005.1)

Last updated on AUGUST 02, 2022

Applies to:

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

Symptoms

 On : 12.2.11 version, Patch Application Issues

invymscv.ldt failing during 12.2.11 upgrade

Problem description

When the user is tryong to follow the 12.2.11 patchset drive, it is failing on invymscv.ldt with the error below:

Error

CURRENT SESSION_ID is : 36562196
CURRENT EDITION_NAME is : ORA$BASE

Uploading from the data file /u01-qal/apps/fs1/EBSapps/appl/inv/12.0.0/patch/115/import/US/invymscv.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01-qal/apps/fs1/EBSapps/appl/inv/12.0.0/patch/115/import/invvlcat.lct(120.3.12020000.4), /u01-qal/apps/fs1/EBSapps/appl/inv/12.0.0/patch/115/import/US/invymscv.ldt) to staging tables
Dumping LCT file /u01-qal/apps/fs1/EBSapps/appl/inv/12.0.0/patch/115/import/invvlcat.lct(120.3.12020000.4) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01-qal/apps/fs1/EBSapps/appl/inv/12.0.0/patch/115/import/US/invymscv.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (MTL_VALID_CATEGORY 1000000019 80864 Yard Trailer Trailer , MTL_VALID_CATEGORY 1000000021 80866 Yard Container Container ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for MTL_VALID_CATEGORY: CATEGORY_SET_ID = 1000000019, CATEGORY_ID = 80864, CATEGORY_SET_NAME = Yard Trailer, CATEGORY_NAME = Trailer, ORA-20001: An unexpected situation occurred while executing routine Valid Category Migration. The cause was: Required parameters are missing. Ensure that all the required parameters are being passed to the API call.;.
  Error loading seed data for MTL_VALID_CATEGORY: CATEGORY_SET_ID = 1000000020, CATEGORY_ID = 80865, CATEGORY_SET_NAME = Yard Power Unit, CATEGORY_NAME = Power Unit, ORA-20001: An unexpected situation occurred while executing routine Valid Category Migration. The cause was: Required parameters are missing. Ensure that all the required parameters are being passed to the API call.;Required parameters are missing. Ensure that all the required parameters are being passed to the API call.;.
  Error loading seed data for MTL_VALID_CATEGORY: CATEGORY_SET_ID = 1000000021, CATEGORY_ID = 80866, CATEGORY_SET_NAME = Yard Container, CATEGORY_NAME
 
Steps

1. Inventory responsibility
2. Apply 12.2.11 patchset

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.