My Oracle Support Banner

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

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.