In Unifier Mobile Application, Trying to Add a New Line Item: ORA-00960: ambiguous column naming in select list (Doc ID 2150287.1)

Last updated on JUNE 28, 2016

Applies to:

Primavera Unifier Cloud Service - Version 10.1 to 16.1.0.0 [Release 10.1 to 16.1]
Primavera Unifier - Version 10.1 to 16.1.0.0 [Release 10.1 to 16.1]
Information in this document applies to any platform.

Symptoms

When attempting to add a new line item in Unifier's Mobile Application the following error occurs.

ERROR
-----------------------
Error: /sys/mobile/action.xml:703: java.sql.SQLSyntaxErrorException: ORA-00960: ambiguous column naming in select list

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login Unifier's Mobile application
2. Click on company workspace, then click on the Business Process (BP) name.
3. Create on the New button to create a new record
4. Add line item with help of clicking on the applicable button name
5. Click New, then try to make a selection and note the following error is thrown: "Error: /sys/mobile/action.xml:703: java.sql.SQLSyntaxErrorException: ORA-00960: ambiguous column naming in select list"

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Due to this issue, users cannot add a line item through the mobile device for Unifier

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