Merged The APCC RPD With Our OSB RPD. Now Reports Error Out With [nQSError: 10058] and other nQSErrors When Querying.

(Doc ID 1680666.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Advanced Planning Command Center - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On :  12.2 version, Reports and Dashboards

We have merged the APCC RPD on top of the OSB RPD and pointed it to the same database which it is pointing to in APCC area. We are able to see the Subject area, but when querying any adhoc report it errors out.

 The RPDs were merged per user requirements - users want to login to a single application instead of multiple logins for APCC & OSB.
 
ERROR
-----------------------

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: 6510, message: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.APP_SESSION", line 315 ORA-06512: at "APPS.MSC_PHUB_UTIL", line 216 at OCI call OCIStmtExecute: call /* 20043513190 */ msc_phub_util.validate_icx_session('GSqCzeneAErfYiXTDG4xr5RkC7', '320004058', ':PASSWORD'). [nQSError: 17011] SQL statement execution failed. (HY000)
SQL Issued: SELECT 0 s_0, "Advanced Planning"."- Returns"."Returns - % of Total Sales" s_1 FROM "Advanced Planning" FETCH FIRST 10000000 ROWS ONLY


The APCC Reports work fine in our other instance where the rpd's have not been merged.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Merge the RPDs
2. Query an adhoc report in APCC
3. Note the error mentioned above

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