BI: ORA-12154 Errors When Trying To View Data On the Supply Chain Analyst Dashboard (Doc ID 763478.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 16-May-2011 ***
*** Checked for relevance on 04-Mar-2014 ***

Symptoms

-- Problem Statement:
On an R12.1.1 VCP Instance (using OBIEE version 10.1.3.4):

During the process of configuring the Supply Chain Analyst Dashboard in Advanced Planning Command Center.
The ASCP plan has been run successfully and the KPIs calculated and plan archived.

However, when navigating to the Supply Chain Analyst Dashboard, none of the archived plans are visible, although the 'Archive Plan Summary' (MSCHUBA) concurrent request clearly shows that the plan is archived.

Here is the error detail

Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [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: SELECT "- Plan"."Plan Name1" FROM "Advanced Planning" ORDER BY 1

Other errors include:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [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: SELECT case WHEN "- Plan".Plan = 'SCABPlanPV' then 'Baseline Plan' else 'Comparision Plan' end saw_0, "- Plan".Plan saw_1, "- Time"."Manufacturing Period Start Date" saw_2, "- Forecasting"."Shipment History" saw_3, "- Overall Plan Health"."Independent Dem Qty" saw_4, "- Forecasting"."Production history" saw_5, "- Manufacturing Efficiency"."Production plan" saw_6 FROM "Advanced Planning" WHERE (("- Plan".Plan = 'None') OR ("- Plan".Plan = 'SCABPlanPV')) ORDER BY saw_2, saw_0, saw_1 


There are other similar OCI errors as well


-- Steps To Reproduce:
Responsibility: Supply Chain Analyst

Navigation: Dashboards>> Supply Chain Analyst Dashboard

Click on the 'Archived plans' list of values (LOV), and note the following error:

Error Generating Drop Down Values

There are also additional 'View Display Error' messages shown on the page.

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