Orcle Fusion OTBI: "Procurement - Spend Real Time" - Analysis Results In Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P (Doc ID 2125814.1)

Last updated on APRIL 11, 2016

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.10.0.0 to 11.1.10.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Technology Management - Reports/Analytics

Procurement - Spend Real Time - Analysis results in error for users

You have created an Analysis using "Procurement - Spend Real Time" and when the users try to use this Analysis they get the following error:

 

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:
Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Document Currency';SELECT 0 s_0, "Procurement - Spend Real Time"."- Liability Cost Center Segment Value"."Cost Center Code" s_1, "Procurement - Spend Real Time"."- Liability Cost Center Segment Value"."Cost Center Description" s_2, "Procurement - Spend Real Time"."- Liability Natural Account Segment Value"."Account Code" s_3, "Procurement - Spend Real Time"."- Liability Natural Account Segment Value"."Account Description" s_4, "Procurement - Spend Real Time"."Procurement BU"."Procurement Business Unit Name" s_5, "Procurement - Spend Real Time"."Procurement Item"."Category Name" s_6, "Procurement - Spend Real Time"."Time"."Month" s_7, "Procurement - Spend Real Time"."Spend"."Spend" s_8 FROM "Procurement - Spend Real Time" WHERE (("Procurement Item"."Category Name" NOT IN ('Brand Marketing', 'Audit Fees', 'Legal Fees', 'Royalties - Other', 'Rent', 'Publisher Royalties', 'Sound Recording Royalties')) AND ("Time"."Quarter" = '2015 Q 4') AND ("Procurement BU"."Procurement Business Unit Name" = 'PAN_US')) AND ("Procurement - Spend Real Time"."Procurement Item"."Category Name" IN ( SELECT "Procurement - Spend Real Time"."Procurement Item"."Category Name" FROM "Procurement - Spend Real Time" WHERE (("Procurement Item"."Category Name" NOT IN ('Brand Marketing', 'Audit Fees', 'Legal Fees', 'Royalties - Other', 'Rent', 'Publisher Royalties', 'Sound Recording Royalties')) AND ("Time"."Quarter" = '2015 Q 4') AND ("Procurement BU"."Procurement Business Unit Name" = 'PAN_US')) AND RANK(FILTER("Spen

ERROR
-----------------------
OPR4ONWY:U9IM8TAC:OI2DL65P



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