My Oracle Support Banner

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 MARCH 16, 2020

Applies to:

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


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

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.