Process A Single Publication Error After Upgrade from 11.5.10 To 12.2.6 - Unable to resolve id (model ref expl id of page elements)

(Doc ID 2303048.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Configurator - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Runtime Core


When attempting to launch a model from Quoting with an associated published user interface, after an upgrade from 11.5.10 it's been observed that the generic configurator user interface is launching rather than the custom published UI. Publishing an impacted model results in the following error reported in the Concurrent Program log file

Error
-----------------------
Unable to resolve id (model ref expl id of page elements): <Failing ID>
Fatal publication error in key resolution: ORA-01403: no data found
(ResolvingId=model ref expl id of page elements)
CZ_PB_INSERT_ERR (TABLENAME=cz_ui_page_elements) (SQLERRM=ORA-01403: no data
found)
CZ_PB_EXPORT_OA_UI_ERR (SQLERRM=ORA-01403: no data found)
Error in upload of UI schema for publication id : <Publication ID>
Fatal publication error, process aborted for publication <Publicatoin ID>: ORA-01403:
no data found
Fatal publication error, process aborted for publication <Publication ID>: ORA-01403:
no data found
Parent model in publication (migration) request : <Publication ID>
Source publication : <Publication ID> target publication:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Configurator Developer

2. Schedule Concurrent Programs

3. Submit a Process a Single Publication process for impacted model

4. Error occurs, reported to log file.

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