Fusion Applications - OTBI - "Project Control - Budgets Real Time" - Expenditure Type - ORA-12154: TNS:could not resolve the connect identifier specified (Doc ID 2128879.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Other Issues

Error generated when creating an OTBI Report Create a OTBI Report by using 2 Subject area (Project Control - Budgets Real Time & Projects Costing Actual Costs Real Time).
Try to generate the Report by Extracting the Following Columns:
1. Project Number
2. Project Name
3. Expenditure Category
4. Expenditure Type
4. Budgeted Amount
5. Actual Amount
6. Difference Between Budget & Actual

If user removes the Expenditure Type and Expenditure Category columns from the report, report works fine.

When we include them it fails with an error

ERROR
-----------------------

(View Display Error
  Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT 0 s_0, "Project Control - Budgets Real Time"."Project"."Project Name" s_1, "Project Control - Budgets Real Time"."Project"."Project Number" s_2, "Project Costing - Actual Costs Real Time"."Expenditure Type"."Resource Type Name" s_3, "Project Control - Budgets Real Time"."- Budget Cost Measures"."Current Budget Cost" s_4, "Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Raw Cost" s_5 FROM "Project Control - Budgets Real Time" WHERE ("Project"."Project Number" = 'UNO') FETCH FIRST 75001 ROWS ONLY)


STEPS
----------
The issue can be reproduced at will with the following steps:
1. Creating a OTBI Report by using 2 Subject area (Project Control - Budgets Real Time & Projects Costing Actual Costs Real Time).


Use the below Logical SQL:



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