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.
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 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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms