TeleService: FRM-40105 Unable To Resolve Reference ORA-00904 Invalid Identifier After Consolidated Patch (Oct 2012)

(Doc ID 1515957.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


In the Contact Center, Service Request Tab, when attempting to create a Service Request using a Serial Number the following error occurs.


FRM-40105: Unable to resolve reference to item control.mfg_org_id
ORA-00904: "CP"."SERIAL_NUMBER": invalid identifier
FRM-40502: ORACLE error: unable to read list of values.


The issue can be reproduced at will with the following steps:
1. Contact Center > Service Request tab
2. New > Enter serial number
=> Error appears.


 Application of Patch 14613618 - 12.1.3:BUG FIXES FOR CS: OCT'12


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