R12.2.4 Upgrade Patch 17919161 Fails for invymscs.ldt with ORA-01403: no data found (Doc ID 1995999.1)

Last updated on DECEMBER 19, 2015

Applies to:

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

Symptoms

While upgrading to R12.2.4, <Patch 17919161> - "ORACLE E-BUSINESS SUITE 12.2.4 RELEASE UPDATE PACK" fails for invymscs.ldt due to ORA-01403: no data found.

Error
Dumped the batch (MTL_CATEGORY_SETS 1000000019 , MTL_CATEGORY_SETS 1000000021 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables

  

Steps
1. Upgrade from 11.5.10.2 (or R12.0) to 12.2 or 12.2.4.

2. The patch fails with error.

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