Okcbgrid.ldt Error During 12.2.4 Update Patch (Doc ID 2106329.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Service Contracts - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Patch Application Issues

When attempting to upgrade 11i to 12.2.4, the following error occurs while running okcbgrid.ldt.

ERROR
-----------------------
Uploading from the data file /betsyk4ap/R12/fs1/EBSapps/appl/okc/12.0.0/patch/115/import/US/okcbgrid.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/betsyk4ap/R12/fs1/EBSapps/appl/jtf/12.0.0/patch/115/import/jtfgrid.lct(120.5), /betsyk4ap/R12/fs1/EBSapps/appl/okc/12.0.0/patch/115/import/US/okcbgrid.ldt) to staging tables
Dumping LCT file /betsyk4ap/R12/fs1/EBSapps/appl/jtf/12.0.0/patch/115/import/jtfgrid.lct(120.5) into FND_SEED_STAGE_CONFIG
Dumping LDT file /betsyk4ap/R12/fs1/EBSapps/appl/okc/12.0.0/patch/115/import/US/okcbgrid.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (JTF_GRID_DATASOURCES TEST_STARDUST , JTF_GRID_COLS ATTRIBUTE3 ) into FND_SEED_STAGE_ENTITY
Dumped the batch (JTF_GRID_COLS ATTRIBUTE30 , JTF_GRID_COLS APS_INVOICE_CURRENCY_CODE ) into FND_SEED_STAGE_ENTITY
Dumped the batch (JTF_GRID_COLS ARA_CASH_RECEIPT_ID , JTF_GRID_COLS CARRIER_NAME ) into FND_SEED_STAGE_ENTITY
Dumped the batch (JTF_GRID_COLS CARRIER_SERVICE_ID , JTF_GRID_COLS PRICING_ATTRIBUTE3 ) into FND_SEED_STAGE_ENTITY
Dumped the batch (JTF_GRID_COLS PRICING_ATTRIBUTE30 , JTF_GRID_SORT_COLS ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for JTF_GRID_DATASOURCES: GRID_DATASOURCE_NAME = ASO_QUOTE_VERSIONS, ORA-01403: no data found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run upgrade driver from 11i to 12.2.4
2. Check worker log and ldt log for errors

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