My Oracle Support Banner

TeleService - Charges Tab: Error Updating Price List - ORA-00918: Column Ambiguously Defined (Doc ID 1558003.1)

Last updated on JULY 21, 2020

Applies to:

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

Symptoms

Service Request form - Charges tab:
Receiving error message when trying to change the defaulted Price List.

Error:

ORA-00918: Column ambiguously defined
FRM-40502: ORACLE error: unable to read list of values.

Steps:

(R) Service                                                  
(N) Service Requests > Create Service Request            

 1. Query or Create a Service Request
 2. Navigate to the Charges tab
 3. Click on Price List LOV and try to perform a blank search.
 => Error is displayed: ORA-00918: Column ambiguously defined

Workaround:

Set the Profile Option 'Service: Charges - Use Long List LOV for Price List' to 'No' to avoid the error.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.