My Oracle Support Banner

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:

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"."Expenditure Category Name" s_3,
"Project Costing - Actual Costs Real Time"."Expenditure Type"."Resource Type Name" s_4,
"Project Control - Budgets Real Time"."- Budget Cost Measures from any Budget Type"."Current Working Budget Raw Cost from any Budget Type" s_5,
"Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Raw Cost" s_6
FROM "Project Control - Budgets Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 5 ASC NULLS LAST, 4 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY



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
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.